配置静态监听解决ORA-12514错误的案例(转)

ORALOCAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =  (CONNECT_DATA =  (SERVICE_NAME = oralocal) ) )

 

 

总结了下要注意的几点

Service “PLSExtProc” has 1 instance(s).

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:39

Enter user-name: ERROR:ORA-01017: invalid username/password; logon
denied

Trace Level               off

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))  
STATUS of the LISTENER  
————————  
Alias                     LISTENER  
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 –
Production  
Start Date                29-APR-2009 18:43:13  
Uptime                    6 days 21 hr. 43 min. 49 sec  
Trace Level               off  
Security                  ON: Local OS Authentication  
SNMP                      OFF  
Listener Parameter File  
/u01/app/oracle/product/11.1.0/network/admin/listener.ora  
Listener Log File        
/u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml  
Listening Endpoints Summary…  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))  
Services Summary…  
Service “devdb” has 1 instance(s).  
Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…  
Service “devdb.thegeekstuff.com” has 1 instance(s).  
Instance “devdb”, status READY, has 1 handler(s) for this service…  
Service “devdbXDB.thegeekstuff.com” has 1 instance(s).  
Instance “devdb”, status READY, has 1 handler(s) for this service…  
Service “devdb_XPT.thegeekstuff.com” has 1 instance(s).  
Instance “devdb”, status READY, has 1 handler(s) for this service…  
The command completed successfully
$ lsnrctl status

按照如下过程,一般都能解决:在虚拟机内开cmd,用lsnrctl
status查看监听器监听的服务
如看到监听服务“orcl”,那在本机的tns配置中必须写orcl;如果想要自定义,则在虚拟机内的listener配置中就要加入自定义服务名,记得要重启监听服务:lsnrctl
reload 最后形成的配置文件如下 虚拟机listener:

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory

1.安装服务端是一般选“基本安装”就行2.使用PLSQL Developer时,“ORA-12154
TNS无法解析指定的连接标识符”的问题安装时报后边的错“warning some oracle
net versions cannot connect from a path with
parentheses”,这错原来提示了,不能有括号,修改了安装路径就没有问题了相应的上边的“ORA-12154
TNS无法解析指定的连接标识符”错也没啦,有点晕,没整明白,但确实好啦3.“ORA-12154
TNS无法解析指定的连接标识符”按照网上的方法有两种,但我试了,在我这都不好使,下边贴出来,没准儿啥时候可以用1.解决办法,修改PLSQL
Developer的选项设置:客户端、服务器端Oracle软件装好之后,用PLSQL
Devloper登录时,点击取消,进入PLSQL
Developer主界面,菜单Tools-Preferences,在设置窗口中,选择Oracle-Connection,对应设置窗口中,找到Oracle
Home,选择OraDb10g_home1,保存设置,重新登录PLSQL Developer即可

 

view plaincopy to clipboardprint?
$ lsnrctl reload  

2.修改D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN路径下的tnsnames.ora文件######
一般的配置
##################################

The command completed successfully

4.重启oracle监听器

其它网友的补充:

Listening Endpoints Summary…

对于DBA来说,启动和关闭oracle监听器是很基础的任务,但是Linux系统管理员或者程序员有时也需要在开发数据库中做一些基本的DBA操作,因此了解一些基本的管理操作对他们来说很重要。

再次连接,问题解决!记住,一定从最简单的原因找起,不要一上去就看到网上的什么改process数、注册表之类的,要想想本机能连为什么通过网络就不行,还是定位问题。VS2008连接oracle
出现错误 ora-12154 tns 无法解析指定的连接标示符

 

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
17:03:31

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting
SQL*Plus[oracle@rac2 admin]$ sqlplus cy/zh@rac2SQL*Plus: Release
9.2.0.4.0 – Production on Tue Mar 4 08:32:59 2008Copyright 1982, 2002,
Oracle Corporation. All rights reserved.ERROR:ORA-12154: TNS:could not
resolve service name

Used parameter files:

rawmode                     displaymode  
rules                       trc_file  
trc_directory               trc_level  
log_file                    log_directory  
log_status                  current_listener  
inbound_connect_timeout     startup_waittime  
snmp_visible                save_config_on_stop  
dynamic_registration

今天装oracle安装都完成了,但出现了“ORA-12154
TNS”的错误,最开始以为是oracle安装处了问题,但后来发现并不是,因为用SQL
Plus可以登录,只是用plsql登录时才出现这错,用360完全卸载了qlsql后,从新装了次,还是那错,郁闷。。。后来又把数据库删掉重新建立,还是不行,整了半天,最后自己都整晕了,算了,重头再来吧。。。百度下很多安装图解,按着来就成

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd)(PORT=1521)))

