Applications

Expand all | Collapse all

EBS 12.1 database upgrade to 19c

  • 1.  EBS 12.1 database upgrade to 19c

    Posted 05-15-2020 14:59

    Upgraded database from 11.2.0.4 to 19c. Converted to multi-tenant. Copied old tns ifile to the new 19c network/admin/<sid>_server folder. All of our custom database links fail.

    The CDB tns_admin points to network/admin
    The PDB tns_admin points to nework/admin/xxxxxx

    When starting the database, I ran the CDB environment file and did a startup. Since that had tns_admin set for network/admin, won't that prevent the database from seeing the network/admin/xxxx ifile when connected to the PDB?

    Ran the CDB environment file and then tried sqlplus to connect to one of the databases in the ifile and of course it failed. If I override the tns_admin variable to include the sub-folder, I can connect.

    Therefore, is the tns_admin for the CDB wrong?



    ------------------------------
    Jeffrey Beckstrom
    Lead Database Administrator
    Greater Cleveland Regional Transit Authority
    Cleveland OH
    (216) 356-3027
    ------------------------------


  • 2.  RE: EBS 12.1 database upgrade to 19c

    SIG Leader
    Posted 05-19-2020 08:34
    Good question.  I am working through yet another test upgrade at the moment so I don't have a place to test.

    My suggestion would be to put different entries in both ifiles and then see if you can set up dblinks to both from the PDB.  If you do this, please update us with the results.

    ------------------------------
    Michael Brown
    Database Administrator
    BlueStar
    Burlington NC
    (859) 371-4423 x3353
    ------------------------------



  • 3.  RE: EBS 12.1 database upgrade to 19c

    Posted 05-19-2020 09:06
    What is found is if set environment to the CDB, override the TNS_ADMIN variable to point to home/network/admin/xxxx and then start the database, the database can see the tns ifile in in EBS subfolder of network admin.

    Oracle support is reviewing how they wish to support this.





  • 4.  RE: EBS 12.1 database upgrade to 19c

    Posted 05-19-2020 09:07
    What we found is if we set the environment to the CDB, override the TNS_ADMIN variable to point to home/network/admin/xxxx and then start the database, the database can see the tns ifile in the EBS subfolder of network admin.
    Oracle support is reviewing how they wish to support this.
    - alter autoconfig configuration for the cdb
    - override the tns_admin variable
    - add a ifile to the tnsnames.ora file in the cdb network/admin folder


    ------------------------------
    Jeffrey Beckstrom
    Lead Database Administrator
    Greater Cleveland Regional Transit Authority
    Cleveland OH
    (216) 356-3027
    ------------------------------



  • 5.  RE: EBS 12.1 database upgrade to 19c

    Posted 05-21-2020 14:42
    you can either setup a soflink to point to the main TNS directory or you can change the CONTEXT File to appropriate TNS_ADMIN diretory.


    ------------------------------
    Vikram Kotwani
    Apps DBA
    Centroid Systems Inc.
    ------------------------------



  • 6.  RE: EBS 12.1 database upgrade to 19c

    OATUG Star Partner
    Posted 07-24-2020 11:38
    Another option is to setup the database link without using tns entry.

    e.g.:
    create public database link
    mylink
    connect to
    remote_user
    identified by
    password
    using 'myremoteserver:1521/MYSID';

    ------------------------------
    Kai Glittenberg
    Solution Architect Cloud Services
    Apps Associates
    Dortmund
    (49) 160 36 555 44
    ------------------------------