Skip to main content
Dear All
need your help to access separate data DB server in the network (without the local DB) via userver.asn.
existing setting when DB server in same userver. ORA1 is data DB and ORA2 is the repository DB.

[PATH]
$ORA1    ORA:hqunx1|user|pw
$ORA2   ORA:hqunx1|user|pw 

$DEF $ORA1
$UUU $ORA2
$IDF $ORA2
$SYS $ORA2
$ORA $ORA1

now i want to direct the data DB(ORA1 setting ) to access  a remote DB server in the network with different IP  ,then urouter , userver and repository will be in one server and data DB is in a different server.  how can i change this settings?
need your utmost help pl

Best Regards,
meththa

------------------------------
Meththa Perera
IT manager
Ceylon Electricity Board
No 50, Chittampalam A. Gardiner Mawatha LK
------------------------------
Dear All
need your help to access separate data DB server in the network (without the local DB) via userver.asn.
existing setting when DB server in same userver. ORA1 is data DB and ORA2 is the repository DB.

[PATH]
$ORA1    ORA:hqunx1|user|pw
$ORA2   ORA:hqunx1|user|pw 

$DEF $ORA1
$UUU $ORA2
$IDF $ORA2
$SYS $ORA2
$ORA $ORA1

now i want to direct the data DB(ORA1 setting ) to access  a remote DB server in the network with different IP  ,then urouter , userver and repository will be in one server and data DB is in a different server.  how can i change this settings?
need your utmost help pl

Best Regards,
meththa

------------------------------
Meththa Perera
IT manager
Ceylon Electricity Board
No 50, Chittampalam A. Gardiner Mawatha LK
------------------------------

This help page https://www3.rocketsoftware.com/rocketd3/support/documentation/Uniface/10/uniface/dbmsSupport/dbmsDrivers/Oracle/concepts/ORACLE_LOGON_PATH.htm

Shows how to configure a tcp connection to a different oracle server, and/or use the SQL*Net setup. 
Regards, 
Iain



------------------------------
Iain Sharp
Head of Technical Services
Pci Systems Ltd
Sheffield GB
------------------------------

This help page https://www3.rocketsoftware.com/rocketd3/support/documentation/Uniface/10/uniface/dbmsSupport/dbmsDrivers/Oracle/concepts/ORACLE_LOGON_PATH.htm

Shows how to configure a tcp connection to a different oracle server, and/or use the SQL*Net setup. 
Regards, 
Iain



------------------------------
Iain Sharp
Head of Technical Services
Pci Systems Ltd
Sheffield GB
------------------------------
Thanks lain. i'll try it and share the outcome

------------------------------
Meththa Perera
IT manager
Ceylon Electricity Board
No 50, Chittampalam A. Gardiner Mawatha LK
------------------------------