| Mandalika's scratchpad | [ Work blog @Oracle | My Music Compositions ] |
Old Posts: 09.04 10.04 11.04 12.04 01.05 02.05 03.05 04.05 05.05 06.05 07.05 08.05 09.05 10.05 11.05 12.05 01.06 02.06 03.06 04.06 05.06 06.06 07.06 08.06 09.06 10.06 11.06 12.06 01.07 02.07 03.07 04.07 05.07 06.07 08.07 09.07 10.07 11.07 12.07 01.08 02.08 03.08 04.08 05.08 06.08 07.08 08.08 09.08 10.08 11.08 12.08 01.09 02.09 03.09 04.09 05.09 06.09 07.09 08.09 09.09 10.09 11.09 12.09 01.10 02.10 03.10 04.10 05.10 06.10 07.10 08.10 09.10 10.10 11.10 12.10 01.11 02.11 03.11 04.11 05.11 07.11 08.11 09.11 10.11 11.11 12.11 01.12 02.12 03.12 04.12 05.12 06.12 07.12 08.12 09.12 10.12 11.12 12.12 01.13 02.13 03.13 04.13 05.13 06.13 07.13 08.13 09.13 10.13 11.13 12.13 01.14 02.14 03.14 04.14 05.14 06.14 07.14 09.14 10.14 11.14 12.14 01.15 02.15 03.15 04.15 06.15 09.15 12.15 01.16 03.16 04.16 05.16 06.16 07.16 08.16 09.16 12.16 01.17 02.17 03.17 04.17 06.17 07.17 08.17 09.17 10.17 12.17 01.18 02.18 03.18 04.18 05.18 06.18 07.18 08.18 09.18 11.18 12.18 01.19 02.19 05.19 06.19 08.19 10.19 11.19 05.20 10.20 11.20 12.20 09.21 11.21 12.22
Assuming the RDBMS is up and running, first make sure the database client connects to the Siebel database instance from the command line interface. For example, if Oracle is the RDBMS, then:
- Check the $TNS_ADMIN/tnsnames.ora ($TNS_ADMIN\tnsnames.ora on Windows)
eg.,% cat $TNS_ADMIN/tnsnames.ora
siamst =
(DESCRIPTION =
(ADDRESS_LIST =
(SDU = 15360)
(TDU = 15360)
(ADDRESS = (PROTOCOL = TCP)(HOST = ben07)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = siamst)
)
) - Make sure you can ping the listener running on the database server
eg.,% tnsping siamst
TNS Ping Utility for Solaris: Version 11.1.0.6.0 - Production on 15-FEB-2008 11:06:02
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/export/home/oracle/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (SDU = 15360) (TDU = 15360)
(ADDRESS = (PROTOCOL = TCP)(HOST = ben07)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = siamst)))
OK (10 msec) - Finally using the command line utility, sqlplus, connect to the Oracle database instance with the table owner for the Siebel database schema. The following example assumes 'oraperf' is the table owner for the Siebel database schema.
eg.,% sqlplus oraperf/oraperf@siamst
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 15 11:11:54 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> set head off
SQL> select * from s_app_ver;
0-70 01-JAN-80 0-1 16-FEB-01 0-1
16 0 V8.0
13 29
43 Y 0
Database Schema for Siebel 2005 43r88_HEM17_06_SIA
1 0
88
71
HQ
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options - If the above step fails to connect to the Oracle database instance, check the connect string, table owner etc., fix them if needed and repeat the above step.
Usually the above steps are good enough to test the database connectivity. However it is recommended to test the database connectivity using Siebel's odbcsql utility as well, just to make sure that there won't be any trouble for the Siebel servers in communicating with the database server.
- Set the required environment variables
eg.,% source $SIEBEL_HOME/siebenv.sh (csh)
% . $SIEBEL_HOME/siebenv.sh (ksh) - Bring up the odbcsql command line interface (CLI), connect to the Oracle database instance using the table owner login/password
eg.,% odbcsql
ODBCSQL - ODBC SQL Interface program
Copyright (c) 2001 Siebel Systems, Inc. All rights reserved.
Type help for usage information.
ODBC> set source=siebsrvr_siebel
ODBC> login oraperf/oraperf
SQL DBMS: Oracle version 10.02.0000 Oracle 10.2.0.1.0
ODBC driver: SEor821.so version 05.10.0017 (B0011, U0004)
(login time: 0.73s)
ODBC> quit
Outstanding transaction committed.
Alternatively it can be tested in a single line as shown below:% odbcsql /s siebsrvr_siebel /u oraperf /p oraperf
ODBCSQL - ODBC SQL Interface program
Copyright (c) 2001 Siebel Systems, Inc. All rights reserved.
Type help for usage information.
Logging into "siebsrvr_siebel" as "oraperf" ...
SQL DBMS: Oracle version 10.02.0000 Oracle 10.2.0.1.0
ODBC driver: SEor821.so version 05.10.0017 (B0011, U0004)
(login time: 0.67s)
ODBC> quit
Outstanding transaction committed.
If it fails to connect, double check the connect string specified during the installation of Siebel server.
____________________________
Technorati Tags:
Oracle | 
Siebel | 
CRM | 
Database
| 2004-2019 |
|
