TNS-01101: Could not find service name

This is a discussion on TNS-01101: Could not find service name within the Oracle Database forums in category; Hi, I have created one database instance on solaris cluster. the following output has come when i execute the status with lsnrctl. LSNRCTL> services listeneradvfrw1 Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=mosel1)(Port=1526)(QU EUESIZE=2000)) Services Summary... Service ADVFRW has 2 instance(s). Instance ADVFRW1 , status READY, has 1 handler(s) for this service... Handler(s): DEDICATED established:1 refused:0 state:ready LOCAL SERVER Instance ADVFRW2 , status READY, has 1 handler(s) for this service... Handler(s): DEDICATED established:0 refused:0 state:ready REMOTE SERVER (address=(protocol=tcp)(HOST=localhost)(PORT=1526) ) The command completed successfully ...

Go Back   Database Forum > Oracle Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 10-05-2007, 03:26 AM
Default TNS-01101: Could not find service name

Hi,

I have created one database instance on solaris cluster. the following output has come when i execute the status with lsnrctl.


LSNRCTL> services listeneradvfrw1
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=mosel1)(Port=1526)(QU EUESIZE=2000))
Services Summary...
Service "ADVFRW" has 2 instance(s).
Instance "ADVFRW1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Instance "ADVFRW2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(address=(protocol=tcp)(HOST=localhost)(PORT=1526) )
The command completed successfully

But, when i execute same command as another user which has same group id, it is failing with the following error message.

ash-2.05$ execRTPenv -p 99 /export/home/oracle/products/10.1.0/bin/lsnrctl status listeneradvfrw1

LSNRCTL for Solaris: Version 10.1.0.4.0 - Production on 05-OCT-2007 11:01:38

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

TNS-01101: Could not find service name

Please help to solve this problem. Please note that I am new to this database administration. But, I have to solve this problem.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:28 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.