如果oracle监听器正在运行,你将得到如下信息

Enter user-name:

 

start               stop                status
services            version             reload
save_config         trace               spawn
change_password     quit                exit
set*                show*

在保证你的代码没有错误的前提下:检查OracleOraDb10g_home1TNSListener
服务有没有启动,即监听服务检查tnsnames.ora是否添加连接串,其路径一般是:%Oracle_home%product10.2.0db_1NETWORKADMINtnsnames.ora

# Generated by Oracle configuration tools.

view plaincopy to clipboardprint?
$ lsnrctl start  

Enter user-name: cy/zh@rac1ERROR:ORA-12154: TNS:could not resolve
service name

    (SID_DESC =

2.启动oracle监听器

配置好rac后,两个节点用tnsping都可以ping通,但用sqlplus连接都出现以下错误,不知道哪里出了问题[oracle@rac2
admin]$ lsnrctl statusLSNRCTL for Linux: Version 9.2.0.4.0 – Production
on 04-MAR-2008 08:32:26Copyright 1991, 2002, Oracle Corporation. All
rights reserved.Connecting to (DESCRIPTION=(ADDRESS=))STATUS of the
LISTENER————————Alias LISTENERVersion TNSLSNR for Linux:
Version 9.2.0.4.0 – ProductionStart Date 04-MAR-2008 08:29:03Uptime 0
days 0 hr. 3 min. 22 secTrace Level offSecurity OFFSNMP OFFListener
Parameter File /home/oracle/9.2.0.4/network/admin/listener.oraListener
Log File /home/oracle/9.2.0.4/network/log/listener.logListening
Endpoints Summary… (DESCRIPTION=(ADDRESS=))Services Summary…Service
“PLSExtProc” has 1 instance. Instance “PLSExtProc”, status UNKNOWN, has
1 handler for this service…Service “esal” has 2 instance. Instance
“rac1”, status READY, has 1 handler for this service… Instance “rac2”,
status READY, has 1 handler for this service…The command completed
successfully[oracle@rac2 admin]$ lsnrctl serviceLSNRCTL for Linux:
Version 9.2.0.4.0 – Production on 04-MAR-2008 08:32:32Copyright 1991,
2002, Oracle Corporation. All rights reserved.Connecting to
(DESCRIPTION=(ADDRESS=))Services Summary…Service “PLSExtProc” has 1
instance. Instance “PLSExtProc”, status UNKNOWN, has 1 handler for this
service… Handler: “DEDICATED” established:0 refused:0 LOCAL
SERVERService “esal” has 2 instance. Instance “rac1”, status READY, has
1 handler for this service… Handler: “DEDICATED” established:0
refused:0 state:ready REMOTE SERVER (address=) Instance “rac2”, status
READY, has 1 handler for this service… Handler: “DEDICATED”
established:0 refused:0 state:ready LOCAL SERVERThe command completed
successfully[oracle@rac2 admin]$ sqlplus cy/zh@esalSQL*Plus: Release
9.2.0.4.0 – Production on Tue Mar 4 08:32:45 2008Copyright 1982, 2002,
Oracle Corporation. All rights reserved.ERROR:ORA-12154: TNS:could not
resolve service name

 

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))  
The command completed successfully
$ lsnrctl reload

oracle完全卸载//www.jb51.net/article/96395.htm或者直接在注册表中按F3搜索oracle,删除注册文件,不过貌似文件有点多,操作有点慢,建议用上边链接的方法

原来dest_id=2的那个远程归档路径的ORA-12514的问题解决了,此时归档日志就可以通过网路远程传输到备库相应的归档路径中了,再执行redo
apply也不会有任何问题了。

lsnrctl hep命令可以显示所有可用的监听器命令。在oracle11g中其输出如下:

oracle服务端安装图解//www.jb51.net/article/108555.htmoracle客户端安装图解//www.jb51.net/article/108556.htm

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
prd)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= prd)))

TNSLSNR for Linux: Version 11.1.0.6.0 – Production
System parameter file is
/u01/app/oracle/product/11.1.0/network/admin/listener.ora
Log messages written to
/u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

