Skip to main content

to access data DB in the network via userver.asn path

  • September 1, 2022
  • 2 replies
  • 0 views
A
  • Anonymous
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
------------------------------

    2 replies

    Iain Sharp
    Forum|alt.badge.img+5
    • Iain Sharp
    • Inspiring
    • September 1, 2022
    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
    ------------------------------
    Iain Sharp : Head of Technical Services, Jonas Metals Software
    A
    • Anonymous
    • September 2, 2022

    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
    ------------------------------

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement