Home » Infrastructure » Unix » Oracle 10g in Solaris
Oracle 10g in Solaris [message #183349] Thu, 20 July 2006 08:25 Go to next message
just_a_kid
Messages: 16
Registered: December 2005
Junior Member
Hi Guys , i was wondering how to start oracle database in correct way in Solaris

Because i had a problem with it..
i start the Oracle 10 in Solaris ,
the database is up. then after few hours, it shut down / the database is down for no reason then i have to start again
I was wondering whether there is a timeout? if there is how do i check it?

below as my step to start the database.
1. go to Oracle_HOME/bin
2. type lsnrctl start
3. sqlplus /nolog
4. connect username/password as sysdba
5. startup

after step 5, it shows no error and the database is ready.
i can connect using sql plus and toad from other computer.

But after few hours , it shutdown for no reason again..
anyone can help me?

is there any better way to start the database??
can i use nohup command in solaris to start oracle? how to do that?


Thanks...



Re: Oracle 10g in Solaris [message #183352 is a reply to message #183349] Thu, 20 July 2006 08:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I would check the alert_sid.log file.
look into to $ORACLE_BASE/admin/< your sid >/bdump/alert_yoursid.log
Re: Oracle 10g in Solaris [message #183353 is a reply to message #183352] Thu, 20 July 2006 08:36 Go to previous messageGo to next message
just_a_kid
Messages: 16
Registered: December 2005
Junior Member
okay thanks ,

i will check..

But is my way of starting the database is correct??
i heard u can use ./dbstart script to start the database??


u know why after the database is down , my web application will gone crash ...
after my database is up again .. my web application still go crash giving me "java.sql.SQLException : IOException : Broken Pipe "

Everytime i have to restart the web server after my database is up again..

how do i solve it??
Re: Oracle 10g in Solaris [message #183356 is a reply to message #183353] Thu, 20 July 2006 08:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>u know why after the database is down , my web application will gone crash ...
Without even looking into any logfiles/useful information, i have to guess. Ofcourse, when your database crashes, connected session from webapp will crash too!.
>>But is my way of starting the database is correct??
>>i heard u can use ./dbstart script to start the database?
seems so.
dbstart/dbshut will do the same ( well, almost).
Just edit your oratab file and make proper entries.
dbstart/dbshut will not take care of listener services.
So edit dbstart and add lsnrctl start or do it seperately.

Re: Oracle 10g in Solaris [message #183433 is a reply to message #183356] Thu, 20 July 2006 22:17 Go to previous messageGo to next message
just_a_kid
Messages: 16
Registered: December 2005
Junior Member
Hi ,

Now the database seems okay
it has gone through overnight and still up..

i was wondering whether the client application can crash database server??
lets say if too many load??

i think the reason for "java.io.Exception : Broken Pipe"
just after database is up
is because when the database is up.. i store many connections in a pool using hashTable
then the database is down..so JDBC call is also crash..
then i start the database again.
But all the connection in the hashtable has been lost thats why it throws BROKEN PIPE Exception??
The only way to fix it to clear the hashtable or restart the web application.

Any Suggestion?
Re: Oracle 10g in Solaris [message #183538 is a reply to message #183433] Fri, 21 July 2006 04:44 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:

i was wondering whether the client application can crash database server??
lets say if too many load??


We can assume anything. You have not provided any details that would be useful for me and i have an unintelligible knowledge in Java.
A quick google search is very promising.
http://www.google.com/search?complete=1&hl=en&lr=&q=%22java.io.Exception+%3A+Broken+Pipe%22+%2B+Oracle&btnG=Search
Previous Topic: Need help with Unix ksh exp/imp script
Next Topic: backing up and restoring solaris
Goto Forum:
  


Current Time: Thu Dec 03 17:43:10 CST 2020