EM 12cR5 Cloud Control

来源：互联网发布：怀化学院网络管理系统编辑：程序博客网时间：2024/06/06 06:42

Navigate: Targets > Databases > [select target instance] > [Performance pull down menu] > Ash Analytics

Deploying the ASH Analytic package in EM 12c Cloud Control fails with this error:

Error while executing the script : oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Error creating PL/SQL Object PRVT_AWR_DATA : PACKAGE BODY - PLS-00201: identifier 'DBSNMP.ASHVIEWER' must be declared
Error creating PL/SQL Object PRVT_AWR_DATA : PACKAGE BODY - PL/SQL: Statement ignored
at line number - 2580
Driver SQL Script encountered errors.

There are two available workarounds:
1. Use SYS to Deploy the ASH Analytic package instead of the DBSNMP user.
or
2. Grant the DBA role to the DBSNMP User.

/u01/app/oracle/product/Middleware/plugins/oracle.sysman.db.oms.plugin_12.1.0.8.0/sql/db/latest/instance/prvs_awr_data.sql
# ll
total 388
-rw-r--r-- 1 oracle oinstall 150978 Apr 17 19:12 ashviewer_pkgbodys.sql
-rw-r--r-- 1 oracle oinstall 9155 Apr 17 19:12 ashviewer_pkgdefs.sql
-rw-r--r-- 1 oracle oinstall 2042 Apr 17 19:12 dbms_compare_period.sql
-rw-r--r-- 1 oracle oinstall 30302 Apr 17 19:12 eaddm_pkgbody.sql
-rw-r--r-- 1 oracle oinstall 1116 Apr 17 19:12 eaddm_pkgdef.sql
-rw-r--r-- 1 oracle oinstall 2284 Apr 17 19:12 prvs_awr_data_cp.sql
-rw-r--r-- 1 oracle oinstall 7318 Apr 17 19:12 prvs_awr_data.sql
-rw-r--r-- 1 oracle oinstall 19982 Apr 17 19:12 prvt_awr_data_cp.sql
-rw-r--r-- 1 oracle oinstall 110401 Apr 17 19:12 prvt_awr_data.sql
-rw-r--r-- 1 oracle oinstall 40905 Apr 17 19:12 prvt_compare_period.sql
-rw-r--r-- 1 oracle oinstall 2253 Apr 17 19:12 README.txt
-rw-r--r-- 1 oracle oinstall 981 Apr 17 19:12 test.sql

Sun Sep 18 15:00:01 2016
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1

This issue is fixed in 11.2.0.4.
For versions below 11.1.0.7 apply the patch 6282324.Bug 6282324 is fixed in 11.1.0.7 .
For 11.2.0.2 and 11.2.0.3, please apply Patch 10110625 (if available for your platform and database version).
As a workaround, the DBSNMP user can be dropped and re-created using the standard scripts.
Ensure you have Backed up your database.
-- Login as sys user.
SQL> sqlplus / as sysdba
-- From the sqlplus execute the following:
-- Drop the DBSNMP user by executing catnsnmp.sql script.
SQL> @$ORACLE_HOME/rdbms/admin/catnsnmp.sql
-- Create the DBSNMP user by executing catsnmp.sql

SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql

INFO: 4/17/17 6:48:09 PM CST: The output of this make operation is also available at: '/u01/app/oracle/product/Middleware/oms/install/make.log'

INFO: 4/17/17 6:48:09 PM CST:

INFO: 4/17/17 6:48:09 PM CST: Start output from spawned process:

INFO: 4/17/17 6:48:09 PM CST: ----------------------------------

INFO: 4/17/17 6:48:09 PM CST:

INFO: 4/17/17 6:48:09 PM CST: mkdir -p /u01/app/oracle/product/Middleware/oms/sqlplus/bin

cp -f /u01/app/oracle/product/Middleware/oms/lib/libsqlplus.so \

/u01/app/oracle/product/Middleware/oms/sqlplus/lib/libsqlplus.so

Linking /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus

rm -f /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus

gcc -o /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus -L/u01/app/oracle/product/Middleware/oms/sqlplus/lib/ -L/u01/app/oracle/product/Middleware/oms/lib/ -L/u01/app/oracle/prod

