10g DB startup error

[abc73]

Hi,
I installed 10g but when I get the following on Enterprise Manager:

The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation.

I click on start-up and gets the following error:

SQLException  
Listener refused the connection with the following error: ORA-12500, TNS:listener failed to start a dedicated server process The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)..........................................
..........

Can someone please help me how to fix this error.

Thanks

 

[psilons]

It seems like the database is not started. To make sure, shutdown the database from SQL*PLUS with this command "shutdown immediate" and "startup" to restar the database.

Also, make sure the listener is started by typing this command from shell prompt (unix) or command prompt (Windows): "lsnrctl status". If it's not started type "lsnrctl start" command.

 

[abc73]

I followed the above sequence of shutting down and starting the database the results:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145750508 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.

starting the listner gives me the following result:

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-MAR-2005 08:57
:42
Copyright (c) 1991, 2004, Oracle.  All rights reserved.
Starting tnslsnr: please wait...
Failed to open service <OracleOraDb10g_home1TNSListener>, error 1060.
TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
System parameter file is C:\ora10db\network\admin\listener.ora
Log messages written to C:\ora10db\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)
))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.100)(PORT=1521
)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date                18-MAR-2005 08:57:44
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\ora10db\network\admin\listener.ora
Listener Log File         C:\ora10db\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.100)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

But when I go to Entrprise EM Console
I get the same error:

SQLException  
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.100)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

I have Oracle DB9i, and Oracle AS9i installed on the same machine too and looks like PORT=1521 is being used by DB 9i too. Any help is appreciated.

Thanks

 

[dbtoo2001]

listener does not currently know of service requested"

Is your database instance in the listener.ora file?

 

[stefanwagner]

Maybe you may specify a different port for ora10g in the file C:\ora10db\network\admin\listener.ora

Or stop 9i to see, if 10gEM will start then.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung