Hi Guys,
I am not sure whether this is the correct forum to raise this issue... Please correct me if I am wrong...
However our database worked well until our power supply got interrupted and the server was switched off couple of times. But now when we try to start the database, in services it starts up but when trying to connect it returns the error, ORA-12154: TNS:could not resolve the connect identifier specified.
Following are my findings...
C:\Users\Administrator>sqlplus sys/manager as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 14 15:52:53 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.4.0 - Production
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\10.2.0\DBTA\DATABASE\INITRACE.ORA'
My two cents tell me that the INITRACE.ORA is currepted as this file cannot be found anymore... In that case what are my options other than installing the oracle server again?
LSNRCTL Status....
C:\Users\Administrator>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 14-MAY-2013 16:03
:34
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Production
Start Date 14-MAY-2013 14:07:09
Uptime 0 days 1 hr. 56 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File c:\oracle\product\10.2.0\dbta\network\admin\listener.o
ra
Listener Log File c:\oracle\product\10.2.0\dbta\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.6)(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
Contents of the SQLNET.ORA file...
# SQLNET.ORA Network Configuration File
NAMES.DEFAULT_DOMAIN = world
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)
DELL-PC_RACE.world=
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(Host=192.168.2.6)(Port=1521)))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RACE)))
Contents of the listener.log file
TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Production on 14-MAY-2013 14:07:09
Copyright (c) 1991, 2007, Oracle. All rights reserved.
System parameter file is c:\oracle\product\10.2.0\dbta\network\admin\listener.ora
Log messages written to c:\oracle\product\10.2.0\dbta\network\log\listener.log
Trace information written to c:\oracle\product\10.2.0\dbta\network\trace\listener.trc
Trace level is currently 0
Started with pid=2004
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.6)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
14-MAY-2013 14:07:28 * (CONNECT_DATA=(SERVICE_NAME=RACE)(CID=(PROGRAM=C:\Program?Files??x86?\PLSQL?Developer\plsqldev.exe)(HOST=RANMAAL)(USER=Dell))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.86)(PORT=52141)) * establish * RACE * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
14-MAY-2013 14:07:31 * (CONNECT_DATA=(SERVICE_NAME=RACE)(CID=(PROGRAM=C:\Program?Files??x86?\PLSQL?Developer\plsqldev.exe)(HOST=RANMAAL)(USER=Dell))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.86)(PORT=52142)) * establish * RACE * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Contents of the SQLNET.log file
***********************************************************************
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.6)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=RACE)(CID=(PROGRAM=c:\oracle\product\10.2.0\dbta\jdk\jre\bin\java.exe)(HOST=TA)(USER=Administrator))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.4.0 - Production
Time: 14-MAY-2013 15:13:00
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Apologies for this long and boreing question...
Thanks...
Napster