- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ERROR: ORA-01034: ORACLE not available while trying to connect to the PDB
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
PDB1 READ WRITE
But when I try to connect with sqldeveloper or sqlplus , it fails , as the instance is down .
sqlplus test1/[email protected]:1521/PDB1
SQL*Plus: Release 126.96.36.199.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 ?