Hi all,
I am very new to the steps that need to be setup correctly after installing Oracle 10g on windows vista home premium so that I can acess and use the database properly.
Till now,I have installed locally Oracle - OraClient10g_home2,but stuck with setting up the tnsnames.ora nd sqlnet.ora correctly.
The tnsnames.ora file details are as below.I am not sure as to what all values should be put correctly
The net_service_name I had put in the Net Config. Assisstant is 'orcl'
# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.
<alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have
# one or more descriptions
# If there is just one description, unnecessary ]
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= # Optional depending on whether u have
# one or more addresses
# If there is just one address, unnecessary ]
(ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=TCP)
(HOST=Test-PC) ----------->Computer's name
(PORT=1521)
)
Also,when i am trying to connect using Toad 9-it gives error as 'Can't initialize OCI. Error -1'