on 02-07-2009 12:56 PM
Hi. I have a problem with LiveCache after restoring a system from backup.
We use SCM 5 on AIX and Oracle platform.
Our disk resources in DEV and QA systems a crashed due to failure of storage controller. After that we restored OS and SCM DB from backup. /sapdb folder was not backed up, so we installed fresh LC instance, SR3 media were used (version 7.6.03.08).
After it I couldn't connect SCM to LC. For example in LC10 monitoring button timed out .
Tests in DB 59 were successful, except "Connect. test with session mode "dbmrfc db_state"
RFC test of Destination SAPDB_DBM_DAEMON was successful.
I updated LC to version 7.6.05.12 and LCAPPS to SP7. Now RFC test cannot succeed:
Error Details ERROR: program dbmrfc@sapdb not registered
Error Details LOCATION: SAP-Gateway on host scmqa1 / sapgw10
DB59 test:
Application Server: scmqa1_TSC_10 ( AIX )
1. Connect. test with "dbmcli db_state" Unsuccessful
no_client_software
2. Connect. test with command mode "dbmrfc db_state" Unsuccessful
no_client_software
3. Connect. test with session mode "dbmrfc db_state" Unsuccessful
no_client_software
4. Connect. test with "native SQL" ( LCA ) Successful
dev_w2:
B Sat Feb 7 14:50:59 2009
B Connect to LCA as SAPTLC with scmqa1-TLC
C Try to connect as SAPTLC/<pwd>@scmqa1-TLC on connection 1 ...
C Attach to SAP DB : Kernel 7.6.05 Build 012-123-198-275
C Database release is SAP DB 7.6.05.012
C INFO : Database 'TLC' instance is running on 'scmqa1'
C INFO : LVC DEFAULTCODE = UNICODE
C INFO : Connect to DB as 'SAPTLC'
C Command info enabled
C Now I'm connected to SAP DB
C 01: scmqa1-TLC, since=20090207145059, ABAP= SAPLSADB (12008)
B Connection 1 opened (DBSL handle 1)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 002 000 R/3 000000000 INACTIVE NO YES NO 000 255 255 20090206 173816 scmqa1
B 002 001 LCA 002000002 ACTIVE NO NO NO 004 255 255 20090207 145059 scmqa1
LC10 failed with error message DBM_CONNECT - Error when opening an RFC connection. Password are correct, because they work with dbmcli.
[5]/sapdb/programs/bin/sdbregview -l
DB Analyzer /sapdb/programs 7.6.05.12 64 bit valid
Server Utilities /sapdb/programs 7.6.05.12 64 bit valid
PCR 7300 /sapdb/programs 7.3.00.58 valid
PCR 7301 /sapdb/programs 7.3.01.22 valid
PCR 7500 /sapdb/programs 7.5.00.50 64 bit valid
SAP Utilities /sapdb/programs 7.6.05.12 64 bit valid
APO LC APPS /sapdb/TLC/db/sap 5.00.017 64 bit valid
APO LC APPS /sapdb/SC1/db/sap 5.00.013 64 bit valid
Base /sapdb/programs 7.6.05.12 64 bit valid
Redist Python /sapdb/programs 7.6.05.12 32 bit valid
JDBC /sapdb/programs 7.6.05.06 valid
Messages /sapdb/programs MSG 0.6906 valid
ODBC /sapdb/programs 7.6.05.12 64 bit valid
Database Kernel /sapdb/TLC/db 7.6.05.12 64 bit valid
Database Kernel /sapdb/SC1/db 7.6.03.08 64 bit valid
Loader /sapdb/programs 7.6.05.12 64 bit valid
SQLDBC /sapdb/programs 7.6.05.12 64 bit valid
SQLDBC 76 /sapdb/programs 7.6.05.12 64 bit valid
Fastload API /sapdb/programs 7.6.05.12 64 bit valid
PCR 7403 /sapdb/programs 7.4.03.50 64 bit valid
SC1 is our DEV system, we have the same problem with it.
/sapdb/programs/bin/dbmcli -d TLC -u control,pass db_state
OK
State
ONLINE
/sapdb/programs/bin/dbmcli -d TLC -u control,pass db_enum
OK
SC1#/sapdb/SC1/db #7.6.03.08#fast#offline
SC1#/sapdb/SC1/db #7.6.03.08#quick#offline
SC1#/sapdb/SC1/db #7.6.03.08#slow#offline
SC1#/sapdb/SC1/db #7.6.03.08#test#offline
TLC#/sapdb/TLC/db #7.6.05.12#fast#running
TLC#/sapdb/TLC/db #7.6.05.12#quick#offline
TLC#/sapdb/TLC/db #7.6.05.12#slow#offline
TLC#/sapdb/TLC/db #7.6.05.12#test#offline
/sapdb/programs/bin/dbmcli -d TLC -u control,pass inst_enum
OK
7.6.03.08 /sapdb/SC1/db
7.6.05.12 /sapdb/TLC/db
Please help to solve this problem.
Are you backend and Livecache running on the same instance? If not then you need to install a database client on your backend too.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Evgeniy,
-> As SAP customer you have option to create the OSS ticket to get SAP support, we could login to your system & check the status of the reported issue.
-> Please login to the application server scmqa1 as tscadm user and run the
following commands:
dbmcli -s dbm_getpath IndepProgPath
dbmcli -s dbm_version
echo $PATH
env
update the thread with outputs.
Thank you and best regards, Natalia Khlopina
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.