OraFAQ Forum: Networking and Gateways » error in logging with sqlplus

Home » RDBMS Server » Networking and Gateways » error in logging with sqlplus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error in logging with sqlplus [message #131430]

Sat, 06 August 2005 03:40

artsx
Messages: 21
Registered: June 2005
Location: Armenia

Junior Member

when I try to log in with sqlplus
the system return an error like "ORA-12546: TNS:permission denied"

with which login and password shall I log in ?
##################################
Enter user-name: artsx
Enter password:
ERROR:
ORA-12546: TNS:permission denied
##################################

shall I edit the file tnsnames.ora ?

thanks in advance
regards Arthur

Report message to a moderator

Re: error in logging with sqlplus [message #132038 is a reply to message #131430]

Wed, 10 August 2005 08:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Do you have OS permissions?
Try by logged in as oracle user.
and there should some relative entries in sqlnet.log, when this errors occurs. Post them.

[Updated on: Wed, 10 August 2005 08:13]

Report message to a moderator

Re: error in logging with sqlplus [message #132160 is a reply to message #132038]

Thu, 11 August 2005 03:14

artsx
Messages: 21
Registered: June 2005
Location: Armenia

Junior Member

HI !
When I try to connect via web, it return the folowing error: Database Error
Io exception: The Network Adapter could not establish the connection.

And this the error in the sqlnet.log file. See the error,

**********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora1.ysu.am)(PORT=1521))(CONNECT_DATA=(SID=test)(CID=(PROGRAM=)(HOST=ora1.ysu.am)(USER=orac le))))

VERSION INFORMATION:
TNS for Linux: Version 10.1.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.1.0.3.0 - Production
Time: 11-AUG-2005 10:22:18
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 111
nt OS err code: 0

[Updated on: Thu, 11 August 2005 06:17]

Report message to a moderator

Re: error in logging with sqlplus [message #132218 is a reply to message #132160]

Thu, 11 August 2005 07:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora1.ysu.am)(PORT=1521))(CONNECT_DATA=(SID=test)(CID=(PROGRAM=)(HOST=ora1.ysu.am)(USER=orac le))))

Is this a typo here in forum?
there is space between orac le

>> TNS-12541: TNS:no listener
check whether the listener is running in server.
Or
You may be looking into the wrong listener!.

Report message to a moderator

Previous Topic:	Transparent Gareway Oracle 9i - MS SQL not working?!
Next Topic:	ora-24909?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 09:44:53 CST 2024