Hi All,
I am using AIX 7.1
Just upgraded from 11.2.0.2 to 11.2.0.4
The upgrade seemed to go fine, no errors really. Once I was finished with the DBUA I edited my listener config to point the SID at the new oracle home. I then reloaded the listener.
NOTE: This listener is working on this oracle home for another instance which I have removed for this post.
----------------------------------------------------------------------------------------------------------------------------------------
[BW3DR] $ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-SEP-2015 09:51:23
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.21.63.165)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 01-FEB-2015 08:41:21
Uptime 233 days 0 hr. 10 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /xx/u01b/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /xx/u01b/app/oracle/diag/tnslsnr/om2orapb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.63.165)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.63.181)(PORT=1521)))
Services Summary...
Service "BW3DR" has 1 instance(s).
Instance "BW3DR", status UNKNOWN, has 1 handler(s) for this service...
Service "BW3DR_OM2ORAPB" has 1 instance(s).
Instance "BW3DR", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Listener File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = BW3DR)
(ORACLE_HOME = /xx/u01b/app/oracle/product/11.2.0.4.B)
(SID_NAME = BW3DR)
)
(SID_DESC =
(GLOBAL_DBNAME = BW3DR_OM2ORAPB)
(ORACLE_HOME = /xx/u01b/app/oracle/product/11.2.0.4.B)
(SID_NAME = BW3DR)
)
)
DYNAMIC_REGISTRATION_LISTENER = off
----------------------------------------------------------------------------------------------------------------------------------------
So the database is started up:
[BW3DR] $ ps -ef | grep pmon | grep BW3DR
oracle 16908634 1 0 09:12:44 - 0:00 ora_pmon_BW3DR
When not using sqlnet I can successfully log into the instance with no problems.
[BW3DR] $ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 22 09:43:31 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Is is only when I use the sqlnet that I have problems.
[BW3DR] $ sqlplus sys@BW3DR as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 22 09:46:52 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL>
and when I try connect not as SYS I get the following:
[BW3DR] $ sqlplus dba_jobs_test@BW3DR
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 22 09:47:38 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
My enviormental variables are set when I run . setenv <SID>
PATH - /usr/local/scripts/oracle:/xx/u01b/app/oracle/product/11.2.0.4.B/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.:/usr/local/bin:/usr/java14/bin
ORACLE_HOME - /xx/u01b/app/oracle/product/11.2.0.4.B
ORACLE_BASE - /xx/u01b/app/oracle
ORACLE_SID - BW3DR
tnsping shows the following:
[BW3DR] $ tnsping BW3DR
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-SEP-2015 09:55:38
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/xx/u01b/app/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xxx)(PORT = 1521))) (CONNECT_DATA =(SID = BW3DR)(SERVER = DEDICATED)))
OK (0 msec)
Im pulling my hair out here, cant anyone help me figure out when I cant connect using sqlnet.
Regards.