TNS-01190: The user is not authorized to execute the requested listener com
[fir@node1 admin]$ tnsping clone
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 08-AUG-2010 08:04:52
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node1.oracle.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = clone)))
TNS-12541: TNS:no listener
[fir@node1 admin]$ ls
listener1008087AM1824.bak shrept.lst tnsnames1008087AM1824.bak
listener1008087AM2257.bak sqlnet1008087AM1824.bak tnsnames1008087AM2257.bak
listener1008087AM2352.bak sqlnet1008087AM2257.bak tnsnames1008087AM2352.bak
listener1008209PM2415.bak sqlnet1008087AM2352.bak tnsnames1008209PM2415.bak
listener1008209PM2454.bak sqlnet1008209PM2415.bak tnsnames1008209PM2454.bak
listener.ora sqlnet1008209PM2454.bak tnsnames.ora
samples sqlnet.ora
[fir@node1 admin]$ vi sqlnet.ora
[fir@node1 admin]$ tnsping clone
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 08-AUG-2010 08:07:18
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node1.oracle.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = clone)))
TNS-12541: TNS:no listener
[fir@node1 admin]$ tnsping clone
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 08-AUG-2010 08:07:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node1.oracle.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = clone)))
TNS-12541: TNS:no listener
[fir@node1 admin]$ lsnrctl reload
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-AUG-2010 08:07:28
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-01190: The user is not authorized to execute the requested listener command
[fir@node1 admin]$
well i have 2 users, oracle and fir. i can tnsping from fir to oracle but not possiable from oracle to fir.
when i try to reload the fir listner it thoughts me the above eror
thanks
firdous