Solved

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

Posted on 2013-10-31
12
1,829 Views
Last Modified: 2013-11-05
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)
0
Comment
Question by:FutureDBA-
  • 6
  • 6
12 Comments
 

Author Comment

by:FutureDBA-
Comment Utility
additional.

CDB = ORCL
PDB = PDBORCL
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
 

Author Comment

by:FutureDBA-
Comment Utility
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
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
Now open the pluggable database:
alter pluggable database PDBORCL open;
0
 

Author Comment

by:FutureDBA-
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Did you open the PDB?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:FutureDBA-
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>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
 

Author Comment

by:FutureDBA-
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Should be a new question.

Until you open the new question, does that init.ora file exist?
What changed?
0
 

Author Comment

by:FutureDBA-
Comment Utility
nothing has changed, i rebooted.  that's it.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Open the new question and we'll help you out.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now