Oracle Apps DBA, Qatari Diar real Estate investment Company.

RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified

Oracle crontab job failed, But if run command line scripts working fine.

Executing Command : BACKUP AS COMPRESSED BACKUPSET

::::::::::::::
./src.log
::::::::::::::

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Feb 2 08:00:01 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: PROD (DBID=2595689245)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified

Soluttion:

Add this TNS_ADMIN path in the "environment scripts" file. Then Try.

export TNS_ADMIN=/a02/oracle/PROD/db/11.2.0/network/admin/PROD1_server
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:/usr/bin:/bin:$TNS_ADMIN

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Issue:

While startup the RAC database got following the error:

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'TEST1_LOCAL'

Missing below entry in RAC node tnsnames.ora file below entry.
Just add below entry to tnsname.orafile.

Solutions:

TEST1_LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=erpdevdb1-vip.xyz.com)(PORT=1551))
)

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Following executables are active :

/u01/oracle/TEST/11.2.0.3/db/lib/libclntsh.so.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /u01/oracle/TEST/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-06-22_11-39-12AM.log

Solution.

Please run below syntax Linux server.

bash$ /sbin/fuser /u01/oracle/TEST/11.2.0.3/db/lib/libclntsh.so.11.1

/sbin/fuser /u01/oracle/TEST/11.2.0.3/db/lib/libclntsh.so.11.1 4618m

kill -9 4618

Then try to apply the patch now.

While running autoconfig R12 - Autoconfig Failed with Error: FsCtxFileException: Start of Root Element Expected

Autoconfig Error :

[applTEST@hostname scripts]$ adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/oracle1/TEST/inst/apps/TEST_hostname/admin/log/05081154/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/oracle1/TEST/inst/apps/TEST_hostname
Classpath : /app/oracle1/TEST/apps/apps_st/comn/java/lib/appsborg2.zip:/app/oracle1/TEST/apps/apps_st/comn/java/classes

Using Context file : /u01/oracle1/TEST/inst/apps/TEST_hostname/appl/admin/TEST_hostname.xml

Context Value Management will now update the Context file
ERROR: FsCtxFile.XMLParseException
oracle.xml.parser.v2.XMLParseException: Start of root element expected.
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:320)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:341)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:292)
at oracle.apps.ad.autoconfig.oam.FsCtxFile.init(FsCtxFile.java:58)
at oracle.apps.ad.autoconfig.oam.FsCtxFile.overwriteCtx(FsCtxFile.java:208)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.downloadToFs(CtxSynchronizer.java:346)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysContext(FileSysDBCtxMerge.java:681)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysFiles(FileSysDBCtxMerge.java:210)
at oracle.apps.ad.context.CtxValueMgt.mergeCustomInFiles(CtxValueMgt.java:1790)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1608)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
Error occured before Context Value Management could be completed
ERROR: Context Value Management Failed.
Terminate.

The logfile for this session is located at:

/u01/oracle1/TEST/inst/apps/TEST_hostname/admin/log/05081154/adconfig.log

Solution:

Solution

To implement the solution, please execute the following steps:

1. Connect to SQL*PLUS as "APPLSYS" user.

(The "APPLSYS" password is always the same as the "APPS" user.)

2. Backup the FND_OAM_CONTEXT_FILES table, for example:

SQL> CREATE TABLE fnd_oam_context_files_bak

AS SELECT * FROM fnd_oam_context_files;

3. Truncate the FND_OAM_CONTEXT_FILES table, for example:

TRUNCATE TABLE fnd_oam_context_files;

4. Re-run Autoconfig on all nodes to repopulate the data.

APEX installation on Linux - apex_4.2.5.zip

APEX installation on Linux - Step by Step

1. Download the Apex latest version(apex_4.2.5.zip).

2. Copy apex_4.2*.zip to Linux server (/u01/APEX)

3. Unzip apex_4.2*.zip :

Create the Tablespace for APEX :

CREATE TABLESPACE apex DATAFILE '/u01/apex/oradata/apexdev/apex01.dbf' SIZE 400M AUTOEXTEND ON NEXT 1M;

4. Start APEX installation:

sqlplus "/as sysdba"

SQL > @apexins.sql APEX APEX TEMP /i/

5. Change ADMIN account password:

sqlplus "/as sysdba"

SQL > @apxchpwd.sql

*** The password must contain at least one punctuation character: (!”#$%&()“*+,-/:;?_).

6. Run the Embedded PL/SQL Gateway configuration (EPG):

sqlplus "/as sysdba"

SQL > @apex_epg_config.sql /u01/APEX (Where Apex unziped - cd /u01/APEX/apex/..)

7. Update the APEX images with those from the new release:

sqlplus "/as sysdba"

SQL > @apxldimg.sql /u01/APEX (Where Apex unziped - cd /u01/APEX/apex/..)

8. Verify the below account's unlocked and not expired:

If EXPIRED - Change password for following users : ANONYMOUS,XDB,APEX_PUBLIC_USER,FLOWS_FILES,APEX_040200.
IF LOCKED - Unlock:

ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER XDB ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
ALTER USER APEX_040200 ACCOUNT UNLOCK;

9. Run below syntax.

sqlplus "/as sysdba"
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to '*' and give APEX_040200
-- the "connect" privilege if APEX_040200
-- does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_040200', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;

10. Download webtier.

ofm_webtier_linux_11.1.1.7.0_64_disk1_1of1.zip

11. Install the webtier.

12. Copy the images folder from apex to webtier.(/u01/APEX/apex/images to webtire oracle home)

13. Copy below parameters to dads.conf file and edit password.

SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None -d
PlsqlDatabaseUsername APEX_PUBLIC_USER-d
PlsqlDatabasePassword apexpwd -d
PlsqlDatabaseConnectString system.xxxxxx.com:1521:orcl -d
PlsqlAuthenticationMode Basic -d
PlsqlDefaultPage apex -- d
PlsqlDocumentTablename wwv_flow_file_objects$ d
PlsqlDocumentPath docs -d
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download -d
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8 -d

14. Restart the opmnctl

Accessible URLs
Oracle HTTP Server URL : http://system.xxxxxxx.com:7780
Oracle HTTP Server SSL URL : https://system.xxxxxxxx.com:4443

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

Starting backup at 04-JUN-14
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1161 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/04/2014 11:43:54
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/arch/1_3259_750090831.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Solution:

Logan RMAN:

rman target=sys/password@SID catalog sysman/passowrd@rman_sid

RMAN> crosscheck archivelog all;

RMAN> delete noprompt expired archivelog all;

Then try to take full backup.

While Cluster Database upgrade from DBUA, Pre 11gR2 default listener detected old oracle home.

Find the warning below screenshot.