Oracle Database Discussions

Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to database by Toad but it didn't worked!
I tried to log in as system user with my password and following parameters:
-------------------------------------
User/Schema:system
Password:******
Database:XE

Connect as : Noramal
Conect Using:XE

The SQLNET Editor in green checked mark
TSNName Editor in green checked mark
BUT: the LDAP Editor is getting RED cross and it's button is not active!
I got this erroe:
ORA-12154:TSN:could not resolve the connect identifier specified(XE)

I also tried Direct connection method with
Host: Mycomputer
Port:1521
But I did not know what should I enter for Server Name or SID?! so I got this warnning message:
Please enter Host,Port,and SID/Service Name.



This is what I have in tsnname.ora file:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Mycomputer)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

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

and the sqlnet.ora looks like this:

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

could you please let me know what is wrong and how I can connect with Toad to oracle.I also have to say that I am able to connect to my database with Oracle SQL Developer.

Best regards

Behrouz