0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Let start this New Year with a new mentality or a new resolution if you prefer call this way, let stop being reactive and start being proactive. Being proactive will reduce your database administration…
Category: Oracle FAQ
Frequent Answers for Questions Made in the Oracle OTN Foruns
Are you having problems with the OEM Host Credential?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
How to find all user Roles and Privileges?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
How to migrate from 32 bit to 64 bit using RMAN?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
How to Start and Stop a RAC Environment
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
How can I start a trace?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Here are some possible ways to setup Trace: To Enable trace at instance level 1) Set the parameter sql_trace in the pfile or spfile. It will enable trace for all sessions and the background…
How to setup a Basic Audit?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
Differences between UNDO and REDO
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
What is the difference between Rollback and Undo Tablespace? OTN Forum By user user503050
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…
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
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email 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…