mzh

Popular pages

• mzh

  mzh Solution to Problem:   "ORA-01665: control file is not a standby control file" The Solution is to put the command to tell dataguard that this is physical standby. ALTER DATABASE CONVE...

• ORACLE FLASH RECOVERY AREA USAGE QUERY

  FINDING ORACLE FLASH RECOVERY AREA USAGE SELECT NAME,        (SPACE_LIMIT / 1024 / 1024 / 1024) SPACE_LIMIT_GB,          ((SPACE_LIMI...

• Creating and Assigning User Profile in Oracle

  Profiles in Oracle Profiles are used to limit resources a user can use. Then, they can be assigned to users with alter user ... profi...

• “at” utility in SOLARIS: SCHEDULING ONE TIME JOBS

    “at” utility in unix is similar to the “cron” daemon except for that “at” jobs are run only once while cron jobs are recurring. “at” ...

• Configuring Multiple Port on Default LISTENER in oracle 10g

  ·          Go to Listening locations tab from drop down menu. ·          Press Add Address button and select protocol as IPC . ...

• ORACLE USERS, GRANTS, REVOKES AND DROP

  Create USER: create user username identified by password default tablespace users temporary tablespace temp quota 50M on users; Create ...