Home » RDBMS Server » Server Administration » database failure (oracle 10g)
database failure [message #399077] Mon, 20 April 2009 08:07 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi i did like this

SHOW PARAMETER AUDIT
ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;

System altered.

SQL> SHUTDOWN
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1248600 bytes
Variable Size              71303848 bytes
Database Buffers          213909504 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.

CONNECT sys/password AS SYSDBA
SQL> conn sys/sys as sysdba;
Connected to an idle instance.
SQL> CREATE USER audit_test IDENTIFIED BY audit_test1
  2    DEFAULT TABLESPACE users
  3    TEMPORARY TABLESPACE temp
  4    QUOTA UNLIMITED ON users;
CREATE USER audit_test IDENTIFIED BY audit_test1
*
ERROR at line 1:
ORA-01012: not logged on


SQL> shutdown
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted
SQL> startup
ORA-01031: insufficient privileges
SQL> conn sys/sys as sysdba;
Connected to an idle instance.
SQL> CREATE USER audit_test IDENTIFIED BY audit_test1
  2    DEFAULT TABLESPACE users
  3    TEMPORARY TABLESPACE temp
  4    QUOTA UNLIMITED ON users;
CREATE USER audit_test IDENTIFIED BY audit_test1
*
ERROR at line 1:
ORA-01012: not logged on


SQL> shutdown
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted
SQL> startup
ORA-01031: insufficient privileges
SQL> 
can anyone help me why its happening like this
Re: database failure [message #399078 is a reply to message #399077] Mon, 20 April 2009 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First check alert.log and Oracle processes to know in which state your instance is in.

Regards
Michel
Re: database failure [message #399079 is a reply to message #399078] Mon, 20 April 2009 08:13 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
where exactly we can find that
Re: database failure [message #399080 is a reply to message #399079] Mon, 20 April 2009 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
find / -name 'alert*log' -ls

Regards
Michel
Re: database failure [message #399081 is a reply to message #399080] Mon, 20 April 2009 08:19 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
Michel,

this i am doing in windows oracle sql*plus.actullay i am trying for auditing concepts and this happend.
Re: database failure [message #399083 is a reply to message #399080] Mon, 20 April 2009 08:22 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What it looks like to me is that at the start of the script you are connected to a database other than the one in the environment variable ORACLE_SID (if you're on Unix).

You shutdown and restart that database successfully.

You then connect as sysdba, and get the message 'Connected to an Idle Instance' - I really don't think that this is the same database that you were connected to before.
Re: database failure [message #399085 is a reply to message #399083] Mon, 20 April 2009 08:29 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
yeah for me in system/manager@orcl i am connecting giving
error message like
ora 12528:tns listner :all appropriate instances are blocking new connections.but for me
system/manager@orcl is working
Re: database failure [message #399088 is a reply to message #399085] Mon, 20 April 2009 08:40 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
how can i overcome this nothing i am able to perform on this.
initially i have logged into system/manager@orcl1
ther i have performed all this.
Re: database failure [message #399090 is a reply to message #399077] Mon, 20 April 2009 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how can i overcome this nothing i am able to perform on this.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

Re: database failure [message #399096 is a reply to message #399088] Mon, 20 April 2009 09:34 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
if your database is shut down, and you're using dynamic registration, then the only way you can connect to it is to set the ORACLE_SID and connect as Sysdba.
Re: database failure [message #399118 is a reply to message #399096] Mon, 20 April 2009 13:43 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

SQL> shutdown
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted


http://babudba.blogspot.com/2008/02/ora-24324-ora-24323.html
Re: database failure [message #399119 is a reply to message #399077] Mon, 20 April 2009 13:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> shutdown abort
Previous Topic: drop a single datafile
Next Topic: not able to drop table space (merged)
Goto Forum:
  


Current Time: Tue Jul 02 23:53:14 CDT 2024