oracle startup and shutdown procedure

[Former Member]

hi,

can u explain oracle startup and shutdown procedure in sap r/3

thanks in advance...

[Former Member]

This message was moderated.

[Former Member]

As explained above oracle startup or shutdown is no different with or without SAP.

[former_member395192]

I think, for some sap basis admins was interesting that sap note by theme

491174 Composite SAP note for ORA-01034

In that note very interesting explanation of oracle startup

[Former Member]

Hi

<u><b>Startup Procedure</b></u>

To start the database, start BRTOOLS or BRGUI and select Instance

management &#8594; Start up database. To start the database in batch, use

brspace -c force -f dbstart -s <state>.

State can be Nomount, Mount or Open.

Note: If the database is in any other state than shut down when

starting the database with BRSPACE, the startup will fail unless

you specify the option -f|-force to the dbstart function. In this

case, the database will be shut down before starting it up into the

requested state.

<b><u>Shutdown Procedure</u></b>

To stop the database, start BRTOOLS or BRGUI and select Instance

management &#8594; Shut down database. To stop the database in batch, use

brspace -c force -f dbshut -m <mode>.

Mode can be Normal, Transactional, Immediate or Abort.

This should clear your doubt.

Regards

Sumit Jain

[Former Member]

Hi,

When you start SAP using command "startsap", database is also started if not already running.

The detailed log for database starting could be found in the file

"/local/users/<SID>adm/startdb.log"

Similarly when you stop SAP using command "stopsap", it would stop the database also. The log file would be:

"/local/users/<SID>adm/stopdb.log"

How oracle database is started?

First oracle instance is started ie. the oracle memory areas. -> database nomount state.

Then, control file is read and all the db structure is establised and the oracle instance is associated with the database -> database mount state

Finally, database is open for user operations -> database open state.

Hope this helps.

Best Regards,

Sandeep.

[andreas_herzog]

hmm..i'm not sure if i understand your question...

the oracle startup/shutdown procedure is the same with or without sap r/3...oracle starts up, reading its init file, allocats memory and initiates some processes (db writer, log writer, sysmon etc.)...after the startup is complete the sap work procesess can connect to the oracle server processes...in case of a shutdown the sap work processes disconnect and the database will be shutdown..

GreetZ, AH