Unable to startup database [message #336799] |
Tue, 29 July 2008 01:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #336807 is a reply to message #336803] |
Tue, 29 July 2008 01:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #336815 is a reply to message #336811] |
Tue, 29 July 2008 02:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #336826 is a reply to message #336799] |
Tue, 29 July 2008 03:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #336837 is a reply to message #336830] |
Tue, 29 July 2008 03:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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..
|
|
|