Home » Infrastructure » Windows » Ora-0103,1250 and 12560
Ora-0103,1250 and 12560 [message #100944] Fri, 27 February 2004 06:29 Go to next message
Vincent Tsong
Messages: 2
Registered: February 2004
Junior Member
I am having a problem opening the Oracle database.  I installed it, and when I go to the Oracle DBA Studio, I can connect to the database, but when I try to open it, it gives me the following message:

ORA-01033, ORA-12500 and ORA-12560.

Can anyone help me to solve the problem?
Re: Ora-0103,1250 and 12560 [message #100972 is a reply to message #100944] Tue, 09 March 2004 10:02 Go to previous messageGo to next message
ilver
Messages: 50
Registered: January 2004
Member
Hi
If you'r able to connect, the database have to be mounted.
The errors you list looks like your not able to connect (and in fact not able to tell the status of the database, i.e started, mounted or open).
Go check the SQLNet connection by using the LSNRCTL commandline utility.

If u'r using TCP/IP network:
1: Check the TCP/IP connection to the host
2: Check that the listener are running
3: Set up the correct TNS definitions
4: Check the listener configuration by using LSNRCTL
5: Now you should be able to connect

/ilver
Re: Ora-0103,1250 and 12560 [message #100979 is a reply to message #100972] Wed, 10 March 2004 03:42 Go to previous messageGo to next message
Vincent Tsong
Messages: 2
Registered: February 2004
Junior Member
Thanks for your help.  I've tried to connect the database, but it didn't work.  The process stop at started.  I couldn't connect the database.  But, I checked the lsnrctl was started. Do I need to un/reinstall the Oracle 8.1.7?

Vincent
Re: Ora-0103,1250 and 12560 [message #100980 is a reply to message #100979] Wed, 10 March 2004 05:55 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
Hi Vincent,

Before you reinstall, try using svrmgrl (server manager line-mode). Using this you can try startup the instance and īthen the database eliminating any listerner/SQL*Net malfunctions.
If you can start the database using svrmgrl you can go on and set up the listener and after that configure the client(s) and the hopefully you'r up and running
;-)

/ilver
Previous Topic: ORA-12203, 12254
Next Topic: function
Goto Forum:
  


Current Time: Thu Mar 28 15:37:28 CDT 2024