Database not available

[Former Member]

Hi,

I am getting the error message while starting startsap. Could you please provide the solution how it can be fixed.

My of OS is Solaris.

sapcebiw:BIPadm 5% cat /home/BIPadm/startdb.log

-

---

Tue May 1 00:39:40 IST 2007

LOGFILE FOR STARTING ORACLE

Trying to start BIP database ...

-

---

Tue May 1 00:39:40 IST 2007

checking required environment variables

ORACLE_HOME is >/oracle/BIP/102_64<

ORACLE_SID is >BIP<

-

---

Tue May 1 00:39:40 IST 2007

check initora

-

---

Tue May 1 00:39:40 IST 2007

check initora

-

---

Tue May 1 00:39:40 IST 2007

checking V2 connect

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 01-MAY-2007 00:

39:40

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/usr/sap/BIP/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

.WORLD) (PROTOCOL = TCP) (HOST = sapcebiw) (PORT = 1527))) (CONNECT_DATA = (SID

= BIP) (GLOBAL_NAME = BIP.WORLD)))

OK (0 msec)

tnsping: V2 connect to BIP

-

---

Tue May 1 00:39:40 IST 2007

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Tue May 1 00:39:40 IST 2007

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Tue May 1 00:39:40 IST 2007

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 1 00:39:40 2007

REgards

Sreejesh

[Former Member]

After reebooting database is up.

[former_member204746]

another infamous shared memory issue...

reboot solved the problem but you could also have closed all SAP and Oracle processes and clear your shared memory.

[Former Member]

I tried to start the database its giving the error message

SQL> startup

ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

I changed init<SID>.ora

parameter.

but still the problem coming..

Regards

Sreejesh

[andreas_herzog]

-> which init parameter did you change?

-> how big is your defined sga?

-> how much memory does the machine have?

GreetZ, AH

[former_member618758]

Hi,

This means your database is not up or sap has problem connecting to it?

Are you able to connect via sql*plus? If not you might want to bounce the db as ora<sid> , make sure oracle start up ok, than try R3trans -d as <sid>adm, should get a return code 000, than you can start sap.

Thanks,

George