Home » RDBMS Server » Server Administration » need help in 10g database (oracle 10g database)
need help in 10g database [message #386684] Mon, 16 February 2009 11:00 Go to next message
afsardba
Messages: 6
Registered: February 2009
Junior Member
Hi, All

I recently installed oracle 10g in my laptop and i am facing following problems if any one can help me:

1) when i want to shutdown the database from browser its show wrong password, i already create administrator account with the password which have ora_dba role also using sys user with sysdba
my and system has static ip.

2) when i try to shutdown from sqlpluw/sqlplu both not responding .

except above all running normal.

i will be thank full if any one can help me in this regard.


thanks

Afsar Qamar

Report message to a moderator

Re: need help in 10g database [message #386688 is a reply to message #386684] Mon, 16 February 2009 11:41 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Yes; We can help you; But requesting to you Please post your exact error message;

Post alert log.

Babu

Report message to a moderator

Re: need help in 10g database [message #386777 is a reply to message #386684] Tue, 17 February 2009 00:08 Go to previous messageGo to next message
afsardba
Messages: 6
Registered: February 2009
Junior Member
this is exact error and piece from my alert log file ..

thanks

afsar

Report message to a moderator

Re: need help in 10g database [message #386929 is a reply to message #386777] Tue, 17 February 2009 05:23 Go to previous messageGo to next message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member
Looks like you'v shut the database down "normally".

Issue a "shutdown immediate" instead ... if it's really bad then "shutdown abort" will do it.

Dont abort the instance unless you really need to tho.


Adam

Report message to a moderator

Re: need help in 10g database [message #387009 is a reply to message #386929] Tue, 17 February 2009 10:12 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>Issue a "shutdown immediate" instead ... if it's really bad then "shutdown abort" will do it.

Can you confirm me; AS per attachment; Where your found above details.???


@afsardba


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Why your NOT posting alert log information???

Babu

Report message to a moderator

Re: need help in 10g database [message #387015 is a reply to message #387009] Tue, 17 February 2009 10:27 Go to previous messageGo to next message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member

"SHUTDOWN: waiting for logins to complete."

This is slightly different from the messages I am used to seeing in a Unix environment ...

But it means the same ... Oracle is still waiting for active sessions to complete.

Report message to a moderator

Re: need help in 10g database [message #387017 is a reply to message #386684] Tue, 17 February 2009 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Report message to a moderator

Re: need help in 10g database [message #387040 is a reply to message #386684] Tue, 17 February 2009 12:37 Go to previous message
afsardba
Messages: 6
Registered: February 2009
Junior Member
Thanks for all who give advise about shutdowm immediate
yes
it works in sqlplusw session but whenever i tried through browser it display error : worng operating system users's password.

and whenever i try to shutdown normal through sqlpusw the session hang and not responding.


thanks


Afsar

Report message to a moderator

Previous Topic: Objecttype ' JOB' (merged)
Next Topic: library cache
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 06:12:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.