Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-10-31
12
Medium Priority
?
2,015 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-
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 

Author Comment

by:FutureDBA-
ID: 39615627
additional.

CDB = ORCL
PDB = PDBORCL
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39615638
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-
ID: 39615651
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39615658
Now open the pluggable database:
alter pluggable database PDBORCL open;
0
 

Author Comment

by:FutureDBA-
ID: 39615666
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39615671
Did you open the PDB?
0
 

Author Comment

by:FutureDBA-
ID: 39615674
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39615699
>>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-
ID: 39624353
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39624370
Should be a new question.

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

Author Comment

by:FutureDBA-
ID: 39624390
nothing has changed, i rebooted.  that's it.
0
 
LVL 77

Expert Comment

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

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

688 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