I'm trying to connect newly created pluggable database. But it's throwing database not available error and when I check open_mode is read/write for mypdb1.
Can you please help me where I'm doing mistake? I'm struggling with this more than a week.
listener.ora :
LSNRB12C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = adc40)(PORT = 1550))
)
)
SID_LIST_LSNRB12C =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = B12C)
(ORACLE_HOME = /oracle/AIX/12102_64)
(SID_NAME = B12C)
)
(SID_DESC =
(ORACLE_HOME = /oracle/AIX/12102_64)
(SID_NAME =MYPDB1)
)
)
tnsnames.ora for pluggable database:
MYPDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adc40)(PORT = 1550))
)
(CONNECT_DATA =
(SERVICE_NAME = MYPDB1)
)
)
adc40 {oracle}:>lsnrctl status LSNRB12C
LSNRCTL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production on 09-SEP-2015 21:56:44
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adc40)(PORT=1550)))
STATUS of the LISTENER
------------------------
Alias LSNRB12C
Version TNSLSNR for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production
Start Date 08-SEP-2015 23:21:16
Uptime 0 days 22 hr. 35 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/AIX/12102_64/network/admin/listener.ora
Listener Log File /oracle/AIX/diag/tnslsnr/adc40/lsnrb12c/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adc40)(PORT=1550)))
Services Summary...
Service "B12C" has 1 instance(s).
Instance "B12C", status UNKNOWN, has 1 handler(s) for this service...
Service "MYPDB1" has 1 instance(s).
Instance "MYPDB1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
adc40 {oracle}:>env |grep ORACLE
ORACLE_BASE=/oracle/AIX
ORACLE_SID=B12C
ORACLE_HOME=/oracle/AIX/12102_64
adc40 {oracle}:>sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 9 22:01:50 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select NAME,OPEN_MODE,RESTRICTED from v$pdbs;
NAME OPEN_MODE RES
------------------------------ ---------- ---
PDB$SEED READ ONLY NO
MYPDB1 READ WRITE NO
MYPDB2 READ WRITE NO
MYPDB3 READ WRITE NO
SQL> create user c##1 identified by oracle container=all;
User created.
SQL> grant create session to C##1 container=all;
Grant succeeded.
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=mypdb1;
Session altered.
SQL> sho con_name
CON_NAME
------------------------------
MYPDB1
SQL> connect c##1/oracle@adc40:1550/b12c
Connected.
SQL> connect c##1/oracle@adc40:1550/mypdb1
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
Additional information: 2311
Additional information: 186818867
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
Can you please tell me why it shows database not available even though mypdb is open ?