Arvind Toorpu

Blog Posts

  • script to drop all objects in your schema

    This script can be used to drop all the objects in your schema,very useful when you want a fresh schema and start from scratch.no need to delete objects individually or recreate user. —————————————————————————–—–    plsql script to drop all the objects in your —–      current schema————————————————————–declarev_str1 varchar2(200) := null;cursor get_sql isselect‘drop ‘||object_type||’ ‘|| object_name||…

  • Some very usefull sql’s for Datagaurd

    Backup – DataGuard Startup commandsTo remove a delay from a standbyCancel managed recoveryRegister a missing log fileIf FAL doesn’t work and it says the log is already registeredCheck which logs are missingDisable/Enable archive log destinationsTurn on fal tracing on the primary dbStop the Data Guard brokerShow the current instance roleLogical standby apply stop/startSee how up…

  • disable password verify function in oracle

    disable password verify function in oracle

    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

    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

    [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…

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts