Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-10-31
12
Medium Priority
?
2,061 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-
ID: 39615627
additional.

CDB = ORCL
PDB = PDBORCL
0
 
LVL 78

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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 78

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 78

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 78

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 78

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 78

Expert Comment

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

916 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