cancel
Showing results for 
Search instead for 
Did you mean: 

Heterogeneous System copy in SAP R/3 4.6C

0 Kudos

Hi,

We are doing migration of SAP R/3 4.6C (OS Unix true 64, oracle 8.1.7) to SAP R/3 4.6C (AIX 5.3, oracle 9). And during export activity using command ./R3SETUP -f DBEXPORT.R3S from root as per guide we are getting error like below

DBEXPORT.log

ERROR 2014-09-22 15:47:26 DBDBSLTESTCONNECT_IND_ORA SyDbslConnect:100

    Cannot connect to DB. rc = 256

ERROR 2014-09-22 15:47:26 DBDBSLTESTCONNECT_IND_ORA InternalInstallationDo:0

    RC code form SyChildFuncWait  = 255 .

ERROR 2014-09-22 15:47:26 DBDBSLTESTCONNECT_IND_ORA InternalInstallationDo:0

    ERROR connect to DB via DBSL.

dev_dbsl

DbSl Trace: dbsloci.c 5112  Logon as OPS$-user to get SAPR3's password

DbSl Trace: dbsloci.c 6538  Connecting as /@TC1 on connection 0 ...

DbSl Trace: dboci.c 2402  -->oci_logon(con_hdl=0, user='', dbname='TC1')

DbSl Trace: dboci.c 2423  OCI-call 'olog' failed: rc = 12154

DbSl Trace: dbsloci.c 6550  CONNECT failed with sql error '12154'

DbSl Trace: dbsloci.c 5158  Try to connect with default password

DbSl Trace: dbsloci.c 6538  Connecting as SAPR3/<pwd>@TC1 on connection 0 ...

DbSl Trace: dboci.c 2402  -->oci_logon(con_hdl=0, user='SAPR3', dbname='TC1')

DbSl Trace: dboci.c 2423  OCI-call 'olog' failed: rc = 12154

DbSl Trace: dbsloci.c 6550  CONNECT failed with sql error '12154'

SAPR3 user is open at db level & not expired. please suggest how can we proceed further.

Accepted Solutions (0)

Answers (3)

Answers (3)

Reagan
Advisor
Advisor
0 Kudos

Start with the SAP note 443867 - ORA-12154 Collective SAP note

Check all the points mentioned in the note. If there is @ in the password then change the password.

You can update the source system kernel to the latest patch level.

Regards

RB

Former Member
0 Kudos

Dear

DbSl Trace: dboci.c 2423  OCI-call 'olog' failed: rc = 12154

Check the access to the Oracle Instant Client files

---

DbSl Trace: dbsloci.c 5158  Try to connect with default password

You need to start the Oracle database and then restart R/3 setup. Check the

database listener is running and that you can connect internal.

Hi Check out note 72248 aND 122597

--

DbSl Trace: dbsloci.c 6550  CONNECT failed with sql error '12154'

If yes check the tnsnames.ora in oracle_home/network/admin and check whether the entries are relevant or not.

--

DbSl Trace: dbsloci.c 5112  Logon as OPS$-user to get SAPR3's password

Is the listener service up when you are doing this?

This is the problem with access files

your listener should in automatic mode whenever you start the migration listrener has to start automatically it only who listen to database and pass all services to app servers

Regards

former_member188883
Active Contributor
0 Kudos

Hi John,

From the logs


DbSl Trace: dboci.c 2423  OCI-call 'olog' failed: rc = 12154

DbSl Trace: dbsloci.c 6550  CONNECT failed with sql error '12154'

DbSl Trace: dbsloci.c 5158  Try to connect with default password

DbSl Trace: dbsloci.c 6538  Connecting as SAPR3/<pwd>@TC1 on connection 0 ...

DbSl Trace: dboci.c 2402  -->oci_logon(con_hdl=0, user='SAPR3', dbname='TC1')

Looks like an issue with listener service. Please check the file consistency with respect to open and close brackets under listener.ora and tnsnames.ora files.

Regards,

Deepak Kori

0 Kudos

Hi Deepak,

Please find listener.ora

more /usr3/oracle/TC1/817_64/network/admin/listener.ora

################

# Filename......: template listener.ora

# Name..........:

# Date..........:

################

LISTENER =

  (ADDRESS_LIST =

        (ADDRESS=

          (PROTOCOL=IPC)

          (KEY= LISTENER1.world)

        )

        (ADDRESS=

          (PROTOCOL=IPC)

          (KEY= TC1)

        )

        (ADDRESS =

          (COMMUNITY = sap.world)

          (PROTOCOL = TCP)

          (Host = TCLAPL1)

          (Port = 1527)

        )

  )

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = TC1)

      (ORACLE_HOME = /usr3/oracle/TC1/817_64)

      (PRESPAWN_MAX = 10)

    )

  )

and tnsnames.ora

################

# Filename......: tnsnames.ora

# Name..........: LOCAL_REGION.world

# Date..........: 29-MAY-96 11:51:26

################

TCL.world =

  (DESCRIPTION =

    (SDU = 4096)

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = sap.world)

          (PROTOCOL = TCP)

          (Host = TCLSAP)

          (Port = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = TCL)

       (GLOBAL_NAME = TCL.world)

    )

  )

TC1.world =

  (DESCRIPTION =

(SDU = 4096)

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = sap.world)

          (PROTOCOL = TCP)

          (Host = TCLAPL1)

          (Port = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = TC1)

       (GLOBAL_NAME = TC1.world)

    )

  )

standby.world =

  (DESCRIPTION =

    (SDU = 4096)

    (ADDRESS_LIST =

        (ADDRESS =

(COMMUNITY = sap.world)

          (PROTOCOL = TCP)

          (Host = TCLPROD)

          (Port = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = TC1)

       (GLOBAL_NAME = standby.world)

    )

  )

please find the both files and les us tell me where we need to change