7 Replies Latest reply on Mar 29, 2013 3:48 PM by jiyong

    connecting siebel sample database thorgh oracle 11g

      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.

        • 1. Re: connecting siebel sample database thorgh oracle 11g
          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

          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
            I tried heterogeneous connection but i am getting ORA-28545 and ORA-02063.
            • 3. Re: connecting siebel sample database thorgh oracle 11g
              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
                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 =


                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))

                Starting the listener

                C:\Windows\system32>lsnrctl start mig_dsn

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

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

                Starting tnslsnr: please wait...

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

                Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=2582))
                STATUS of the LISTENER
                Alias mig_dsn
                Version TNSLSNR for 64-bit Windows: Version - Produ
                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 Log File d:\app\10604064\diag\tnslsnr\INFVA05676\mig_dsn\alert\
                Listening Endpoints Summary...
                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 - Production on 26-MAR-2
                013 14:42:40

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

                Used parameter files:

                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,
                • 5. Re: connecting siebel sample database thorgh oracle 11g
                  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
                    Can u please explain how to do it

                    Thanks in advance
                    • 7. Re: connecting siebel sample database thorgh oracle 11g
                      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).