R12.2 Upgrade: Rapidwiz Prerequisite Check Fails With Message: DB Version Check Has Failed. Not able to check the Database version. Please make sure the Database is at 11.2.0.3 or higher
Solution:
To resolve the database connectivity issue, perform the following steps :
1. Review the sqlnet_ifile.ora or sqlnet.ora file and confirm the following entries are present:
SQLNET.ALLOWED_LOGON_VERSION_SERVER
2. Update the sqlnet_ifile.ora or sqlnet.ora settings for the above parameters to the lowest version level
that is required in your environment.
For example:
a) If the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE:
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
b) If SEC_CASE_SENSITIVE_LOGON is set to TRUE
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10
After this Database connectivity issue should be resolved.
Modify the service_names parameter to include ebs_patch as shown below and retry.
SQL> sho parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string ORCL
SQL> alter system set service_names='ORCL','ebs_patch' scope=both ;
System altered.
SQL> sho parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string ORCL, ebs_patch
No comments:
Post a Comment