7 Replies Latest reply: Mar 29, 2013 10:48 AM by jiyong RSS

    connecting siebel sample database thorgh oracle 11g

    998962
      Hi,
      I have installed siebel 8 and its sample database also.
      I want to populate my siebel server database with data in the sample database.
      Server database is on oracle 11G.
      If any one has any idea please let me know.


      Thanks,
      SSS
        • 1. Re: connecting siebel sample database thorgh oracle 11g
          jiyong
          I think the easiest solution is to use the dataexp and dataimp tools.
          Do note that theses tools are not (fully) supported by Siebel.

          I have done this in the past, but I don't have the document at hand here.

          Here are some links to get you started:

          Re: dataexp , data imp on siebel 8
          http://siebel.ittoolbox.com/groups/technical-functional/siebel-admin-l/how-to-import-siebel-78-sample-database-into-siebel-server-1790385
          http://docs.oracle.com/cd/E14004_01/books/UPG/UPG_DB_Upg_Util14.html#wp1459931

          It could be that when you get the prompt for the table name with dataexp, that you can press enter (without filling in anything), or use a wildcard.
          • 2. Re: connecting siebel sample database thorgh oracle 11g
            998962
            I tried heterogeneous connection but i am getting ORA-28545 and ORA-02063.
            • 3. Re: connecting siebel sample database thorgh oracle 11g
              jiyong
              Can you tell me the steps you did so far and at which step did you get the errors?
              • 4. Re: connecting siebel sample database thorgh oracle 11g
                998962
                I have created a DSN called mig_dsn to sybase database using siebel oracle90 driver....
                ***********************************************************************************
                my initmig_dsn.ora file is as follows

                # This is a sample agent init file that contains the HS parameters that are
                # needed for the Database Gateway for ODBC

                #
                # HS init parameters
                #
                HS_FDS_CONNECT_INFO = mig_dsn
                HS_FDS_TRACE_LEVEL = off

                #
                # Environment variables required for the non-Oracle system
                #
                #set <envvar>=<value>
                *********************************************************************************************
                my listener.ora file is as follows....

                # listener.ora Network Configuration File: D:\app\10604064\product\11.2.0\dbhome_1\network\admin\listener.ora
                # Generated by Oracle configuration tools.

                SID_LIST_LISTENER =
                (SID_LIST =
                (SID_DESC =
                (SID_NAME = CLRExtProc)
                (ORACLE_HOME = D:\app\10604064\product\11.2.0\dbhome_1)
                (PROGRAM = extproc)
                (ENVS = "EXTPROC_DLLS=ONLY:D:\app\10604064\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                )
                )
                LISTENER =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                (ADDRESS = (PROTOCOL = TCP)(HOST = INFVA05676.vshodc.lntinfotech.com)(PORT = 1521))
                )
                )

                mig_dsn =
                (ADDRESS_LIST=
                (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=2582))
                )

                SID_LIST_mig_dsn=
                (SID_LIST=
                (SID_DESC=
                (SID_NAME=mig_dsn)
                (ORACLE_HOME=D:\app\10604064\product\11.2.0\dbhome_1)
                (PROGRAM=hsodbc)
                )
                )

                ADR_BASE_LISTENER = D:\app\10604064
                )
                ********************************************************************************************************
                my tnsnames.ora file is as follows......

                # tnsnames.ora Network Configuration File: D:\app\10604064\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
                # Generated by Oracle configuration tools.

                ORACLR_CONNECTION_DATA =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                )
                (CONNECT_DATA =
                (SID = CLRExtProc)
                (PRESENTATION = RO)
                )
                )

                ORCL =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = INFVA05676.vshodc.lntinfotech.com)(PORT = 1521))
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = orcl)
                )
                )

                MIG_DSN =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 2582))
                (CONNECT_DATA = (SID = mig_dsn))
                (HS=OK)
                )

                ***************************************************************************************************
                Starting the listener

                C:\Windows\system32>lsnrctl start mig_dsn

                LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-MAR-2013 14:41
                :35

                Copyright (c) 1991, 2010, Oracle. All rights reserved.

                Starting tnslsnr: please wait...

                TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                System parameter file is D:\app\10604064\product\11.2.0\dbhome_1\network\admin\l
                istener.ora
                Log messages written to d:\app\10604064\diag\tnslsnr\INFVA05676\mig_dsn\alert\lo
                g.xml
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2582)))

                Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=2582))
                STATUS of the LISTENER
                ------------------------
                Alias mig_dsn
                Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                ction
                Start Date 26-MAR-2013 14:41:41
                Uptime 0 days 0 hr. 0 min. 5 sec
                Trace Level off
                Security ON: Local OS Authentication
                SNMP OFF
                Listener Parameter File D:\app\10604064\product\11.2.0\dbhome_1\network\admin\
                listener.ora
                Listener Log File d:\app\10604064\diag\tnslsnr\INFVA05676\mig_dsn\alert\
                log.xml
                Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2582)))
                Services Summary...
                Service "mig_dsn" has 1 instance(s).
                Instance "mig_dsn", status UNKNOWN, has 1 handler(s) for this service...
                The command completed successfully
                ************************************************************************************************************

                tnsping results..

                C:\Windows\system32>tnsping mig_dsn

                TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-MAR-2
                013 14:42:40

                Copyright (c) 1997, 2010, Oracle. All rights reserved.

                Used parameter files:
                D:\app\10604064\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


                Used TNSNAMES adapter to resolve the alias
                Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
                t)(PORT = 2582)) (CONNECT_DATA = (SID = mig_dsn)) (HS=OK))
                OK (0 msec)

                ***************************************************************************************************************
                I have created a public database link called sample.
                But when i query the database it is giving me following error...

                Error starting at line 1 in command:
                select * from s_prod_defect@sample
                Error at Command Line:1 Column:28
                Error report:
                SQL Error: ORA-28545: error diagnosed by Net8 when connecting to an agent
                Unable to retrieve text of NETWORK/NCR message 65535
                ORA-02063: preceding 2 lines from SAMPLE
                28545. 0000 - "error diagnosed by Net8 when connecting to an agent"
                *Cause: An attempt to call an external procedure or to issue SQL
                to a non-Oracle system on a Heterogeneous Services database link
                failed at connection initialization. The error diagnosed
                by Net8 NCR software is reported separately.
                *Action: Refer to the Net8 NCRO error message. If this isn't clear,
                check connection administrative setup in tnsnames.ora
                and listener.ora for the service associated with the
                Heterogeneous Services database link being used, or with
                'extproc_connection_data' for an external procedure call.


                Thanks & regards,
                SSS
                • 5. Re: connecting siebel sample database thorgh oracle 11g
                  jiyong
                  I don't think that's going to work.

                  You can try to use dataexp to export the data from the sample database, using the ODBC connection that was created when the sample database was installed.
                  The export file can be imported with dataimp through the ODBC connection to the Oracle DB.
                  • 6. Re: connecting siebel sample database thorgh oracle 11g
                    998962
                    Can u please explain how to do it

                    Thanks in advance
                    SSS
                    • 7. Re: connecting siebel sample database thorgh oracle 11g
                      jiyong
                      I assume a correct ODBC was created when you installed the sample DB.
                      I assume you know how to create an ODBC to an Oracle DB.

                      Here is an example on how to use dataexp: http://docs.oracle.com/cd/E14004_01/books/UPG/UPG_DB_Upg_Util14.html#wp1459931
                      Don't mind the Unix. At the prompt for the table, either press enter without filling in anything, or try to use a wildcard (like *).

                      Dataimp is not that much different.
                      When you start it without parameters, it will probably show you which ones you can use (most are the same).