CA Service Desk & Oracle database

[TMACUL]

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:

 

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.

 

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

[Raghu Rudraraju]

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

[TMACUL]

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

[Sandra_Antunes]

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

[Raghu Rudraraju]

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

[Chi Chen]

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

[Anon Anon]

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

[Raghu Rudraraju]

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

 

 

[Anon Anon]

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

[Raghu Rudraraju]

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

[sudip.bhowmik]

This is what you need

 

 

 

 

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

[Anon Anon]

Hi,

 

Thanks a lot for your help.

 

It was very useful and works as expected.

 

Regards,

Alex