Oracle XE Client Connect to Other Server


After I install Oracle XE Client, i try to connect to another server, but I cannot. I look for tnsnames.ora, but i cannot find any on XEClient folder. I look for network/admin folder,but i not find too.

So I try to create a new one on $ORACLE_HOME/network/admin/
then create/copy SQLNET.ORA and TNSNAMES.ORA

After that i try using sqlplus and succesful, now, i can connect to other server using Oracle XE Client.

Here my SQLNET.ORA,
##########################
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, ONAMES, HOSTNAME)

DEFAULT_SDU_SIZE = 8761
##########################

my TNSNAMES.ORA,
##########################
TESTSVR=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.0.1)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=apps)
)
)
##########################

or if you are using sqlplus, in oracle 10g, you can use direct command
SQL> conn USERNAME/PASSWORD@HOSTNAME:PORT/SID

In that case you don’t need a tnsnames.ora. Only your sqlnet.ora need the following entry:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)

 

^_^

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: