Unable to start LiveCache

[former_member199694]

hi,

I have restored /sapdb dir from backup. The data /log volumes are intact and no changes. When trying to start, x_server is starting. However, I am unable to connect to DB instance.

dbmcli -d LBS -u control,control - does not connect...

Any suggestion is welcome.

Thanks,

RajS

[markus_doehr2]

> dbmcli -d LBS -u control,control - does not connect...

...you get an error message?

Markus

[former_member199694]

No error message. It just hangs for long. when contl-C twice, getting below message.

Error! Connection failed to node (local) for database LBS

It looks connecting to DB instance is an issue. I tried to install the last patch again.. it was giving error message as below:

./SDBUPD -d LBS -u control,pwd

beginning to check sap db instances

start new instance update

cannot establish database instance session:

cannot get information about instance LBS

may be paramfile, user profile container or

registration of instance corrupted

check this and restart installation

Not sure, if restore of /sapdb filesystem would need any other steps fully functional. Database is not changed..

note - prior to this restore of /sapdb, it was upgraded to 7.07.37

Thanks,

Raj

Edited by: Rajagopal Sampath on Dec 22, 2011 6:49 PM

Edited by: Rajagopal Sampath on Dec 22, 2011 7:16 PM

[former_member229109]

Please review: u201CCreating a clone manually via reusing volumes and parametersu201D

at http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo-CreatingacloneofaSAPMaxDB+database

You wrote:u201D have restored /sapdb dir from backup. The data /log volumes are intact and no changes.u201D

=>

-> What is the version of the database?

-> Did you create the OS FS backup, when the DB was offline?

-> What do you mean that u201Cdata /log volumes are intact and no changesu201D?

Did you include the data/log volumes in your FS backup?

-> What are the outputs of the following commands:

Dbmcli inst_enum

Dbmcli db_enum

Sdbregview u2013l

Regards, Natalia Khlopina

[former_member199694]

hi Natalia,

FS backup does not include data/log volumes as Link file is pointing to raw devices. Restore looks missing some of the files, resulting issues in connecting to DB instance. Off-line data backup is available, which could be used to restore the livecache, however could not connect to existing DB instance. When tried to create instance, it says already the instance is available and could not drop the DB instance as the result.

below are output for the commands executed:

Executed sdbverify and made corrupted package as invalid and reinstalled the 7.6.06.16 over existing files. x_sever is starting.. However, dbmcli is not connecting to DB instance. It hangs.. below shows cancelled using control-C and got below error message.

• If I know the list files to be removed/ renamed/edited, sothat I could create the same instance.

sapdev91:> dbmcli -d LBS -u control,pwd

^CCError! Connection failed to node (local) for database LBS:

Reading header from pipe:(32:Broken pipe

sapdev91:>

sapdev91:> dbmcli inst_enum

OK

7.6.06.16 /sapdb/LBS/db

sapdev91:> dbmcli db_enum

OK

LBS /sapdb/LBS/db 7.6.06.16 fast offline

LBS /sapdb/LBS/db 7.6.06.16 quick offline

LBS /sapdb/LBS/db 7.6.06.16 slow offline

LBS /sapdb/LBS/db 7.6.06.16 test offline

sapdev91:> sdbregview -l

DB Analyzer /sapdb/programs 7.6.06.16 64 bit valid

Perl Interface /sapdb/programs 7.4.03.19 32 bit valid

Server Utilities /sapdb/programs 7.6.06.16 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.60 valid

CPC Base /sapdb/programs 7.4.03.19 64 bit valid

PCR 7301 /sapdb/programs 7.3.01.22 valid

PCR 7500 /sapdb/programs 7.5.00.52 64 bit valid

Python Interface /sapdb/programs 7.4.03.19 32 bit valid

Webtools /sapdb/programs/web 7.4.03.19 64 bit valid

SAP Utilities /sapdb/programs 7.6.06.16 64 bit valid

APO LC APPS /sapdb/LBS/db/sap 5.00.021 64 bit valid

Redist Python /sapdb/programs 7.6.06.16 32 bit valid

Base /sapdb/programs 7.6.06.16 64 bit valid

JDBC /sapdb/programs 7.6.05.06 valid

Messages /sapdb/programs MSG 0.8215 valid

ODBC /sapdb/programs 7.6.06.16 64 bit valid

Database Kernel /sapdb/LBS/db 7.6.06.16 64 bit valid

Loader /sapdb/programs 7.6.06.16 64 bit valid

CPC SDK 7403 /sapdb/programs 7.4.03.19 64 bit invalid

PCR 7600 /sapdb/programs 7.6.00.12 64 bit invalid

SQLDBC /sapdb/programs 7.6.06.16 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.06.16 64 bit valid

Fastload API /sapdb/programs 7.6.06.16 64 bit valid

PCR 7403 /sapdb/programs 7.4.03.50 64 bit valid

sapdev91:>

Thanks,

RajS

[former_member199694]

When I try to start LiveCache from Database Manager, it process for long time and finally gives error as: "-4 socket receive error [10054]".

I checked Note 1321675 - Database error -10807 at OPC - My system is installed in Sun Solaris 10 and not sure, if this has any issues as in the note.

Not sure, if this means some client connection issue with database instance..

Thanks,

RajS

[Former Member]

Hello,

Check and post the X_SERVER logfile that is located at /sapdb/data/wrk/xserver_<>.prt. Also take a look into the logs dbmsrv_<>.prt, knldiag.err and lcinit.log...These logs could help you to investigate your problem.

Also check the firewall permissions between your machine and server. Maybe you have no authorization to connect to the port 7210. This could be reason for the error 10054.

Check the file systems permissions too.

[former_member199694]

hi Leo,

x_server is getting started. There is No dbmsrv_.prt, knldiag.err and lcinit.log are created. Only x_server logs are available.

However, connecting to DB instance is an issue. When trying with DB Manager / DBMCLI to logon, it simply hangs.

-

---

Message-Text

-

---

started, 'X64/SUN 7.6.06 Build 016-123-239-72

Service port is 7210

Command line arguments

[1] start

Command line argument dump completed

Resource limit dump start

Started by user id 5892 group id 1014

Current user id 5892 effective id 5892

Current group id 1014 effective id 1014

cpu time unlimited

number of processes 29995

number of open files 65536

core size unlimited

file size unlimited

heap memory size unlimited

stack memory size 8192 KBytes

virtual memory size unlimited

Resource limit dump completed

Environment dump start

LD_LIBRARY_PATH=/sapdb/programs/lib

DBROOT=/sapdb/programs

LOGNAME=sdb

USER=sdb

TMPDIR=/var/tmp

TMP=/var/tmp

TZ=US/Central

IFS=

PATH=/usr/xpg4/bin:/usr/ccs/bin:/usr/bin

:/opt/SUNWspro/bin

Environment dump completed

[former_member229109]

Hello,

1. Did you create the SAP message, where this issue was reported?

2. Could you rename the Databases.ini file located in /sapdb/data/config to Databases.ini.old & then try to create the database instance.

Please update with output:

ls -l /sapdb/data

ls -l /sapdb/data/wrk

ls -l /sapdb/data/pid

ls -l /sapdb/data/fifo

xinstinfo LBS

Regards, Natalia Khlopina

[former_member199694]

All,

Thanks.. Worked with SAP Support and restored from backup and restarted LC.

Regards,.

RajS