Oracle Database Discussions

Yesterday, I installed Oracle 11gR2 on my laptop with Windows 7 Professional 32-bit. During installation I chose "database software only" and didn't "create/configure a database". It installed without an error.

But when I try to connect SQL*Plus with command CONN / AS SYSDBA it gives me the following error:
ORA-12560: TNS:protocol adapter error

I get the same error if I try to connect via SQL Developer. Again, I get the same error if I try to create a database using DBCA. Listener Status shows the following message:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=P7One)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date 18-MAY-2011 11:08:45
Uptime 0 days 0 hr. 21 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\P7\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
Listener Log File d:\app\p7\diag\tnslsnr\P7One\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=P7One)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

Listener.ora file is as follows:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\P7\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\P7\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = P7One)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = D:\app\P7

Tnsnames.ora file is as follows:
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

Sqlnet.ora file is as follows:
SQLNET.AUTHENTICATION_SERVICES = (NONE)

I tried to edit Sqlnet.ora to =(NTS) but I still got ORA-12560. The windows firewall is off and there is no antivirus installed. I entered Environment Variables under System Properties and set TNS_Admin=home\network\admin full path. I did the same in Regedit. The following three services are "Started":
OracleMTSRecoveryService
OracleOraDb11g_home1ClrAgent
OracleOraDb11g_home1TNSListener

Currently, there is no database installed on my local machine. I don't need to create a database, I just have a couple of scripts to run for which I need to be able to connect first. Please help me get rid of this ORA-12560 issue, thank you.

Edited by: 859535 on May 18, 2011 8:51 AM