Oracle wont start after reboot (oracle 12c (12.1.0))

DBMS: = Oracle 12c
OS: = Oracle Linux 2.6.39-400.17.1.el6uek.x86_64
ORACLE_HOME = /home/oracle/app/oracle/product/12.1.0/dorasnat
ORACLE_SID = ORCL

Open in new window


/etc/hosts
127.0.0.1       localhost       localhost.localdomain
127.0.0.1	oerms		oerms.mydomain.com
192.168.16.252  oerms           oerms.mydomain.com
192.168.16.196  p-oracle        p-oracle.mydomain.com
192.168.16.194  orcltggw

Open in new window


/home/oracle/app/oracle/product/12.1.0/dorasnat/network/admin/tnsnames.ora
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oerms)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


DG=
   (DESCRIPTION=
      (ADDRESS=
         (PROTOCOL=TCP)
         (HOST=192.168.16.194)
         (PORT=1521)
      )
      (CONNECT_DATA=
         (SID=dg4msql))
      (HS=OK))

Open in new window



/home/oracle/app/oracle/product/12.1.0/dorasnat/network/admin/listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = oerms)(PORT = 1521))
    )
  )

Open in new window



[oracle@oerms admin]$ echo $ORACLE_HOME
/home/oracle/app/oracle/product/12.1.0/dorasnat
[oracle@oerms admin]$ echo $ORACLE_SID
ORCL

Open in new window



[oracle@oerms admin]$ lsnrctl

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-OCT-2013 19:57:33

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
LSNRCTL> stat
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date                31-OCT-2013 19:54:37
Uptime                    0 days 0 hr. 2 min. 59 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/12.1.0/dorasnat/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/oerms/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oerms)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL> serv
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
LSNRCTL>

Open in new window




when i try to connect to oracle via sqldeveloper. i get ORA-12514, TNS:listener does not currently know of service requested in connect descriptor.

everything was working fine until i had to reboot to change hardware settings on VM (went from 1 core to 16, irrelevant IMO)
FutureDBA-Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Now open the pluggable database:
alter pluggable database PDBORCL open;
0
 
FutureDBA-Author Commented:
additional.

CDB = ORCL
PDB = PDBORCL
0
 
slightwv (䄆 Netminder) Commented:
Try manually starting the database:
sqlplus / as sysdba
SQL> startup


It might be that the rc scripts aren't set up or the /etc/oratab file isn't correct.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
FutureDBA-Author Commented:
that seems to have worked, but im not completely back up again. i can connect as sysdba via sqldeveloper. but my PDB is still down.

when i connect via sqldeveloper, and try to expand the tables node .. i get

ORA-01219: database or pluggable database not open: queries allowed on fixed tables or via

[oracle@oerms admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 31 20:12:19 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 6714322944 bytes
Fixed Size                  3483248 bytes
Variable Size            3925870992 bytes
Database Buffers         2768240640 bytes
Redo Buffers               16728064 bytes
Database mounted.
Database opened.
SQL>

Open in new window

0
 
FutureDBA-Author Commented:
when i try connecting as a a regular user and not sysdba to my PDB,

I get ORA-01033: initialization or shutdown in progress
0
 
slightwv (䄆 Netminder) Commented:
Did you open the PDB?
0
 
FutureDBA-Author Commented:
slightwv, you're a life saver..

Thank you very much, that worked...

still familiarizing myself with 12c, the multi arch is a new ball game from an admin side.
0
 
slightwv (䄆 Netminder) Commented:
>>the multi arch is a new ball game from an admin side.

Agreed.  I haven't really started digging into it all myself.

I've looked for the correct doc link on automatic startup in a Unix environment but cannot locate the specifics.

For example: How to automatically startup the CDB and a select PDB and not all PDB's.

It has to be possible and I'm sure it is in the docs somewhere.  Just cannot find it.
0
 
FutureDBA-Author Commented:
Can this be revisited if it's for the same issue? Or should i start a new thread.

Same issue, except now I get

[oracle@oerms admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Tue Nov 5 09:47:20 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/12.1.0/dorasnat/dbs/initORCL.ora'

Open in new window

0
 
slightwv (䄆 Netminder) Commented:
Should be a new question.

Until you open the new question, does that init.ora file exist?
What changed?
0
 
FutureDBA-Author Commented:
nothing has changed, i rebooted.  that's it.
0
 
slightwv (䄆 Netminder) Commented:
Open the new question and we'll help you out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.