SID_LIST_LISTENER = (SID_LIST = (SID_DESC =  自定义服务名 (ORACLE_HOME = E:oracleproduct10.2.0db_1) db_home  (SID_DESC =  (SID_NAME = PLSExtProc) (ORACLE_HOME = E:oracleproduct10.2.0db_1) ##这个服务保证你可以使用外部过程,如C程序 ) )

ORCL_XNJ = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =  (CONNECT_DATA =  与自定义服务名对应 ) )

    (SID_DESC =

如果oracle监听器没用运行,你可以用lsnrctl
start命令启动oracle监听器,该命令将启动所有的监听器,如果你只想启动特定的监听器,可以再start后面指定监听器的名字,例如:lsnrctl
start [listener-name]。

Start Date                08-OCT-2014 10:34:51

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:42

  Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this
service…

用lsnrctl reload重启监听器,此命令可以代替lsnrctl stop和lsnrctl
start。重启将会在不需要关闭和启动监听器的情况下读取listener.ora的配置。

         1

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

  (DESCRIPTION_LIST =

 

         5                      INACTIVE

监听器的启动时间
监听器的运行时间
监听器参数文件listener.ora的位置,通常位于$ORACLE_HOME/network/admin目录下
监听器日志文件的位置
如果oracle监听器没用运行,你将得到如下的信息

   DEST_ID STATUS    ERROR

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))  
The command completed successfully
$ lsnrctl stop

STATUS of the LISTENER

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

  )

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 –
Production
Start Date                04-APR-2009 16:27:42
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  
/u01/app/oracle/product/11.1.0/network/admin/listener.ora
Listener Log File        
/u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary…
Service “devdb” has 1 instance(s).
Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

 

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))
The command completed successfully

LSNRCTL for Linux: Version 10.2.0.5.0 – Production on 08-OCT-2014
12:57:25

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:02  

 

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:12:09  


view plaincopy to clipboardprint?
$ lsnrctl stop  

OK (20 msec)

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

 

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 –
Production
Start Date                29-APR-2009 18:43:13
Uptime                    6 days 21 hr. 43 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  
/u01/app/oracle/product/11.1.0/network/admin/listener.ora
Listener Log File        
/u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary…
Service “devdb” has 1 instance(s).
Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…
Service “devdb.thegeekstuff.com” has 1 instance(s).
Instance “devdb”, status READY, has 1 handler(s) for this service…
Service “devdbXDB.thegeekstuff.com” has 1 instance(s).
Instance “devdb”, status READY, has 1 handler(s) for this service…
Service “devdb_XPT.thegeekstuff.com” has 1 instance(s).
Instance “devdb”, status READY, has 1 handler(s) for this service…
The command completed successfully

   DEST_ID ERROR                STATUS

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:22:28  

    (DESCRIPTION =

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))  
TNS-12541: TNS:no listener  
TNS-12560: TNS:protocol adapter error  
TNS-00511: No listener  
Linux Error: 111: Connection refused  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))  
TNS-12541: TNS:no listener  
TNS-12560: TNS:protocol adapter error  
TNS-00511: No listener  
Linux Error: 2: No such file or directory
$ lsnrctl status

         7

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:39  


1.查看所有的监听器命令


The following operations are available after show  
An asterisk (*) denotes a modifier or extended command:  

         3                      INACTIVE

Starting /u01/app/oracle/product/11.1.0/bin/tnslsnr: please wait…

Service “prd” has 1 instance(s).

view plaincopy to clipboardprint?
$ lsnrctl status  

Service “std” has 1 instance(s).

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

         8                      INACTIVE

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

 

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

         9                      INACTIVE

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))  
STATUS of the LISTENER  
————————  
Alias                     LISTENER  
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 –
Production  
Start Date                04-APR-2009 16:27:42  
Uptime                    0 days 0 hr. 0 min. 0 sec  
Trace Level               off  
Security                  ON: Local OS Authentication  
SNMP                      OFF  
Listener Parameter File  
/u01/app/oracle/product/11.1.0/network/admin/listener.ora  
Listener Log File        
/u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml  
Listening Endpoints Summary…  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))  
Services Summary…  
Service “devdb” has 1 instance(s).  
Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…  
澳门金沙vip,The command completed successfully
$ lsnrctl start

TNS Ping Utility for Linux: Version 10.2.0.5.0 – Production on
08-OCT-2014 12:39:40

        10                      INACTIVE

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))
The command completed successfully

    )

在启动、关闭或者重启oracle监听器之前确保使用lsnrctl
status命令检查oracle监听器的状态。除了得到监听器的状态之外,你还可以从lsnrctl
status命令的输出中得到如下的信息:

Service “prdXDB” has 1 instance(s).

怎样启动、关闭和重新启动oracle监听器

         6 INACTIVE

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:12:09

  (DESCRIPTION_LIST =

The following operations are available  
An asterisk (*) denotes a modifier or extended command:  

         4 INACTIVE

The following operations are available
An asterisk (*) denotes a modifier or extended command:

Start Date                08-OCT-2014 09:41:41

Copyright (c) 1991, 2007, Oracle. All rights reserved.

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Starting /u01/app/oracle/product/11.1.0/bin/tnslsnr: please wait…  

SNMP                      OFF

可以使用lsnrctl help得到指定的命令的详细帮助信息。如下所示

    )

