Are you having problems with the OEM Host Credential?

If you are using LINUX/Windows the hostname credentials should be the same user who has installed the oracle  database software, if Windows the user you are using need to be member of the ORA_DBA group and have Local Security privilege Continue reading Are you having problems with the OEM Host Credential?

How to find all user Roles and Privileges?

Here is the scripts to help you to get this information: PROMPT  PROMPT  PROMPT ******************************************** ROLES AND PRIVILEGES  PROMPT  PROMPT ******************************************** USER ROLES  SELECT grantee user, granted_role, admin_option, default_role  FROM dba_role_privs  WHERE grantee IN (SELECT username FROM dba_users) AND       grantee Continue reading How to find all user Roles and Privileges?

How to migrate from 32 bit to 64 bit using RMAN?

This procedure can be used for single instance or RAC (9i to 11g): In the 32 bit source server : Start making a full backup of the database including all archivelogs: RMAN> run  {   allocate channel c1 type disk;   allocate channel c2 type Continue reading How to migrate from 32 bit to 64 bit using RMAN?

How to Start and Stop a RAC Environment

Auto Start/Stop The Oracle Cluster Services handle the automatic start and stop of the Cluster, Listener, ASM and the Database. For the Grid Control Agent, the auto start- stop is handled via the /etc/init.d/dbora script.  On server boot the dbora Continue reading How to Start and Stop a RAC Environment

How to setup a Basic Audit?

For any Oracle versions prior to 9i you will need to set audit_trail parameter in the pfile ie.g.: audit_trail = DB For later Oracle Versions: SQL>alter system set audit_trail = DB; To enable auditing for a specific object run the Continue reading How to setup a Basic Audit?

Differences between UNDO and REDO

To clear this question we have this table:  UNDO REDO Record of How to undo a change How to reproduce a change Used for Rollback, Read-Consistency Rolling forward DB Changes Stored in Undo segments Redo log files Protect Against Inconsistent Continue reading Differences between UNDO and REDO

What is the difference between Rollback and Undo Tablespace? OTN Forum By user user503050

There might be confusion while undo and rollback segment terms are used interchangeably in db world. It is due to the compatibility issue of oracle. Undo Oracle Database must have a method of maintaining information that is used to roll Continue reading What is the difference between Rollback and Undo Tablespace? OTN Forum By user user503050

want to migrate 9.2.0.1db on windows data to 10.2.0.2 db on SunOs10, and planning to use full exp/imp..will this work ? by DBA2008 – OTN Forum

Hi DBA2008, I recommend you to create all the structure first, then import all the data. Pre-create tablespaces, users, and tables in the new database to improve space usage by changing storage parameters. When you pre-create tables using SQL*Plus, either Continue reading want to migrate 9.2.0.1db on windows data to 10.2.0.2 db on SunOs10, and planning to use full exp/imp..will this work ? by DBA2008 – OTN Forum

How to create a Temp Tablespace Group on 10g? by America OTN Forum

Tablespace Groups Oracle now has the concept of grouping multiple tablespaces together in what they call a tablespace group. This allows you to create multiple temporary tablespaces, assign these temporary tablespaces to a tablespace group, and then use the tablespace Continue reading How to create a Temp Tablespace Group on 10g? by America OTN Forum