Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR: ORA-01034: ORACLE not available while trying to connect to the PDB

Toni JuniorDec 19 2019 — edited Jan 10 2020

Hello , I am trying to connect to the PDB I could connect to 2 days ago but now I can't anymore .

pdb is opened ,I can do alter session to switch to that pdb from root ,  and then  I can query sys views or dba tables .

SQL>  select name, open_mode from v$pdbs

NAME OPEN_MODE

--------------------

PDB1 READ WRITE

But when I try to connect with sqldeveloper or sqlplus , it fails , as the instance is down .

sqlplus test1/password@hostname.com:1521/PDB1

SQL*Plus: Release 12.2.0.1.0 Production on Thu Dec 19 09:14:44 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved.

ERROR: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory

Additional information: 3701 Additional information: -1520736149

Process ID: 0 Session ID: 0 Serial number: 0

Is this about the 'services'  maybe ?

If it is , how can I start the service for that pdb ?

Comments

Post Details

Added on Dec 19 2019
8 comments
6,259 views