1 2 Previous Next 26 Replies Latest reply: Apr 5, 2012 9:02 AM by Pierre-Michael DESHAYES RSS

    Install Control-M with Oracle

    Alberto NameToUpdate

      Hi, I'm trying to install for testing Control-M Server 7 with Oracle 10g XE (installed by myself) in the same machine.

      I did the installation of Oracle, the instance is active, but don't know if I should do something before installing control-m, if I trying to install obtain this error

       

      In check_connection

      ERROR:

      ORA-12154: TNS:could not resolve the connect identifier specified

       

      ERROR:

      ORA-12545: Connect failed because target host or object does not exist

       

      SP2-0306: Invalid option.

      Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

      where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /

      SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

      CONNECTION_OK=N

       

      I searched in the installation guide of control-m, but I didn't find nothing useful.

        • 1. Install Control-M with Oracle
          rasto danis

          listener is running ok ?

          • 2. Install Control-M with Oracle
            Alberto NameToUpdate

            yes the listner is ok.

            • 3. Install Control-M with Oracle
              rasto danis

              is it on unix/linux or windows ? i think you should setup some oracle settings (on unix) before control-m installation - i don't remember exact one, but documentation should contain this

              • 4. Install Control-M with Oracle
                rasto danis

                i just checked doc - have you run check_req_oracle_db.sql mentioned in Control-M Installation Guide ?

                • 5. Re: Install Control-M with Oracle
                  Alberto NameToUpdate

                  it is linux, yes I install oracle and now I'm trying with control-m.

                  I searched in the installation-guide, but nothing

                  • 6. Re: Install Control-M with Oracle
                    rasto danis

                    what about my 2nd post about check_req_oracle_db.sql ?

                    • 7. Re: Install Control-M with Oracle
                      Alberto NameToUpdate

                      There is something strange, but I don't know how fix all warnig and error that the script highlights

                      DB General config

                      =================

                      Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product

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

                      Host OS                                         Linux IA (32-bit)

                      DB_version                                        10.2.0.1

                      InstanceName                                        XE

                      Host name                                        controlm

                      OS user who runs the DB                     oracle

                      Archive status                                        STOPPED

                      Character set                                        WE8MSWIN1252

                      ...Error: WE8MSWIN1252 is unsupported characterset

                      .

                      EM and CTM schemas used on this instance

                      =========================

                      Number of Control-M schemas on this DB          0

                      Number of EM schemas on this DB           0

                      .

                      Verify minimal sizes for storage

                      =========================

                      SYSTEM tablespace size                              340MB

                      ...Warning: SYSTEM tablespace should be at least 500MB.

                      Undo tablespace size                              210MB

                      ...Warning: UNDO tablespace should be at least 500MB.

                      Total TEMP size                               20MB

                      ...Warning: TEMP tablespace should be at least 300MB.

                      Number of REDO groups                              2

                      ...Warning: It is recommended that at least 3 REDO LOG groups are used.

                      Minimal REDO LOG size                              50

                      ...Error: REDO LOG files should not be smaller than 150MB.

                      .

                      Verify minimal values for oracle setting

                      =========================

                      SGA_MAX_SIZE                                        272MB

                      SGA management                                        AUTO

                      SGA_TARGET                                        272MB

                      ...Warning: SGA_TARGET should be at least 900MB.

                      DB_CACHE_SIZE                                        0MB

                      SHARED_POOL_SIZE                              0MB

                      PGA_AGGREGATE_TARGET                              91MB

                      ...Error: PGA_AGGREGATE_TARGET should not be smaller than 200MB

                      PROCESSES                                        40

                      ...Warning: PROCESSES should not be smaller than 300

                      LOG_BUFFER                                        2887168 Bytes

                      .

                      Verify minimal values for oracle setting

                      =========================

                      DB_BLOCK_SIZE                                        8192

                      OPTIMIZER_MODE                                        ALL_ROWS

                      CURSOR_SHARING                                        EXACT

                      ...Warning: CURSOR_SHARING preferable  value is SIMILAR

                      .

                      Check RAC parameters

                      ====================

                      RAC                                                  FALSE

                      MAX_COMMIT_PRPAGATION_DELAY                    0

                      • 8. Re: Install Control-M with Oracle
                        rasto danis

                        try to find in oracle dir - usually in network/admin subfolder files named listener.ora and tnsnames.ora and look into them

                        try to run in <oracle_dir>/bin

                        ./lsnrctl status

                        • 9. Re: Install Control-M with Oracle
                          Alberto NameToUpdate

                          this is the output

                           

                          LSNRCTL> status XE

                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=controlm)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))

                          STATUS of the LISTENER

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

                          Alias                     LISTENER

                          Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

                          Start Date                27-MAR-2012 17:41:17

                          Uptime                    0 days 18 hr. 40 min. 42 sec

                          Trace Level               off

                          Security                  ON: Local OS Authentication

                          SNMP                      OFF

                          Default Service           XE

                          Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora

                          Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

                          Listening Endpoints Summary...

                            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))

                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=controlm)(PORT=1521)))

                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))

                          Services Summary...

                          Service "PLSExtProc" has 1 instance(s).

                            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

                          Service "XE" has 1 instance(s).

                            Instance "XE", status READY, has 1 handler(s) for this service...

                          Service "XEXDB" has 1 instance(s).

                            Instance "XE", status READY, has 1 handler(s) for this service...

                          Service "XE_XPT" has 1 instance(s).

                            Instance "XE", status READY, has 1 handler(s) for this service...

                          The command completed successfully

                          LSNRCTL>

                          • 10. Re: Install Control-M with Oracle
                            rasto danis

                            what did you entered during installation as db server name ? if you used localhost then change it to controlm

                            • 11. Re: Install Control-M with Oracle
                              Alberto NameToUpdate

                              This is my settings...

                              Oracle host name: controlm

                              Oracle listner port number:1521

                              Oracle database service name: XE

                              • 12. Install Control-M with Oracle
                                rasto danis

                                ok i see one more hint:

                                do you have used sys as db connect user ? if you used this user oracle should ask to login as sysdba/sysoper (CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}])

                                maybe try to log as system instead

                                • 13. Re: Install Control-M with Oracle
                                  Alberto NameToUpdate

                                  I used sys as sysdba for startup database, then I can login with system user

                                  • 14. Re: Install Control-M with Oracle
                                    rasto danis

                                    what db user account(s) do you used during ctm installation ?

                                    1 2 Previous Next