INFO: 4/17/17 6:48:09 PM CST: uct/Middleware/oms/lib/stubs/ /u01/app/oracle/product/Middleware/oms/sqlplus/lib/s0afimai.o -lsqlplus -lclntsh `cat /u01/app/oracle/product/Middleware/oms/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/Middleware/oms/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11

INFO: 4/17/17 6:48:09 PM CST: -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/Middleware/oms/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/Middleware/oms/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -

INFO: 4/17/17 6:48:09 PM CST: lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/Middleware/oms/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/Middleware/oms/lib -lm -lpthread `cat /u01/app/oracle/product/Middleware/oms/lib/sysliblist` -ldl -lm -lpthread -L/u01/app/oracle/product/Middleware/oms/lib

INFO: 4/17/17 6:48:09 PM CST: /bin/chmod 755 /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus

INFO: 4/17/17 6:48:09 PM CST: mv -f /u01/app/oracle/product/Middleware/oms/bin/sqlplus /u01/app/oracle/product/Middleware/oms/bin/sqlplusO

mv -f /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus /u01/app/oracle/product/Middleware/oms/bin/sqlplus

/bin/chmod 751 /u01/app/oracle/product/Middleware/oms/bin/sqlplus

rm -f /u01/app/oracle/product/Middleware/oms/sqlplus/lib/libsqlplus.so

rm -rf /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus

make -f /u01/app/oracle/product/Middleware/oms/sqlplus/lib/ins_sqlplus.mk newsqlplus

INFO: 4/17/17 6:48:09 PM CST: LIBDIR=lib32 LDFLAGS='-m32 -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/' HYBRID_SUFFIX=32

make[1]: Entering directory `/u01/app/oracle/product/Middleware/oms/sqlplus/lib'

INFO: 4/17/17 6:48:09 PM CST: Linking /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus32

rm -f /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus32

gcc -m32 -o /u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus32 -L/u01/app/oracle/product/Middleware/oms/sqlplus/lib32/ -L/u01/app/oracle/product/Middleware/oms/lib32/ -L/u01/app/oracle/product/Middleware/oms/lib32/stubs/ /u01/app/oracle/product/Middleware/oms/sqlplus/lib32/s0afimai.o -lsqlplus -lclntsh `cat /u01/app/oracle/product/Middleware/oms/lib32/ldflags`

INFO: 4/17/17 6:48:09 PM CST: -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/Middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/Middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/pr

INFO: 4/17/17 6:48:09 PM CST: oduct/Middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/Middleware/oms/lib32/sysliblist`

INFO: 4/17/17 6:48:09 PM CST: /usr/bin/ld: crt1.o: No such file: No such file or directory

INFO: 4/17/17 6:48:09 PM CST: -Wl,-rpath,/u01/app/oracle/product/Middleware/oms/lib32 -lm -lpthread `cat /u01/app/oracle/product/Middleware/oms/lib32/sysliblist` -ldl -lm -lpthread -L/u01/app/oracle/product/Middleware/oms/lib32

make[1]: Leaving directory `/u01/app/oracle/product/Middleware/oms/sqlplus/lib'

INFO: 4/17/17 6:48:09 PM CST: collect2: ld returned 1 exit status

make[1]: *** [/u01/app/oracle/product/Middleware/oms/sqlplus/bin/sqlplus32] Error 1

make: *** [newsqlplus32] Error 2

INFO: 4/17/17 6:48:09 PM CST: End output from spawned process.

INFO: 4/17/17 6:48:09 PM CST: ----------------------------------

INFO: 4/17/17 6:48:09 PM CST: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'install' of makefile '/u01/app/oracle/product/Middleware/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2017-04-17_06-37-08-PM.log' for details.

Exception Severity: 1

INFO: 4/17/17 6:48:09 PM CST: POPUP WARNING:Error in invoking target 'install' of makefile '/u01/app/oracle/product/Middleware/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2017-04-17_06-37-08-PM.log' for details.

Click "Retry" to try again.

Click "Ignore" to ignore this error and go on.

Click "Cancel" to stop this installation.

[oracle@sq-gridctl1 lib]$ make -f ins_sqlplus.mk install

mkdir -p /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin

cp -f /u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so \

/u01/app/oracle/product/11.2.0/db_1/sqlplus/lib/libsqlplus.so

Linking /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin/sqlplus

rm -f /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin/sqlplus

gcc -o /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin/sqlplus -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0/db_1/sqlplus/lib/ -L/u01/app/oracle/product/11.2.0/db_1/lib/ -L/u01/app/oracle/product/11.2.0/db_1/lib/stubs/ /u01/app/oracle/product/11.2.0/db_1/sqlplus/lib/s0afimai.o -lsqlplus -lclntsh `cat /u01/app/oracle/product/11.2.0/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/db_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/db_1/lib -lm -lpthread `cat /u01/app/oracle/product/11.2.0/db_1/lib/sysliblist` -ldl -lm -lpthread -L/u01/app/oracle/product/11.2.0/db_1/lib

/bin/chmod 755 /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin/sqlplus

rm -f /u01/app/oracle/product/11.2.0/db_1/bin/sqlplus

mv -f /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin/sqlplus /u01/app/oracle/product/11.2.0/db_1/bin/sqlplus

/bin/chmod 751 /u01/app/oracle/product/11.2.0/db_1/bin/sqlplus

rm -f /u01/app/oracle/product/11.2.0/db_1/sqlplus/lib/libsqlplus.so

rm -rf /u01/app/oracle/product/11.2.0/db_1/sqlplus/bin/sqlplus

[oracle@sq-gridctl1 lib]$

0 0