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.