Tuesday, February 28, 2012

Connect Discoverer 11g to EBS

When config the connection between Discoverer 10g to EBS, we need to copy the dbc file to the discoverer $ORACLE_HOME/discoverer/secure, also add entry into $ORACLE_HOME/network/admin/tnsnames.ora.
But in Discoverer 11g, we have to copy the dbc file to
$ORACLE_INSTANCE/config/Discoverer/Discoverer_asinst/
(note: don't know what's the reason, but I find out we'd better have two dbc files, one has upper case SID another has lower case SID, ie. PROD.dbc and prod.dbc under this directory)
and add entry into
$ORACLE_INSTANCE/config/tnsnames.ora
Posted by at

2 comments:

  1. AnonymousMarch 21, 2012 at 2:16 PM

    would you please me know what's $ORACLE_INSTANCE?
    (or how to define $ORACLE_INSTNACE?
    thanks.
    joseph7986@gmail.com

    ReplyDelete
    Replies
    1. George ChenMarch 21, 2012 at 2:29 PM

      this is just an example:

      MW_HOME=/oracle/middleware/wls; export MW_HOME

      DOMAIN_HOME=$MW_HOME/user_projects/domains/DISCDomain; export DOMAIN_HOME

      WL_HOME=$MW_HOME/wlserver_10.3; export WL_HOME

      ORACLE_HOME=$MW_HOME/disc_1; export ORACLE_HOME

      ORACLE_INSTANCE=$MW_HOME/asinst_2; export ORACLE_INSTANCE

      Delete

Subscribe to: Post Comments (Atom)