Home » Infrastructure » Windows » Cannot Connect (10G,10.1.0.2.0,Windows 7 home edition 64 bit)
Cannot Connect [message #472654] Mon, 23 August 2010 03:04 Go to next message
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.
sys/khan as sysdba

I have given the password "khan" during installation.

Please help me.

Re: Cannot Connect [message #472658 is a reply to message #472654] Mon, 23 August 2010 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67572
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't explain what you did, SHOW us: copy and paste your SQL*Plus session.
Before copy and paste the result of SET.

I mean copy and paste as TEXT do NOT post an image.

Regards
Michel
Re: Cannot Connect [message #472720 is a reply to message #472658] Mon, 23 August 2010 08:35 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
>(10G,10.1.0.2.0,Windows 7 home edition 64 bit)
Only V11.2 is certified for Windows 7
No Oracle version is certified on any HOME edition of Windows; only Professional editions.
No reason to believe how or if it should even work at all.
Re: Cannot Connect [message #472847 is a reply to message #472720] Tue, 24 August 2010 04:09 Go to previous messageGo to next message
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 #472878 is a reply to message #472847] Tue, 24 August 2010 09:55 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
open a Command Window then COPY the lines below

SET
LSNRCTL STATUS
LSNRCTL SERVICE

PASTE the lines above into Command Window
COPY commands & results, then PASTE all back here.
Re: Cannot Connect [message #473525 is a reply to message #472878] Mon, 30 August 2010 00:46 Go to previous messageGo to next message
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 #473528 is a reply to message #473525] Mon, 30 August 2010 01:10 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
I previously tried to install Oracle 11g on Windows 7 Home, but was unsuccessful. After upgrading to Windows 7 Professional and uninstalling my previous partial attempted installation, I was able to install Oracle 11g and have been using it without problems ever since. It is easy to upgrade from Windows 7 Home to Windows 7 Professional online, but you do have to pay for it.
Re: Cannot Connect [message #486974 is a reply to message #472654] Tue, 21 December 2010 18:17 Go to previous message
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.
Previous Topic: To create a bat file to run a query
Next Topic: Oracle 10g ODAC error
Goto Forum:
  


Current Time: Sat Dec 05 12:48:25 CST 2020