Cannot Connect [message #472654] |
Mon, 23 August 2010 03:04 |
gozuhair
Messages: 206 Registered: January 2008
|
Senior Member |
|
|
Dear All
I have installed Oracle 10G first time but unfortunately when i try to connect SQL Plus,the following message appears.
Error
ORA-12546: TNS:permission denied
I use the following command in a sql plus to connect.
I have given the password "khan" during installation.
Please help me.
|
|
|
|
|
Re: Cannot Connect [message #472847 is a reply to message #472720] |
Tue, 24 August 2010 04:09 |
gozuhair
Messages: 206 Registered: January 2008
|
Senior Member |
|
|
Thanks for your useful information but is there any utility or any solution for this except installing some professional versions of operating system.
|
|
|
|
Re: Cannot Connect [message #473525 is a reply to message #472878] |
Mon, 30 August 2010 00:46 |
gozuhair
Messages: 206 Registered: January 2008
|
Senior Member |
|
|
Hello
First of all,sorry for late reply,actually my internet was not working,As per your instruction I am pasting the following data.
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\User>SET
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\User\AppData\Roaming
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=USER-PC
ComSpec=C:\windows\system32\cmd.exe
configsetroot=C:\windows\ConfigSetRoot
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\User
LenovoTestLogFile=preload.log
LenovoTestPath=C:\prdv10\
LOCALAPPDATA=C:\Users\User\AppData\Local
LOGONSERVER=\\USER-PC
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=D:\oracle\product\10.1.0\db_1\bin;D:\oracle\product\10.1.0\db_1\jre\1.4.2\b
in\client;D:\oracle\product\10.1.0\db_1\jre\1.4.2\bin;C:\windows\system32;C:\win
dows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;c:\Pro
gram Files (x86)\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PERL5LIB=D:\oracle\product\10.1.0\db_1\perl\lib\5.6.1\MSWin32-x86;D:\oracle\prod
uct\10.1.0\db_1\perl\lib\5.6.1;D:\oracle\product\10.1.0\db_1\perl\5.6.1\lib\MSWi
n32-x86;D:\oracle\product\10.1.0\db_1\perl\site\5.6.1;D:\oracle\product\10.1.0\d
b_1\perl\site\5.6.1\lib;D:\oracle\product\10.1.0\db_1\sysman\admin\scripts
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 23 Stepping 10, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=170a
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\windows
TEMP=C:\Users\User\AppData\Local\Temp
TMP=C:\Users\User\AppData\Local\Temp
USERDOMAIN=User-PC
USERNAME=User
USERPROFILE=C:\Users\User
windir=C:\windows
C:\Users\User>LSNRCTL STATUS
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 29-AUG-2010 23:41
:05
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 29-AUG-2010 23:16:12
Uptime 0 days 0 hr. 24 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.1.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.1.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=User-PC)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Users\User>LSNRCTL SERVICE
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 29-AUG-2010 23:41
:08
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
C:\Users\User>
Please advice
|
|
|
|
Re: Cannot Connect [message #486974 is a reply to message #472654] |
Tue, 21 December 2010 18:17 |
gozuhair
Messages: 206 Registered: January 2008
|
Senior Member |
|
|
Finallym i have installed windows XP mode in Windows Ultimate 7 and installed Oracle 9i enterprise edition, thank you for your help, i really appreciate your guidence.
|
|
|