Autoconfig failed during setup phase:
While running the script adgendbc.sh
Unable to update GUEST_USER_PWD in database to GUEST/ORACLE1 -
java.sql.SQLException: ORA-06550: line 1, column 323:
PLS-00201: identifier 'FND_VAULT.PUT' must be declared
ORA-06550: line 1, column 323:
PL/SQL: Statement ignored
Cause
AdminAppServer.java 115.32 calls fnd_app_server_pkg.update_server passing 5 parameters.
The versions of FND_APP_SERVER_PKG (AFSCASRS.pls/AFSCASRB.pls) accepts 5 parameters.
These version used in the database is older than the version at OS filesystem level.
Solution
1. Run following SQL query :
select text
from all_source
where name ='FND_APP_SERVER_PKG' and line < 7;
2. If the versions in the database are older than the ones at the OS level, go to the
$FND_TOP/patch/115/sql directory and recreate the spec/body by running :
- sqlplus apps/<passwd> @AFSCASRS.pls
- sqlplus apps/<passwd> @AFSCASRB.pls
3. Rerun Autoconfig.
While running the script adgendbc.sh
Unable to update GUEST_USER_PWD in database to GUEST/ORACLE1 -
java.sql.SQLException: ORA-06550: line 1, column 323:
PLS-00201: identifier 'FND_VAULT.PUT' must be declared
ORA-06550: line 1, column 323:
PL/SQL: Statement ignored
Cause
AdminAppServer.java 115.32 calls fnd_app_server_pkg.update_server passing 5 parameters.
The versions of FND_APP_SERVER_PKG (AFSCASRS.pls/AFSCASRB.pls) accepts 5 parameters.
These version used in the database is older than the version at OS filesystem level.
Solution
1. Run following SQL query :
select text
from all_source
where name ='FND_APP_SERVER_PKG' and line < 7;
2. If the versions in the database are older than the ones at the OS level, go to the
$FND_TOP/patch/115/sql directory and recreate the spec/body by running :
- sqlplus apps/<passwd> @AFSCASRS.pls
- sqlplus apps/<passwd> @AFSCASRB.pls
3. Rerun Autoconfig.
In this regard, Database Performance Management System could allow the upgrade to be performed in a much easier manner, simultaneously ensuring that the existing activities related to the system database aren't much affected in the upgrade process.dbdesigner.net
ReplyDelete