Amazon books

Thursday, November 11, 2010

ORA-23616: Failure in executing block 4 for script dbms_streams_adm

Error:

###########################################
ORA-23616: Failure in executing block 4 for script 94CDB67BB22F03BFE0400A0A710A1FF7 with
ORA-26723: user "DBMS_STR_USER" requires the role "DBA"
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2422
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2975
###########################################

Find more info using view below:

SQL> select * from dba_recoverable_script_errors;

SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIME
-------------------------------- ---------- ------------ -------------------------------------------------------------------------------- -------------------
94CDA13FFD84CDE6E0400A0A710A1D8F 4 -26723 ORA-26723: user "DBMS_STR_USER" requires the role "DBA" 11/11/2010 19:31:16


################

Grant DBA to user.

test again.

Best Regards,
Paulo Portugal

Saturday, November 6, 2010

EXPDP ORA-39002 ORA-39070 ORA-29283 ORA-06512 ORA-29283 LOGFILE

If experiencing this error below when trying to export using EXPDP:

############################################
[oraebs@hom1 bkp_old_hml]$ expdp system/xxxxxxx dumpfile=expdir:exp_hml_%U.dmp filesize=3G logfile=log_exp_hml.log FULL=Y

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 06 November, 2010 16:42:42

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation
############################################

Just change the sintaxe to use the directory name together in LOGFILE parameter as below:

expdp system/xxxxxx directory=expdir dumpfile=expdir:exp_hml_%U.dmp filesize=3G logfile=expdir:log_exp_hml.log FULL=Y



Best Regards,
Paulo Portugal

Friday, November 5, 2010

Apache Web Server Listener is not running adstrtal.sh adapcctl.sh

While trying to start apache after a clone the error below appears:

###############
adapcctl status

Apache Web Server Listener is not running
Apache Web Server Listener (PLSQL) :httpd ( pid 2669 ) is running.

###############
Do this:

cd $IAS_ORACLE_HOME/bin
adlnkiAS.sh
cd $COMMON_TOP/admin/scripts/SID_Hostname
adapcctl.sh start

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


Best Regards,
Paulo Portugal