CA Service Management

Expand all | Collapse all

CA Service Desk & Oracle database

  • 1.  CA Service Desk & Oracle database

    Posted 06-03-2015 11:18 AM

    HI,

     

       I´m proving a new install CA Service Desk on Oracle database.

     

       Searching for documentation, we can found this point

      https://support.ca.com/cadocs/0/CA%20Service%20Desk%20Manager%20Full%20License%2012%206-ENU/Bookshelf_Files/HTML/CA_SDM_Admin_ENU/index.htm?toc.htm?impguide_install_mdb_oracle_windows.html

     

      About this screen:

     

    20140502_SONDA_CASDM_92.jpg

    1.

    Database Server:

    Documentation:"Indicates an Oracle database is installed on a server other than the CA Service Desk Manager primary server. You manually install the CA MDB on the remote database server (that is, the computer on which Oracle is installed) before you run the CA Service Desk Manager Install.If the Oracle server is local (not selected), CA Service Desk Manager creates the MDB if it is not already created."

     

    Question:

    How can i prove it if works? I´m trying use command ping my database server IP Address, It is right?

     

    How can i prove?

    Ping <IP ADDRESS>

     

    2.

    Oracle Service Name:

     

     

    3.

    Net Service Name:

    Documentation:  "Identifies the Net Service Name of the Oracle database where the MDB resides. If the database is remote, use the Net Service Name defined within the Oracle client on the local computer. CA Service Desk Manager accesses the database using a local installation of the Oracle client, which may specify a Net Service Name that is different than the service name on the Oracle server."

     

    My information in tnsnames.ora

    XE =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = ORAC01.com)(PORT = 1521))

    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME =rcm_sdb))

    )

     

     

    Copy the tnsnames.ora file to the following directory: Oracle_home\network\admin

    (C:\app\oracle\product\11.1.0\db_1\NETWORK\ADMIN)

     

    Note:Oracle_home is the root directory for the Oracle Client package.

     

    Question:


    What can i type? My TNS Name? Following example, i need type "XE"?


    4.

    DBA user name:

    Documentation:"DBA User Name  Specifies the name of an Oracle user with DBA access (usually SYS). This field is only used if the Oracle server is on the local computer."

     

    I can prove using select oracle commands:

     

    select user from dual;

    SELECT * FROM USER_ROLE_PRIVS r

     

    Question:

     

    My user "casdm" is inside to this query like DBA in field "GRANT ROLE", Is it right?

     

    5.

    DBA user password

    Documentation: "Identifies the password for the DBA user. This field is only used if the Oracle server is on the local computer."

     

    6. mdbadmin User Password

    Documentation: "Specifies the mdbadmin user password. Provide the existing password, or specify a new password if CA Service Desk Manager creates the user."

     

    7.

    Confirm mdbadmin User Password

     

    8.

    Tablespace Path

    Documentation: "Tablespace Path Specifies the directory path to the physical tablespace location created if the tablespaces previously mentioned do not exist. This field is only used if the Oracle server is on the local computer."

     

    Question:

     

    Following documentation my oracle database isn´t my local computer. Can i type anything? If dont make difference, Why this field is required?

     

     

    9. Oracle Home Path

    Documentation: "Specifies the directory path to the Oracle home path."

     

    Standard:/app/oracle/product/10.2.0/db_1

    (ORACLE HOME - Oracle FAQ)

     

    Question:

     

    This field not is required, can i type?

     

     

    10. Data Tablespace Name

    Documentation: "Creates the data tablespace name specified when the Create Tablespace check box is selected. This field is only used if the Oracle server is on the local computer"

     

    SELECT * FROM DBA_TABLESPACES (SYSTEM, SYSUX, UNDOTTBS1, TEMP - is standard for Oracle)

     

    In my case the last one is called by USERS

     

     

    Question:

     

    Do i need type USERS?

     

    11.Index Tablespace Name

    Documentation: "Creates the index tablespace name specified when the Create Tablespace check box is selected. This field is only used if the Oracle server is on the local computer."

     

     

    Question:

     

    What can i type here?

     

     

     

     

    After everthing, i got it this error.

    20140502_SONDA_CASDM_51.jpg

     

    1. A new Install 2. C:\app\oracle\product\11.1.0\db_1\NETWORK\ADMIN Mensagem editada por: Tiago MACUL



  • 2.  Re: CA Service Desk & Oracle database

    Posted 06-03-2015 12:29 PM

    Hi Tiago,

     

    Is this against an Oracle database that does NOT have an existing MDB on it?  Or is this an upgrade of some sort?

     

    The install.log file in the above screen print, should have reference to the MDB install log (install_mdb.log )  If you view that file, it would contain additional information about what went wrong and might give some ideas on the action plan

     

    _R



  • 3.  Re: CA Service Desk & Oracle database

    Posted 06-03-2015 01:35 PM

    It is a new installation.

     

    And looking for a install_mdb.log

     

    For my last shot, i got this:

     

    2015/06/04 01.40.42.245 DEBUG [AWT-EventQueue-0] [CmdLineUtility] ERROR:

    2015/06/04 01.40.42.245 DEBUG [AWT-EventQueue-0] [CmdLineUtility] ORA-12154: TNS:could not resolve the connect identifier specified

     

    But ... i dont know how, i can connect using SQL Plus



  • 4.  Re: CA Service Desk & Oracle database

    Posted 06-03-2015 02:38 PM

    Hi Tiago,

     

    You need to create the database as MDB.

    And it refer to Data Tablespace name as MDB_DATA and Index Tablespace Name as MDB_Index.

    So ask the DBA to create these for you and then retest your connection to MDB usign sqlplus and the dba user credentials.

    After you verify all that is working, then proceed with the installation.

     

    Let us know how it goes.

    Regards

    Sandra



  • 5.  Re: CA Service Desk & Oracle database

    Posted 06-03-2015 02:41 PM

    Usually means that your Oracle Client on the installer box is NOT able to resolve the Oracle Server.

     

    Our installer does couple of approaches for this, one is JDBC connectivity and other is sqlplus way too.  Maybe one of them is not working right

     

    _R



  • 6.  Re: CA Service Desk & Oracle database

    Posted 06-03-2015 04:11 PM

    Tiago, can you post the log here...both install.log and install_mdb.log?

    Maybe looking thru the log files gives us some clue. Thanks _Chi



  • 7.  Re: CA Service Desk & Oracle database

    Posted 01-26-2016 10:35 AM

    Hi,

     

    I've one problem on net service name 'unable to connect to oracle through net service name provided'.

     

    Here's my configuration:

     

     

     

    I check on C:\app\oracle\product\11.1.0\db_1\NETWORK\ADMIN and i can't find 'tnsname.ora' so i created with this content:

     

    DESENV, DESENV.*** =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = DBCORPPRDA.***)(PORT = 1521))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = DESENV)

        )

      )

     

    Try to connect to database and the error is the same 'unable to connect to oracle through net service name provided'.

     

    What's wrong?

     

    Thanks,

    Alex



  • 8.  Re: CA Service Desk & Oracle database

    Posted 01-26-2016 11:43 AM

    Net Service Name in the installer should be what you have as the name in the TNSNames.ora file

     

    DESENV, DESENV.***

     

    So,  it should be either  DESENV    OR     DESENV.***

     

    I'd suggest just having one in the TNSNames.ora

     

    DESENV=

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = DBCORPPRDA.***)(PORT = 1521))

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = DESENV)

    )

    )

     

     

    And then use  DESENV   as  Net Service Name

     

    _R

     

     



  • 9.  Re: CA Service Desk & Oracle database

    Posted 01-26-2016 12:33 PM

    Hi

     

    Thanks a lot for your quick answer.

     

    I change the configuration file but the error remains.

     

    On Oracle database server, tnsnames.ora file need to have the same configuration?

     

    Thanks,

    Alex



  • 10.  Re: CA Service Desk & Oracle database

    Posted 01-26-2016 12:42 PM

    Well, the box where the install is being done,  that box should have the correct configuration from Oracle Client perspective.

     

    But from Oracle Server perspective,  on the Oracle server try this:

     

    lsnrcl status

     

    This should show what Services / Instance Names  that the listener knows about and to what TCP ports they are bound to.  That might help you with the entry in  Service_Name  that you are passing in tnsnames.ora  on the client box

     

    _R



  • 11.  Re: CA Service Desk & Oracle database

    Posted 01-29-2016 08:00 AM

    This is what you need

    1.jpg

     

     

     

     

    newmdb =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = typeyourdbhostname)(PORT = 1525))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (sid  = newmdb)

        )

      )

     

    keep the data tablespace name and index same and default like i did.

     

    you need oracle 32 bit client installed and tnsnames.ora and sqlnet.ora must exist.

     

    net service name and SID/Service Name can be different. net service name is a given name local to the box where you have client installed. SID/Service Name must match DB host.

     

    tablespace path is your oracle_home

     

     

    However i got that cdb error once upgrading from 12.5 to 14.1 in a test environment and never tried to resolve that



  • 12.  Re: CA Service Desk & Oracle database

    Posted 01-29-2016 09:43 AM

    Hi,

     

    Thanks a lot for your help.

     

    It was very useful and works as expected.

     

    Regards,

    Alex