Hi all,
My env
oracle 11g R2 Xp Sp2 ,I am getting error while Tnsping my service name ie prod
error....
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:15:36
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\Documents and Settings\Administrator>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2010 20:19
:46
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
LSNRCTL> tnsping prod
NL-00853: undefined command "tnsping". Try "help"
LSNRCTL> exit
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:20:07
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\Documents and Settings\Administrator>lsnrctl stop
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2010 20:21
:40
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
C:\Documents and Settings\Administrator>lsnrctl start prod
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2010 20:21
:48
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
Failed to open service <OracleOraDb11g_home2TNSListenerprod>, error 1060.
TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\ora1\product\11.2.0\db2\network\admin\listener.ora
Log messages written to c:\ora1\diag\tnslsnr\friends-c0d8866\prod\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=friends-c0d8866)(PORT=15
21))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=prod)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=friends-c0d8866)(PORT=15
21))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=prod)))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 02-AUG-2010 20:21:51
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\ora1\product\11.2.0\db2\network\admin\listener.ora
Listener Log File c:\ora1\diag\tnslsnr\friends-c0d8866\prod\alert\log.xm
l
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=friends-c0d8866)(PORT=1521))(CONNECT
DATA=(SERVER=dedicated)(SERVICENAME=prod)))
The listener supports no services
The command completed successfully
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:22:00
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\Documents and Settings\Administrator>netca
Oracle Net Services Configuration:
The net service name PROD was deleted.
Default local naming configuration complete.
Created net service name: PROD
Oracle Net Services configuration successful. The exit code is 0
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:24:39
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\Documents and Settings\Administrator>lsntctl
'lsntctl' is not recognized as an internal or external command,
operable program or batch file.
C:\Documents and Settings\Administrator>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2010 20:26
:58
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace change_password
quit exit set*
show*
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=friends-c0d8866)(PORT=15
21)))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 02-AUG-2010 20:21:51
Uptime 0 days 0 hr. 5 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\ora1\product\11.2.0\db2\network\admin\listener.ora
Listener Log File c:\ora1\diag\tnslsnr\friends-c0d8866\prod\alert\log.xm
l
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=friends-c0d8866)(PORT=1521))(CONNECT
DATA=(SERVER=dedicated)(SERVICENAME=prod)))
Services Summary...
Service "prod" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
Service "prodXDB" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
C:\Documents and Settings\Administrator>tnsping
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:27:41
Copyright (c) 1997, 2006, Oracle. All rights reserved.
TNS-03502: Insufficient arguments. Usage: tnsping <address> [<count>]
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:27:48
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\Documents and Settings\Administrator>env
'env' is not recognized as an internal or external command,
operable program or batch file.
C:\Documents and Settings\Administrator>set TNS_ADMIN= C:\ora1\product\11.2.0\db
2\network\admin
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 20:28:51
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\Documents and Settings\Administrator>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2010 20:31
:27
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=friends-c0d8866)(PORT=15
21)))
The command completed successfully
LSNRCTL> trcroute
NL-00853: undefined command "trcroute". Try "help"
LSNRCTL> exit
C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 2 20:48:17 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> shut abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 318046208 bytes
Fixed Size 1374332 bytes
Variable Size 268437380 bytes
Database Buffers 41943040 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr
oduction
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
C:\Documents and Settings\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2
010 22:11:11
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name...
My lsnr conf is......................................
# listener.ora Network Configuration File: C:\ora1\product\11.2.0\db2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\ora1\product\11.2.0\db2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\ora1\product\11.2.0\db2\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = friends-c0d8866)(PORT = 1521))
)
)
prod =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = friends-c0d8866)(PORT = 1521))
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = prod)
)
)
.............................................................
Tnsname.ora is .........................
# tnsnames.ora Network Configuration File: C:\ora1\product\11.2.0\db2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = friends-c0d8866)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
................................................................
sqlnet.ora................................
s# sqlnet.ora Network Configuration File: C:\ora1\product\11.2.0\db2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
...............................................................................
I did some trails...but I am unable to resolve the error...
please let me know what parameters we need to change...
Regards,
kk