Home » RDBMS Server » Server Administration » Error ORA-47306 causing error for Checkpoint (Oracle 11.2.0.4 on Linux)
Error ORA-47306 causing error for Checkpoint [message #643070] Mon, 28 September 2015 06:02 Go to next message
orapratap
Messages: 134
Registered: November 2011
Location: Canada
Senior Member
Hello

We are getting "ORA-47306" for following which thus is completing the checkpoint

Not getting much information on "ORA-47306" for Oracle 11.2, on Metalink too

Any directions please?

SQL> alter system checkpoint;
alter system checkpoint
*
ERROR at line 1:
ORA-47306: 4067:


SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-47306: 4067:


SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-47306: 4067:


Thanks and Regards
Orapratap
Re: Error ORA-47306 causing error for Checkpoint [message #643071 is a reply to message #643070] Mon, 28 September 2015 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Is this a DB Vault install?

Re: Error ORA-47306 causing error for Checkpoint [message #643073 is a reply to message #643071] Mon, 28 September 2015 06:33 Go to previous messageGo to next message
orapratap
Messages: 134
Registered: November 2011
Location: Canada
Senior Member
Many Thanks Michel

Yes, looks like Vault is enabled on the database


SQL> SELECT comp_name, version, status FROM dba_registry;

COMP_NAME                                          VERSION                        STATUS
-------------------------------------------------- ------------------------------ --------------------------------------------
Oracle Database Vault                              11.2.0.4.0                     VALID
Oracle XML Database                                11.2.0.4.0                     INVALID
Oracle Label Security                              11.2.0.4.0                     VALID
Oracle Database Catalog Views                      11.2.0.4.0                     VALID
Oracle Database Packages and Types                 11.2.0.4.0                     VALID

SQL> select * from v$option where parameter ='Oracle Database Vault';

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Oracle Database Vault                                            TRUE



Of course we are Not using the Vault functionality

In that case shall I disable the vault using 'make' command?

Thanks and Regards
Orapratap
Re: Error ORA-47306 causing error for Checkpoint [message #643077 is a reply to message #643073] Mon, 28 September 2015 09:27 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes, I think I remember you have an option dvon/dvoff or something like that.
Have a look at the DB Vault documentation or MOS, it is explained there.

Previous Topic: PGA memory allocation
Next Topic: query of 'dba_free_space' is too slow??!!
Goto Forum:
  


Current Time: Thu Mar 28 05:04:55 CDT 2024