Connectivity

[kanvikb]

Hi i have installed Oracle 10g release 2 in my system as a Database Server.
And i have installed Oracle 10g lite express edition(XE) in other system which are in Lan.
Now from remote i.e. from client i want to access the Database of Oracle 10g which is a server.
so what connection i have to do????

[debasisdas]

You need to modify the arguments in tnsnames.ora files .

[kanvikb]

What do u mean by arguments in tnsnames???
Can u please tell me in detail????

[debasisdas]

The tnsnames.ora files contains somthing like this.

MES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = MES)
)
)
BDCORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl1)
)
)
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

You need to modify as per your requirment in the client PC.

[kanvikb]

I have installed Oracle 10g Release 2 in xp. So my question is by default tnsname.ora and listener.ora will be created or not??? If it is created it should be in Oracle/network/admin folder. But i am not getting tnsname.ora and listener.ora in these file. Ya i am getting these file in
Oracle/network/admin/sample folder.

So whenever i am opening Net configuration foldr it is asking for Select the directory where network file is there. So i select the Network dir from oracle.
So when net configuration screens opens i am not able to see any tnsname and listnere in dat.


So is there any problem in installation???????
Or i have to create tnsname manually????

[debasisdas]

You need to do the following in the client PC.

1.Copy the tnsname.ora file from \oracle\product\10.2.0\db_1\NETWORK\ADMIN\SAMPLE
2.Paste to path \oracle\product\10.2.0\db_1\NETWORK\ADMIN
3.Modify the file as per your requirment.(Check my previous post )

[orcl1]

Hi,

Had questions in very intelligent scripts but ,unable to paste here at free of cost .This type of issues will be handled by systems 's guys .I'm unable to comment on this .