Hi,
it looks like your configuration is wrong:

param_rmfile
param_startsession
param_init OLTP
param_put LOG_MODE SINGLE
param_put CAT_CACHE_SUPPLY 300
param_put CACHE_SIZE 3000
param_put MAXDATADEVSPACES 5
param_checkall
param_commitsession

param_addvolume 1 DATA $HOME/$SID/DISKD0001 F 1024  <============= :(

param_addvolume 1 LOG  $HOME/$SID/DISKL001  F 1024
quit

The capacity of all your data devspaces/volumes should be at least 2001
pages!


Regards,
Torsten

SAP DB, SAP Labs Berlin



-----Original Message-----
From: Tanu Shankar Bhatnagar [mailto:[EMAIL PROTECTED]]
Sent: Mittwoch, 12. Februar 2003 04:48
To: [EMAIL PROTECTED]
Subject: error creating db


I am trying to create an instance by modifying the script for creating the
TST74 instance. The things I have changed in the script are the SID and
the HOME. The HOME points to  /opt/sapdb/data, to which sapdb.sapdb has
all the required permissions. I am creating this database as sapdb.sapdb.
This is the error I am getting:

[sapdb@klpd picu]$ sh create_picu_db.sh
create database PICU...
set parameters for PICU...
start PICU...
initialize PICU...
initializing PICU failed: dbmcli on PICU>OK

---
dbmcli on PICU>ERR
-24988,ERR_SQL: sql error
-8888,connection broken

---
dbmcli on PICU>ERR
-24992,ERR_NOUTILSESSION: no utility session available

---
dbmcli on PICU>
---

I have attached the script for reference. I have tried creating this
instance through the dbmgui, but I get the same 8888 exception. 

I do the following from the cli then:
[sapdb@klpd picu]$ dbmcli -d PICU -u dbm,dbm db_state
OK
State
OFFLINE
[sapdb@klpd picu]$
[sapdb@klpd picu]$
[sapdb@klpd picu]$ dbmcli -d PICU -u dbm,dbm db_warm
ERR
-24988,ERR_SQL: sql error
-8888,connection broken

Still the same thing! I have attached the script for reference. Please
advise if there is something wrong with the script or potentially with my
configuration. 

Thanks,
Tanu

=====
TANU SHANKAR BHATNAGAR
Phone: 703 448 0480
--------
2251 Pimmit Drive, #1418
Falls Church, VA - 22043

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to