Home » RDBMS Server » Server Administration » Unable to startup database
Unable to startup database [message #336799] Tue, 29 July 2008 01:22 Go to next message
qabutz
Messages: 6
Registered: July 2008
Junior Member
i have 3 databases installed on my laptop and all are working perfectly fine until i perform a shutdown.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup open
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

I checked the listener and its working fine too.

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.35.101)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
)

however, when i restart the database using the OS services the database is up. what could be the problem?
Re: Unable to startup database [message #336803 is a reply to message #336799] Tue, 29 July 2008 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Didn't you try to remotely connect?
Quit SQL*Plus and retry.

Regards
Michel
Re: Unable to startup database [message #336807 is a reply to message #336803] Tue, 29 July 2008 01:47 Go to previous messageGo to next message
qabutz
Messages: 6
Registered: July 2008
Junior Member
I did try that using sysdba again and i get the same message:

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 29 10:41:57 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:

Re: Unable to startup database [message #336810 is a reply to message #336807] Tue, 29 July 2008 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again how do you connect?
Post the connect string.

Regards
Michel
Re: Unable to startup database [message #336811 is a reply to message #336799] Tue, 29 July 2008 01:54 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Set your oracle home,path, oracle sid correctly and try.
Whats your OS?
Re: Unable to startup database [message #336812 is a reply to message #336810] Tue, 29 July 2008 01:57 Go to previous messageGo to next message
qabutz
Messages: 6
Registered: July 2008
Junior Member
sqlplus sys/oracle@batelco as sysdba
Re: Unable to startup database [message #336815 is a reply to message #336811] Tue, 29 July 2008 02:03 Go to previous messageGo to next message
qabutz
Messages: 6
Registered: July 2008
Junior Member
C:\>SET ORACLE_SID=BATELCO

C:\>SQLPLUS SYS/ORACLE@BATELCO AS SYSDBA

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 29 10:56:11 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:


My OS is XP and my oracle home path is default

Re: Unable to startup database [message #336817 is a reply to message #336812] Tue, 29 July 2008 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a local connection not a remote one (that is with @...)

Regards
Michel
Re: Unable to startup database [message #336822 is a reply to message #336817] Tue, 29 July 2008 02:30 Go to previous messageGo to next message
qabutz
Messages: 6
Registered: July 2008
Junior Member
yehey!!! THANKS!

i would always use the remote connection (@) because i have 3 databases on my laptop. after i set the oracle_sid and used the local connection it worked fine.

thanks michel Razz
Re: Unable to startup database [message #336826 is a reply to message #336799] Tue, 29 July 2008 03:03 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Its good that you can connect but the problem is yet the same.
Why this error:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Post

lsnrctl status
Re: Unable to startup database [message #336830 is a reply to message #336826] Tue, 29 July 2008 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The issue is that when database is not up it is not registered in listener and then you can't connect to it.

Regards
Michel
Re: Unable to startup database [message #336837 is a reply to message #336830] Tue, 29 July 2008 03:24 Go to previous message
qabutz
Messages: 6
Registered: July 2008
Junior Member
gotcha!! thanks michel...

as for varu123. the post was a previous one which still used the remote connection. by defining the oracle_sid then the local connection immediately it works.. Smile
Previous Topic: space issue
Next Topic: Extend filesystem - External device
Goto Forum:
  


Current Time: Mon Dec 05 19:20:51 CST 2016

Total time taken to generate the page: 0.10991 seconds