Blog Posts

disable password verify function in oracle

June 19, 2013

ISSUE:You may fail to run some oracle provided sql scripts because of user creation failure. the creation failure is because provided password didnt’ pass verify function. CAUSE:default password provided in oracle script doesn’t satisfy your password verify function in default profile SOLUTION:alter profile default limit password_verify_function null;run the scriptalter profile default limit password_verify_function your-password-verify-function-name ;
Failed to shutdown DBConsole Gracefully

June 19, 2013

Environment:Oracle:Oracle 10g Release 2 10.2.0.5OS:LinuxSummary:Fix Oracle EM problem:Failed to shutdown DBConsole Gracefully Today on a Linux Oracle machine without Oracle Enterprise Manger, I would like to install Oracle EM. Use command emca -config dbcontrol db -repos create It reports an error – An instance of Oracle Enterprise Manager 10g Database Control is already running. It…
Drop the EMCA repository,sysman schema and objects

June 19, 2013

[oracle@linux200 bin]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Jun 19, 2013 4:11:49 PMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information:Database SID: ORCLListener port number: 1521Password for SYS user:Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: YJun 19, 2013 4:12:28 PM oracle.sysman.emcp.EMConfig…
CREATE STANDBY DATABASE USING RMAN

May 16, 2013

[oracle@linux1 database]$ sqlplus /”As sysdba” SQL*Plus: Release 11.1.0.6.0 – Production on Sat Mar 2 19:10:41 2013 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database…