1 2 Previous Next 26 Replies Latest reply: Apr 5, 2012 9:02 AM by pmdeshayes 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