8 Replies Latest reply on Apr 23, 2018 5:07 AM by mdtaylor

    EM Database Express for EBS 12.2.7 with 12c

    Beauty_and_dBest

      EBS 12.2.6 & 12.2.7

      12c

      OL6

       

       

      Hi ALL,

       

      Is it okay to configure EM database express in    EBS 12c?

      Is it supported in EBS? does it not conflict with the ports of EBS?

       

       

      The following is the value the needed to be set:

       

      [ora1227p@test01 ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 21 23:07:13 2018

      Copyright (c) 1982, 2014, Oracle.  All rights reserved.

       

      Connected to:

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      SQL> show parameter dispatchers

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      dispatchers                          string

      max_dispatchers                      integer

       

      SQL> select dbms_xdb_config.gethttpsport () from dual;

       

      DBMS_XDB_CONFIG.GETHTTPSPORT()

      ------------------------------

                                   0

       

      SQL> select name,cdb,con_id from v$database;

       

      NAME      CDB     CON_ID

      --------- --- ----------

      P1227     NO           0

       

      SQL> select instance_name,status,con_id from v$instance;

       

      INSTANCE_NAME    STATUS           CON_ID

      ---------------- ------------ ----------

      P1227            OPEN                  0

       

       

      Can set the dispatchers to anyname?

      How do I know if its CDB or PDB?

       

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: EM Database Express for EBS 12.2.7 with 12c
          mdtaylor

          Hi jc,

           

          12.2 uses neither CDB nor PDB.  It is a normal non-container database.  Suppose you have a 12.2.7 instance with a sid uat122,

           

          If you want the EM Express to use port 5510, execute the following as sysdba:

           

          exec DBMS_XDB_CONFIG.SETHTTPSPORT(5510); --uat122

           

          And add the following to init.ora:

           

          dispatchers="(PROTOCOL=TCP)(SERVICE=uat122XDB)"

           

          When you restart, you can access EM Express from https://host.domain:5510/em

           

          There should be no issues with ports.  You could always type netstat -an | grep 5510 with the database up to ensure the port is free before configuring.

           

          Regards,

          Michael

          • 2. Re: EM Database Express for EBS 12.2.7 with 12c
            Beauty_and_dBest

            Thanks! It worked!!!

            • 3. Re: EM Database Express for EBS 12.2.7 with 12c
              Beauty_and_dBest

              Hi Michael,

               

              Can you help me with my tnsnames.ora issue please >> Can not connect to db using local tnsnames.ora

               

              I am comparing tnsnames.ora between EBS  and   a solo 12c DBCA installed database.

               

              In EBS, I have this tnsnames.ora

               

              UAT=

                      (DESCRIPTION=

                              (ADDRESS=(PROTOCOL=tcp)(HOST=test01.oracle.com)(PORT=1551))

                          (CONNECT_DATA=

                              (SERVICE_NAME=UAT)

                              (INSTANCE_NAME=UAT)

                          )

                      )

               

              If I run , I can successfully connect

               

              $ sqlplus apps/apps@UAT

               

              SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 22 06:33:00 2018

              Copyright (c) 1982, 2014, Oracle.  All rights reserved.

              Last Successful login time: Sat Apr 21 2018 13:06:58 -04:00

               

              Connected to:

              Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

              With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

               

              SQL> exit

               

               

               

              But my 12c can not connect using tnsnames

               

              tnsnames.ora

              TEST1 =

                (DESCRIPTION =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = test01.oracle.com)(PORT = 1540))

                  (CONNECT_DATA =

                    (SERVER = DEDICATED)

                    (SERVICE_NAME = TEST1)

                  )

                )

               

              $ sqlplus hr/hr@test1

               

              SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 22 06:42:33 2018

              Copyright (c) 1982, 2014, Oracle.  All rights reserved.

               

              ERROR:

              ORA-01034: ORACLE not available

              ORA-27101: shared memory realm does not exist

              Linux-x86_64 Error: 2: No such file or directory

              Additional information: 3640

              Additional information: -136613573

              Process ID: 0

              Session ID: 0 Serial number: 0

               

               

              Please help why this error

               

               

               

              Kind regards,

              • 4. Re: EM Database Express for EBS 12.2.7 with 12c
                mdtaylor

                Hi jc,

                 

                What is the sqlnet version of your client attempting to connect to 12c?  You may need to add the following to the sqlnet_ifile.ora:

                 

                SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

                 

                Regards,

                Michael

                • 5. Re: EM Database Express for EBS 12.2.7 with 12c
                  Beauty_and_dBest

                  Hi Michael,

                   

                  I am not using client PC. I run sqlplus on the server itself using the  using the TNSNAMES inside the server.

                  • 6. Re: EM Database Express for EBS 12.2.7 with 12c
                    mdtaylor

                    Hi jc,

                     

                    Please ensure you have logged out then back in and then source the 12c environment file if you are switching from one to the other.  Are you sourcing the environment file inside the Oracle Home, or did you set the environment in some custom manner?

                     

                    Regards,

                    Michael

                    • 7. Re: EM Database Express for EBS 12.2.7 with 12c
                      Beauty_and_dBest

                      Yes, I set the Oracle_Home in the .bash_profile as usually done.

                      So I am very sure OracleHome is correct .

                       

                      I can connect using > sqlplus hr/hr

                      But when I use the tns  > sqlplus hr/hr@test1   it can not connect

                       

                       

                      Kind regards,

                      • 8. Re: EM Database Express for EBS 12.2.7 with 12c
                        mdtaylor

                        Hi jc,

                         

                        Rather than setting Oracle_Home is the .bash_profile, source the 12c environment file in that .bash_profile instead.

                         

                        Regards,

                        Michael