OraFAQ Forum: Unix » Oracle 10g in Solaris

Home » Infrastructure » Unix » Oracle 10g in Solaris

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10g in Solaris [message #183349]

Thu, 20 July 2006 08:25

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...

Report message to a moderator

Re: Oracle 10g in Solaris [message #183352 is a reply to message #183349]

Thu, 20 July 2006 08:31

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: Oracle 10g in Solaris [message #183353 is a reply to message #183352]

Thu, 20 July 2006 08:36

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??

Report message to a moderator

Re: Oracle 10g in Solaris [message #183356 is a reply to message #183353]

Thu, 20 July 2006 08:45

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Oracle 10g in Solaris [message #183433 is a reply to message #183356]

Thu, 20 July 2006 22:17

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?

Report message to a moderator

Re: Oracle 10g in Solaris [message #183538 is a reply to message #183433]

Fri, 21 July 2006 04:44

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Previous Topic:	Need help with Unix ksh exp/imp script
Next Topic:	backing up and restoring solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:05:07 CDT 2024