|
|
|
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 |
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 #431989 is a reply to message #431953] |
Fri, 20 November 2009 05:27 |
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
|
|
|
|
|
|
|