| ORA-12154: TNS:could not resolve service name [message #456748] |
Wed, 19 May 2010 07:27  |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
Hi,
I can able to login to the database through an user A. But when I try login as B,I am getting the follwing error.
ORA-12154: TNS:could not resolve service name
I am using the following method.
1. Login to the database server via putty.
2. sqlplus A/****
for the user A,the step2 is working fine.
But the same step is failing for the user B.And the user B is trying to connect to the database from the same server as the user A logged in to the database successfully.
db01: sqlplus B/*****
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 13:12:52 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name:
I dont know why this error is coming for a particular user only. Can you please help me to clarify this?
[Updated on: Wed, 19 May 2010 07:28] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #456819 is a reply to message #456771] |
Wed, 19 May 2010 10:15  |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
Hi Littlefoot/Michel,
I am very sure both users are trying to connect to the database from the same server only. Since I am only checking this.
As per my understanding, TNSnames is not required to connect to the database from the database server(It holds the database). So I didn't use tns entries when I connect to the database for both users.
Please correct me, if I am wrong.Since I am new to the oracle.
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #456829 is a reply to message #456826] |
Wed, 19 May 2010 10:52 |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
As you suggested, I pasted my session details below.
db01: env | sort
A__z="*TMOUT
ERASE=^H
HOME=/export/home/shahulj
LOGNAME=shahulj
MAIL=/usr/mail/shahulj
MANPATH=/usr/share/man:/usr/local/man:/opt/SUNWexplo/man:/opt/SUNWvts/man:/opt/CTEact/man:/opt/emc/WideSky/V5.2.0/man
ORACLE_HOME=/eai/u01/app/oracle/product/9.2
ORACLE_SID=eai2
PATH=/usr/bin:/usr/local/bin:/usr/sbin:/eai/u01/app/oracle/product/9.2/bin
PS1=rioosp01-ukbr:
PWD=/export/home/shahulj
SHELL=/bin/ksh
SSH_CLIENT=171.192.121.91 54642 22
SSH_CONNECTION=171.192.121.91 54642 101.126.231.82 22
SSH_TTY=/dev/pts/1
TERM=vt100
TMOUT=1800
TZ=GB
USER=shahulj
_=/usr/bin/env
db01: sqlplus shahulj
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 16:40:28 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> sho user
USER is "SHAHULJ"
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
db01: env | sort
A__z="*TMOUT
ERASE=^H
HOME=/export/home/shahulj
LOGNAME=shahulj
MAIL=/usr/mail/shahulj
MANPATH=/usr/share/man:/usr/local/man:/opt/SUNWexplo/man:/opt/SUNWvts/man:/opt/CTEact/man:/opt/emc/WideSky/V5.2.0/man
ORACLE_HOME=/eai/u01/app/oracle/product/9.2
ORACLE_SID=eai2
PATH=/usr/bin:/usr/local/bin:/usr/sbin:/eai/u01/app/oracle/product/9.2/bin
PS1=rioosp01-ukbr:
PWD=/export/home/shahulj
SHELL=/bin/ksh
SSH_CLIENT=171.192.121.91 54642 22
SSH_CONNECTION=171.192.121.91 54642 101.126.231.82 22
SSH_TTY=/dev/pts/1
TERM=vt100
TMOUT=1800
TZ=GB
USER=shahulj
_=/usr/bin/env
db01: sqlplus otruserisp1
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 16:41:07 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name: |
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #456844 is a reply to message #456748] |
Wed, 19 May 2010 11:45 |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
I am getting the following error. What to do now?
db01: script /tmp/capture.log
Script started, file is /tmp/capture.log
db01: truss sqlplus otruserisp1
truss: cannot trace set-id or unreadable object file: /eai/u01/app/oracle/product/9.2/bin/sqlplus |
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #456847 is a reply to message #456843] |
Wed, 19 May 2010 11:57 |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
Hi Michel,
Please find the details below.
db01: which sqlplus
/eai/u01/app/oracle/product/9.2/bin/sqlplus
db01: id
uid=803250120(shahulj) gid=1(other)
db01: groups
other
db01:
I am logging to the database with 2 different user accounts not from the 2 different database server.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
