Oracle Database Discussions

I have Installed 11g Enterprise Edition 11.2.0.1 on Windows7 64 bit Home Premium edition:


I have set my env variables
ORACLE_SID=ORCL
TNS_NAMES=E:\app\ora112\product\11.2.0\dbhome_1\network\admin


I am trying to login from command prompt as given below:
E:\apex402\apex_4.0.2_en\apex>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 10 21:58:43 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: system/manager@orcl

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


Warning: You are no longer connected to ORACLE.
SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


SQL> conn system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


SQL> conn system@orcl
Enter password:
Connected.
SQL>


I have to concatenate sid name all the time if I want to connect to sqlplus successfully from command line.
How do I connect sqlplus> conn sys as sysdba without tagging in @sid. I know I have done some mistake here and couldn't figure out.

I wanted to install plsql developer 8.0.4 version. I could not make it work because plsql dev does not support 64 bit. So, I found that I have to install
windows32bit_oracle_client on Windows 7 64 bit computer. I still could not the plsqldev work either.

Is this 32 bit client version causing problem? Should I get rid off it. How do I uninstall oracle 32 bit client?

I also installed sqldeveloper 3.0.4 and it works fine. I also have installed jdeveloper 11g ( 11.1.1.5 studio ed) with weblogic server 10.3.5 and they all work fine

What is going on here. Can someone help me here.


Here are configuration files:


tnsnames.ora
---------------------------
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


Listener file
--------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\ora112\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\ora112\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = E:\app\ora112


sqlnet.ora file
---------------------------

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, LDAP, TNS_ADMIN)

Edited by: 795075 on Jun 10, 2011 7:22 PM

Edited by: 795075 on Jun 10, 2011 7:24 PM

Edited by: 795075 on Jun 10, 2011 7:42 PM

Edited by: 795075 on Jun 11, 2011 11:29 AM