| Ora-0103,1250 and 12560 [message #100944] |
Fri, 27 February 2004 06:29  |
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  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
