Can't connect to newly installed 11G database
Hi all,
I just installed a new Oracle 11.1.0.6 database on my Windows XP laptop. When I start sqlplus on a command prompt I get an ORA-12154 error. Tnsping gives an OK. After going through the Net Configuration Assistant, I end up with a succesful test.
This is my sqlnet.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
And my tnsnames.ora:
ORA11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORA11)))
Can anyone tell me what is going wrong here?
Thanks
Paul