"Oracle Case" ORA-01722

1.1. ORA-01722

Date: 2014-06-05 14:09

Environment: Test environment

"Scenario description"

During the upgrade of the database, the execution of the Sql> @?/rdbms/admin/catupgrd.sql script encountered an error exiting.

"Error Message"

doc>#######################################################################

Doc> The following statement would cause an "ora-01722:invalidnumber"

Doc> error if the Oracle Database Vault option is TRUE. Upgrades cannot

Doc> is run with the Oracle Database Vault option set to TRUE since

Doc> as SYSDBA connections is restricted.

Doc>

Doc> Perform "ALTER SYSTEM CHECKPOINT" prior to "Shutdownabort", relink

Doc> the server without the Database Vault option, and restart the server

Doc> using UPGRADE mode.

Doc>

Doc>

doc>#######################################################################

doc>#######################################################################

doc>#

SELECT to_number (' data_vault_option_on ') from V$option

*

ERROR at line 1:

Ora-01722:invalid number

"Cause of error"

The DB instance is configured with the Oracle Database Vault feature.

"Workaround"

After you close the Oracle Database Vault feature, re-perform the upgrade operation.

To turn off Oracle Database Vault Features:

# See if the Oracledatabase Vault feature is turned on:

sql> col parameter for A30

Sql> col value for A20

Sql> SELECT * from v$option whereparameter = ' Oracle Database Vault ';

PARAMETER VALUE

--------------------------------------------------

Oracle Database Vault TRUE

# Close DB Instance

sql> shutdown Immediate

Sql> exit

$ emctl Stop Dbconsole

$ lsnrctl Stop

# Compile Ins_rdbms.mk

[Email protected] ~]$ CD $ORACLE _home/rdbms/lib/

[Email protected] lib]$ make-f Ins_rdbms.mkdv_off

/usr/bin/ar d/u01/app/oracle/product/11.2.3/db_1/rdbms/lib/libknlopt.a KZVIDV.O

/usr/bin/ar cr/u01/app/oracle/product/11.2.3/db_1/rdbms/lib/libknlopt.a/u01/app/oracle/product/11.2.3/db_1/ rdbms/lib/kzvndv.o

[Email protected] lib]$

# Execute Relink

[Email protected] lib]$ CD $ORACLE _home/bin

[Email protected] bin]$ relink All

Writing relink Log To:/u01/app/oracle/product/11.2.3/db_1/install/relink.log

[Email protected] bin]$

# Launch DB instance

$ sqlplus/as SYSDBA

Sql> Startup

# Check Oracle databasevault status

Sql> SELECT * from v$option WHERE parameter= ' Oracle Database Vault ';

PARAMETER VALUE

------------------------------ ----------

Oracle Database Vault FALSE

Sql>

Resources

Close/Open Oracle Database Vault:

http://docs.oracle.com/cd/B28359_01/server.111/b31222/dvdisabl.htm#DVADM70984

To install Oracle Database Vault:

Http://www.stanford.edu/dept/itss/docs/oracle/10gR2/install.102/b32496/upgrd.htm

What is Oralce Database Vault:

Oracledatabase Vault helps users address the most difficult security issues available, namely, preventing internal threats, meeting compliance requirements, and implementing segregation of duties. Oracle Database Vault prevents DBAs from viewing application data and addresses the most worrying issues for customers who must protect sensitive business information or privacy data that involves partners, employees, and customers. Oracle Database Vault prevents high-privileged application DBAs from accessing other applications and performing tasks other than their permissions. Oracle Database Vault can easily and quickly protect existing applications without compromising the functionality of the application.