[DB-SIG] Remote connection to Oracle DB possible?
Fri, 28 Apr 2000 14:15:03 +0300
If you have Oracle Net installed and have properly configured TNS listener
remote databases (you need things configured on both machines - server where
Oracle runs and client machine as well) (if you can connect to database
Oracle 'sqlplus' program), you can also connect to it using DCOracle.
Main environment variable, which should be used is ORACLE_SID, which
is alias for instance configured in (see below).
Listener configuration is stored in the
and each record has following example structure:
(ADDRESS (PROTOCOL = TCP)(HOST = bigboy)( PORT = 1521 ))
(ADDRESS (PROTOCOL = TCP)(HOST = bigboy)( PORT = 1526 ))
( SID = MAIN )
BIGBOYMAIN is name of alias (used in ORACLE_SID)
bigboy is Oracle server machine host/ip
1521/1526 are port numbers to connect to Oracle on server machine
MAIN is Oracle instance name to use on server machine
If you set ORACLE_SID in environment, then you can use 'username/password'
your connect string, otherwise you have to use 'username/password@instance'.
Tieto Konts Financial Systems
Kr.Barona 30, Riga, LV-1011, Latvia
tel.: (371) 7286660, (371) 7283689
fax: (371) 7243000