Home » Infrastructure » Windows » Not able to login through SQLPLUS with username@dbname however able to login as username/password. (Windows Vista, Oracle10g)
Not able to login through SQLPLUS with username@dbname however able to login as username/password. [message #430110] Sun, 08 November 2009 08:02 Go to next message
nemoh.8585
Messages: 6
Registered: November 2009
Location: Singapore
Junior Member
Hi ,
I am having problem while connecting to Oracle through SQLPLUS with username@dbname
However able to connect as username/password

Even not able to start Listener



Please help
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #430112 is a reply to message #430110] Sun, 08 November 2009 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have no problem. Why?

Regards
Michel
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #430157 is a reply to message #430110] Mon, 09 November 2009 05:02 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
nemoh.8585 wrote on Sun, 08 November 2009 08:02
Hi ,
I am having problem while connecting to Oracle through SQLPLUS with username@dbname[/email]
However able to connect as username/password

Even not able to start Listener



Please help


post your test case.....

copy and paste what you tried so far....


sriram
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #430158 is a reply to message #430112] Mon, 09 November 2009 05:04 Go to previous messageGo to next message
nemoh.8585
Messages: 6
Registered: November 2009
Location: Singapore
Junior Member
Hi Michael.

Acually the Oracle is locally installed.
that's why it is using sytem environmental variables settings to connect via sqlpus.

However when i connect using username@dbname , it uses TNSNAMES entry.So now the issue is Listener is not getting started on my machine.

Everytime i try starting Listener, it failed.

Following is the entry in listener.log file --
TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production on 09-NOV-2009 18:09:16

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

System parameter file is C:\OraHome_1\NETWORK\ADMIN\listener.ora
Log messages written to C:\OraHome_1\network\log\listener.log
Trace information written to C:\OraHome_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=1016
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Nirmoh-PC)(PORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
64-bit Windows Error: 13: Permission denied
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))





My Sqlnet.ora file is --
# sqlnet.ora Network Configuration File: C:\OraHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

# SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES = (NTS,BEQ)
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)




and Tnsnames.ora is --
# tnsnames.ora Network Configuration File: C:\OraHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


MOHIT10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Nirmoh-PC)(PORT = 1521))
)
(CONNECT_DATA = (SID = MOHIT10)(SERVER = DEDICATED))
)






and listener.ora file is --
# listener.ora Network Configuration File: C:\OraHome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Nirmoh-PC)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\OraHome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = C:\OraHome_1)
(SID_NAME = MOHIT10)
)
)


Please suggest
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #430162 is a reply to message #430158] Mon, 09 November 2009 05:19 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
 oerr TNS 12546
12546, 00000, "TNS:permission denied"
// *Cause: User has insufficient privileges to perform the requested operation.
// *Action: Acquire necessary privileges and try again.


Are you trying to start / run the listener as the Oracle user? Does the Oracle use have the necessary privileges?

Is this perhaps some home/basic edition of Vista that can't run Oracle services?

Is it at least version 10.2.0.4, since that is the first version to work under Vista?

[Updated on: Mon, 09 November 2009 05:20]

Report message to a moderator

Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #430166 is a reply to message #430162] Mon, 09 November 2009 05:49 Go to previous messageGo to next message
nemoh.8585
Messages: 6
Registered: November 2009
Location: Singapore
Junior Member
Hi,

I have the admin rights on my machine and i am running it as me only.

But still getting the error.

Not sure whether the issue is related ti Vista or not.

Should i try using LogOn tab while starting Listener services via Administrative tools-->Services--> Listener

any suggestion
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #431546 is a reply to message #430162] Wed, 18 November 2009 01:09 Go to previous messageGo to next message
shafique.rehman
Messages: 5
Registered: May 2009
Location: lahor
Junior Member

dear
please try this solution to resolve ORA-12546

Checked for relevance on 13-MAR-2008.
* fact: Oracle Net
* fact: TNS Listener
* symptom: Starting the TNS Listener fails
* symptom: TNS-12546 / ORA-12546: TNS:permission denied
* symptom: TNS-12560 / ORA-12560: TNS:protocol adapter error
* symptom: TNS-00516: permission denied
* symptom: Solaris Error: 13: permission denied
* symptom: IBM/AIX RISC System/6000 Error: 13: Permission denied
* cause: The error Solaris Error: 13: permission denied or HPUX Error: 13: Permission denied, means the user starting the TNS listener does not have permission to write to the .oracle directory. On Solaris the directory is under /var/tmp On Hp and IBM the directory is under /tmp



fix:
The Unix permissions for the hidden directory /tmp/.oracle should be:
Owner = the Oracle user who performed the database install,
Group = the dba group of the Oracle user,
and the directory's Unix permissions should be
drwxrwxrwx

Change the permissions on the .oracle directory:

1) cd /var/tmp or /tmp

2) Change the ownership and group of the ".oracle" directory to
"oracle/dba":

chown oracle .oracle
chgrp dba .oracle

or

3) Change the permissions on the directory:

chmod 777 .oracle

Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #431785 is a reply to message #431546] Thu, 19 November 2009 08:16 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

@shafique.rehman

Haven't you noticed that the OP is running on Windows ?
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #431953 is a reply to message #431785] Fri, 20 November 2009 03:43 Go to previous messageGo to next message
nemoh.8585
Messages: 6
Registered: November 2009
Location: Singapore
Junior Member
Hi Rehman,

If you are talking about Oracle process, then yes it is running.I am able to connect via sqlplus too.the issue is i am not able to start the listener and si i am not able to use Toad as well.

Please suggest
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #431987 is a reply to message #431953] Fri, 20 November 2009 05:22 Go to previous messageGo to next message
shafique.rehman
Messages: 5
Registered: May 2009
Location: lahor
Junior Member

can you share log file when you try to start listener
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #431989 is a reply to message #431953] Fri, 20 November 2009 05:27 Go to previous messageGo to next message
nemoh.8585
Messages: 6
Registered: November 2009
Location: Singapore
Junior Member
Please find the logs in listener file ---

TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production on 20-NOV-2009 16:11:52

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

System parameter file is C:\OraHome_1\NETWORK\ADMIN\listener.ora
Log messages written to C:\OraHome_1\network\log\listener.log
Trace information written to C:\OraHome_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=2432
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Nirmoh-PC)(PORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
64-bit Windows Error: 13: Permission denied
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))


unable to identify, why it is saying permission denied.I am the administrator of the PC
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #432128 is a reply to message #431989] Sat, 21 November 2009 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Something at the Operating System (OS) level is mal-configured involving the network.

Is there any type of OS virtualization done on this system?
Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #468878 is a reply to message #430110] Mon, 02 August 2010 06:55 Go to previous messageGo to next message
martingh
Messages: 6
Registered: August 2010
Junior Member
tell me one thing, have you ever tried to run the listener as an Oracle user? And does the Oracle have the necessary privileges?

Tell me one thing more, is this perhaps some home/basic edition of Vista that can't run Oracle services?

Give me these two answers, I will let you know the solution(s) ASAP.

Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #469070 is a reply to message #468878] Tue, 03 August 2010 02:48 Go to previous messageGo to next message
nemoh.8585
Messages: 6
Registered: November 2009
Location: Singapore
Junior Member
Hi Martin,
Thanks for follow up on yhis after a long time.

Yes i tried starting listener (some permission denied error in listener log )
Oracle should have necessary priveleges.
if anything i can check to confirm ,pls let me know

I also suspect this is because of Vista OS compatibility with Oracle

waiting for your reply

Re: Not able to login through SQLPLUS with username@dbname however able to login as username/passwor [message #469075 is a reply to message #469070] Tue, 03 August 2010 03:22 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Thanks for follow up on yhis after a long time.

It does not care of your problem, he just 5 topics of last year, put a post then he has been able to put a link on the 6th one.

Anyway, we're waiting for his answer, a real and helpful one now but don't delude yourself.

Regards
Michel

[Updated on: Tue, 03 August 2010 03:23]

Report message to a moderator

Previous Topic: Which Windows Server for Oracle 10g R2??
Next Topic: oracle 10g installation problem in 2008 server
Goto Forum:
  


Current Time: Sun Dec 04 10:31:56 CST 2016

Total time taken to generate the page: 0.07905 seconds