Solaris

Hi All,
O/S: Solaris 5.10
Software installed :-
Oracle 10G
Weblogic 10.30

the problem i face that
when the server restart for any reason

Code:

SQL> exit
bash-3.00# sqlplus sys/manchester as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 2 11:04:50 2010

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

Connected to an idle instance.

SQL> show user
USER is "SYS"
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01034: ORACLE not available

i should run startup sql command to start Oracle database

and the same thing for weblogic server

what i want to make is to put startup script
to start oracle and weblogic server when the server restart

You can put the database startup Script in /etc/rc3.d directory:

1)The script name should start from "S" (capital s)
2)Followed by some number say "91"
3)Followed by script name "database_startup_script"

So, here is the complete name of the script in /etc/rc3.d directory : /etc/rc3.d/S91database_startup_script

Every time when server reboots and come to Run Level-3, it will execute the script "/etc/rc3.d/S91database_startup_script" and automatically start the database...

You just need to put your contents in this file, assigning proper permisions.

What you need to do is ask your Oracle support and your WebLogic support for SMF scripts.

how about checking the SMF for available but disabled startup files?

Code:

scvs -a | grep -i oracle