SQL error installing SAP-basis
Christof Fischer
christof.fischer at web.de
Fri Jan 25 20:40:07 MET 2002
Ok, me again. Your suggestion solved the first problem. But when the
install procedure continued, Murphy s law hit my harddisk and I had to
change it. Now the whole procedure started again. I did everything as I
learnd in the previous attempt. Changed the permissions for
Registry.dcom and its link etc. Installed all the packages including the
license rpm and startet again the rpm -ivh sapbasis-6.10-1.noarch.rpm.
Now I have the following errors in createdb.sh.1487.log:
OK
*** Fri Jan 25 20:29:21 2002
db_start
---
ERR
-24994,ERR_RTE: runtime environment error
1,Kernel exited with '2297' before reaching COLD state
*** Fri Jan 25 20:29:21 2002
util_connect CONTROL,CONTROL
---
ERR
-24988,ERR_SQL: sql error
1,database not running
*** Fri Jan 25 20:29:21 2002
util_execute init config
---
ERR
-24988,ERR_SQL: sql error
1,database not running
*** Fri Jan 25 20:29:21 2002
util_activate SUPERDBA,ADMIN
---
ERR
-24992,ERR_NOUTILSESSION: no utility session available
*** Fri Jan 25 20:29:21 2002
util_release
---
OK
*** Fri Jan 25 20:29:21 2002
load_systab -u SUPERDBA,ADMIN -ud DOMAIN
---
ERR
-24936,ERR_DBNORUN: database is not running
*** Fri Jan 25 20:29:21 2002
sql_connect SUPERDBA,ADMIN
---
ERR
-24988,ERR_SQL: sql error
1,database not running
*** Fri Jan 25 20:29:21 2002
sql_execute CREATE USER sapwas PASSWORD SAP DBA NOT EXCLUSIVE
---
ERR
-24988,ERR_SQL: sql error
1,database not running
*** Fri Jan 25 20:29:21 2002
sql_connect sapwas,SAP
---
ERR
-24988,ERR_SQL: sql error
1,database not running
*** Fri Jan 25 20:29:21 2002
sql_execute CREATE SEQUENCE DDLOG_SEQ MINVALUE -2147483646 MAXVALUE
2147483646 INCREMENT BY 1 START WITH -2147483646 NOCACHE NOORDER NOCYCLE
---
ERR
-24988,ERR_SQL: sql error
1,database not running
It seems to be a problem of the kernel???? 2.4.10 (see below).
regards
christof
Timo Krisch wrote:
> Hello Christof,
>
> thank you for the newest informations.
>
> The problem looks like violation of permissions and ownership, which can
> occur during
> any installations.
>
> Logon to your system and do a
>
> locate Registry.dcom (the concerning path will be shown)
>
> Change to this directory ( that should be /opt/sapdb/depend/wrk/ ) and
> do a
>
> ls -als Registry.dcom
>
> The problem could be that this file has the owner root.
>
> Change the permissions and ownership via
>
> chown wasadm:sapsys Registry.dcom
>
> The concerning file is a symbolic link to
> /var/opt/sapdb/indep_data/config/Registry1.dcom;
> so change to /var/opt/sapdb/indep_data/config/ and do a
>
> ls -als Registry1.dcom
>
> and set permission and ownership
>
> chown wasadm:sapsys Registry1.dcom
>
> Best regards
>
> Your LinuxLab Team
>
>
>
> christof.fischer at web.de wrote:
>
>>Hi,
>>
>>here is the content of knldiag.err:
>>
>>Date Time TID Typ MsgID Label Message-Text
>>--------------------------------------------------------------------------------
>>2002-01-18 23:01:09 --- Starting ---
>>2002-01-18 23:04:01 6601 ERR 11000 DCOM-DMP sqlComObjectGet(liveCache.dbpInstall.V72) error: access_denied_eo78
>>2002-01-18 23:04:01 6601 ERR 51260 HRESULT 00000002
>>2002-01-18 23:50:18 --- Starting ---
>>2002-01-18 23:53:11 7724 ERR 11000 DCOM-DMP sqlComObjectGet(liveCache.dbpInstall.V72) error: access_denied_eo78
>>2002-01-18 23:53:11 7724 ERR 51260 HRESULT 00000002
>>
>>It seems to be an access error. I started the rpm installation as
>>root. But I cant figure out of this errors what I should do now...
>>
>>regards
>>
>>christof
>>
>>linux-general at sap.com schrieb am 21.01.02:
>>
>>>Hello Christof,
>>>
>>>thank you for giving us your hardware and software informations.
>>>
>>>Now please have a look at the
>>>
>>>/var/opt/sapdb/indep_data/wrk/WAS/knldiag.err
>>>
>>>Usually you can find the relevant error messages in this file.
>>>
>>>Please send us the content you've found - so we can find out
>>>the cause of error.
>>>
>>>Best regards
>>>
>>>Your LinuxLab Team
>>>
>>>christof.fischer at web.de wrote:
>>>
>>>>Hi Peter,
>>>>
>>>>I use SUSE Linux 7.3, Kernel 2.4.10
>>>>
>>>>I work on an Athlon 600 Mhz and use for the SAP directory a partition
>>>>with 15 GB free space. What do you mean with pre-install rpms?
>>>>
>>>>I read the install file and made the outlined Pre-installation settings (everything as user 'root'):
>>>>
>>>>* I created a swap partition with 1.5 GB and activated it via swapon
>>>>
>>>>* hostname returns the name of my computer and not the full IP
>>>>
>>>>* I set the suggested kernel parameters to the given values
>>>>
>>>>* I installed the rpms for openldap and IBMJava2-JRE (though I have a
>>>>SUN JRE 1.3 on my computer)
>>>>
>>>>* I installed the sapdb-ind and sapdb-srv found on the CD
>>>>
>>>>* I installed the sapappsrv-sapdb-6.10-1
>>>>
>>>>* I installed the hardwarekey received from SAP
>>>>
>>>>* After that I started: rpm -ivh sapbasis-6.10-1.noarch.rpm
>>>>
>>>>The installation process started and aborted after a while. Here a snipplet from screen-output of rpm:
>>>>
>>>>begin snip ------------------------------------
>>>>ikarus:/cdrom # rpm -ivh sapbasis-6.10-1.noarch.rpm
>>>>23:50:14 initializing database instance WAS (3750MB data, 300MB log) ...
>>>>database creation failed
>>>>see dbclient log file /tmp/createdb.sh.7620.log for the db command trace
>>>>execution of sapbasis-6.10-1 script failed, exit status 1
>>>>end snip --------------------------------------
>>>>
>>>>Again here the snipplet from the log createdb.sh.7620.log:
>>>>
>>>>begin snip--------------------------------------
>>>>
>>>>*** Fri Jan 18 23:53:09 2002
>>>>util_execute init config
>>>>---
>>>>OK
>>>>*** Fri Jan 18 23:53:10 2002
>>>>util_activate SUPERDBA,ADMIN
>>>>---
>>>>OK
>>>>*** Fri Jan 18 23:53:10 2002
>>>>util_release
>>>>---
>>>>OK
>>>>*** Fri Jan 18 23:53:12 2002
>>>>load_systab -u SUPERDBA,ADMIN -ud DOMAIN
>>>>---
>>>>ERR
>>>>-24964,ERR_EXECUTE: error in program execution
>>>>1792,/opt/sapdb/depend/bin/xload -S INTERNAL -n ikarus -d WAS -u SUPERDBA,* -b /opt/sapdb/depend/env/lsystab.ins en ENG DOMAIN
>>>>Some SQL error has occured
>>>>/ S Error Summary
>>>>/ S 1 x -7500 message not available
>>>>/ *
>>>>/ M STOP 20020118 00235311
>>>>/ *
>>>>/ M RC = 7 Some SQL error has occured
>>>>/ *
>>>>*** Fri Jan 18 23:53:12 2002
>>>>sql_connect SUPERDBA,ADMIN
>>>>---
>>>>OK
>>>>*** Fri Jan 18 23:53:12 2002
>>>>sql_execute CREATE USER sapwas PASSWORD SAP DBA NOT EXCLUSIVE
>>>>---
>>>>OK
>>>>*** Fri Jan 18 23:53:12 2002
>>>>sql_connect sapwas,SAP
>>>>---
>>>>OK
>>>>*** Fri Jan 18 23:53:12 2002
>>>>sql_execute CREATE SEQUENCE DDLOG_SEQ MINVALUE -2147483646 MAXVALUE 2147483646 INCREMENT BY 1 START WITH -2147483646 NOCACHE NOORDER NOCYCLE
>>>>---
>>>>OK
>>>>
>>>>endsnip----------------------------------------------------------
>>>>
>>>>Whats going wrong? Do I have to log in as different user?
>>>>
>>>>regards
>>>>
>>>>christof
>>>>
>>>>"Peter J. A. Bilitch" <peter.bilitch at sap.com> schrieb am 15.01.02:
>>>>
>>>>>Hello Christof,
>>>>>
>>>>>First of all, what linux distribution and kernel versions are you using,
>>>>>and are you certain that your hardware meets the minimum requirements,
>>>>>and that you have performed the pre-install checks run the appropriate
>>>>>pre-install rpms?
>>>>>
>>>>>Regards,
>>>>>
>>>>>Peter
>>>>>
>>>>>christof.fischer at web.de wrote:
>>>>>
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>I just try to install the SAP basis system. Calling rpm -Uvh sapbasis-6.10-1.noarch.rpm aborts after a while with the error:
>>>>>>
>>>>>>database creation failed
>>>>>>see dbclient log file /tmp/createdb.sh.1625.log for the db command trace
>>>>>>execution of sapbasis-6.10-1 script failed, exit status 1
>>>>>>
>>>>>>Here is a snipplet from the log:
>>>>>>
>>>>>>*** Sat Jan 12 20:51:22 2002
>>>>>>util_execute init config
>>>>>>---
>>>>>>OK
>>>>>>*** Sat Jan 12 20:51:25 2002
>>>>>>util_activate SUPERDBA,ADMIN
>>>>>>---
>>>>>>OK
>>>>>>*** Sat Jan 12 20:51:25 2002
>>>>>>util_release
>>>>>>---
>>>>>>OK
>>>>>>*** Sat Jan 12 20:51:28 2002
>>>>>>load_systab -u SUPERDBA,ADMIN -ud DOMAIN
>>>>>>---
>>>>>>ERR
>>>>>>-24964,ERR_
>>>>>>
>>>>EXECUTE: error in program execution
>>>>
>>>>>>1792,/opt/sapdb/depend/bin/xload -S INTERNAL -n ikarus -d WAS -u SUPERDBA,* -b /opt/sapdb/depend/env/lsystab.ins en ENG DOMAIN
>>>>>>Some SQL error has occured
>>>>>>/ S Error Summary
>>>>>>/ S 1 x -7500 message not available
>>>>>>/ *
>>>>>>/ M STOP 20020112 00205128
>>>>>>/ *
>>>>>>/ M RC = 7 Some SQL error has occured
>>>>>>/ *
>>>>>>*** Sat Jan 12 20:51:28 2002
>>>>>>sql_connect SUPERDBA,ADMIN
>>>>>>---
>>>>>>OK
>>>>>>*** Sat Jan 12 20:51:28 2002
>>>>>>sql_execute CREATE USER sapwas PASSWORD SAP DBA NOT EXCLUSIVE
>>>>>>---
>>>>>>OK
>>>>>>*** Sat Jan 12 20:51:28 2002
>>>>>>sql_connect sapwas,SAP
>>>>>>---
>>>>>>OK
>>>>>>*** Sat Jan 12 20:51:28 2002
>>>>>>sql_execute CREATE SEQUENCE DDLOG_SEQ MINVALUE -2147483646 MAXVALUE 2147483646 INCREMENT BY 1 START WITH -2147483646 NOCACHE NOORDER NOCYCLE
>>>>>>---
>>>>>>OK
>>>>>>
>>>>>>Whats wrong? Is it a problem of the package or of a wrong configuration on my side????
>>>>>>
>>>>>>christof
>>>>>>
>>>>>>______________________________________________________________________________
>>>>>>Eine Klasse für sich - der WEB.DE Club. High End Kommunikation & MEHR.
>>>>>>Mehr Speicher, mehr Leistung, mehr Vorteile - http://club.web.de
>>>>>>
>>>>>>____________________
>>>>>>
>>>>>>To unsubscribe from this list: send the line "unsubscribe linux-general"
>>>>>>in the body of a message to listserver at sap.com
>>>>>>
>>>>>____________________
>>>>>
>>>>>To unsubscribe from this list: send the line "unsubscribe linux-general"
>>>>>in the body of a message to listserver at sap.com
>>>>>
>>>>>
>>>>______________________________________________________________________________
>>>>Darf es ein bisschen mehr sein? Mehr Speicher, mehr Mail, mehr Erlebnis,
>>>>mehr Prämie, mehr WEB.DE. Der WEB.DE Club - http://club.web.de
>>>>
>>>>____________________
>>>>
>>>>To unsubscribe from this list: send the line "unsubscribe linux-general"
>>>>in the body of a message to listserver at sap.com
>>>>
>>>____________________
>>>
>>>To unsubscribe from this list: send the line "unsubscribe linux-general"
>>>in the body of a message to listserver at sap.com
>>>
>>>
>>________________________________________________________________
>>Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr!
>>Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
>>
>>____________________
>>
>>To unsubscribe from this list: send the line "unsubscribe linux-general"
>>in the body of a message to listserver at sap.com
>>
>
> ____________________
>
> To unsubscribe from this list: send the line "unsubscribe linux-general"
> in the body of a message to listserver at sap.com
>
>
>
--
-----------------------
christof fischer
ferdinand-kopf-str. 9
79117 freiburg
0761/6965911
-----------------------
____________________
To unsubscribe from this list: send the line "unsubscribe linux-general"
in the body of a message to listserver at sap.com
More information about the linux.general
mailing list