AnsweredAssumed Answered

CA Service Desk & Oracle database

Question asked by TMACUL Champion on Jun 3, 2015
Latest reply on Jan 29, 2016 by alexandre_costa91

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

Outcomes