Copyright (c) 1991, 2007, Oracle. All rights reserved.

# Generated by Oracle configuration tools.

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:42  

      (SID_NAME = PLSExtProc)

start               stop                status  
services            version             reload  
save_config         trace               spawn  
change_password     quit                exit  
set*                show*
$ lsnrctl help

 

2.得到指定监听器命令的详细帮助信息

    )

view plaincopy to clipboardprint?
$ lsnrctl status  

Service “prd_XPT” has 1 instance(s).

3.关闭oracle监听器

 

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
17:03:31  

Service “PLSExtProc” has 1 instance(s).

      本文将讨论用LSNRCTL命令启动、关闭和查看监听器的状态的方法。

 

Copyright (c) 1991, 2007, Oracle. All rights reserved.  

 

Oracle监听器帮助

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

view plaincopy to clipboardprint?
$ lsnrctl help show  

 

Copyright (c) 1991, 2007, Oracle. All rights reserved.

  Instance “prd”, status READY, has 1 handler(s) for this service…

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:02

注意,加上的内容中,SID_NAME,即instance_name,而GLOBAL_DBNAME,即tnsnames.ora中的SERVICE_NAME,由于tnsnames.ora中的SERVICE_NAME都是prd,因此这里的两个名字是一样的,不会有什么影响,把修改好的文件替换掉原文件,再重新加载监听文件

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

TNSLSNR for Linux: Version 11.1.0.6.0 – Production  
System parameter file is
/u01/app/oracle/product/11.1.0/network/admin/listener.ora  
Log messages written to
/u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml  
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))  
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))  

# listener.ora Network Configuration File:
/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Copyright (c) 1991, 2007, Oracle. All rights reserved.

  Instance “prd”, status READY, has 1 handler(s) for this service…

Copyright (c) 1991, 2007, Oracle. All rights reserved.

         3

start – Start the Oracle listener
stop – Stop the Oracle listener
status – Display the current status of the Oracle listener
services – Retrieve the listener services information
version – Display the oracle listener version information
reload – This will reload the oracle listener SID and parameter files.
This is equivalent to lsnrctl stop and lsnrctl start.
save_config – This will save the current settings to the listener.ora
file and also take a backup of the listener.ora file before overwriting
it. If there are no changes, it will display the message “No changes to
save for LISTENER”
trace – Enable the tracing at the listener level. The available options
are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’
spawn – Spawns a new with the program with the spawn_alias mentioned in
the listener.ora file
change_password – Set the new password to the oracle listener (or)
change the existing listener password.
show – Display log files and other relevant listener information.
view plaincopy to clipboardprint?
$ lsnrctl help  

      (SERVICE_NAME = prd)

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:37  

OK (10 msec)

如果oracle监听器正在运行,可以使用lsnrctl
stop命令关闭oracle监听器,该命令将关闭所有的监听器,如果你只想关闭特定的监听器,可以再stop后面指定监听器的名字,例如:lsnrctl
stop [listener-name]

Used parameter files:

LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 04-APR-2009
16:27:37

 

         6

The command completed successfully

 

SQL> !tnsping std

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
std)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= prd)))

 

Services Summary…

LSNRCTL for Linux: Version 10.2.0.5.0 – Production on 08-OCT-2014
12:31:46

  (DESCRIPTION =

  Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this
service…

SID_LIST_LISTENER =

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=std)(PORT=1521)))

Service “std_XPT” has 1 instance(s).

         1 VALID

         3 INACTIVE

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

 

  Instance “prd”, status READY, has 1 handler(s) for this service…

 

         2 VALID

 

[oracle@prd ~]$ lsnrctl status

Used TNSNAMES adapter to resolve the alias

  Instance “prd”, status UNKNOWN, has 1 handler(s) for this service…

 

The command completed successfully

The command completed successfully

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
std)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= prd)))

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

 

 

 

 

 

Service “prd” has 1 instance(s).

SQL> select dest_id,error,status from v$archive_dest;

Security                  ON: Local OS Authentication

 

Uptime                    0 days 3 hr. 15 min. 44 sec

 

 

    )

        10 INACTIVE

TNS Ping Utility for Linux: Version 10.2.0.5.0 – Production on
08-OCT-2014 12:32:43

SQL> !tnsping std

 

 

  )

Used parameter files:

Listening Endpoints Summary…