Home » SQL & PL/SQL » Client Tools » failure in testing a connection in 12c database (windows8)
failure in testing a connection in 12c database [message #667497] Tue, 02 January 2018 07:09 Go to next message
7anona
Messages: 68
Registered: February 2012
Member
hello

I'm new in this
I've just installed the database
when I try to add new connection from the sql developer
I'm getting a failure
ora01033 ORACLE initialization or shutdown in progress

can any one help with this
thank you in advance
Re: failure in testing a connection in 12c database [message #667498 is a reply to message #667497] Tue, 02 January 2018 07:09 Go to previous messageGo to next message
BlackSwan
Messages: 26194
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: failure in testing a connection in 12c database [message #667500 is a reply to message #667498] Tue, 02 January 2018 07:43 Go to previous message
Solomon Yakobson
Messages: 2806
Registered: January 2010
Location: Connecticut, USA
Senior Member
ora01033 ORACLE initialization or shutdown in progress means your database isn't started. Keep in mind, if your database is container database starting database starts, by default, just the container. You have to open pluggable database using ALTER PLUGGABLE DATABASE xxx OPEN; You will either have to do it each time you start container or (starting 12.1.0.2) you can start pluggable and issue ALTER PLUGGABLE DATABASE xxx SAVE STATE; then pluggable database xxx will be automatically started when you start container database.

SY.
Previous Topic: ORA-00942: table or view does not exist
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Fri Oct 19 05:01:05 CDT 2018