on 09-24-2014 5:35 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.