0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email “Francisco Tours Australia and NZ: Oracle ACE (Database) Francisco Munoz Alvarez is presenting his paper “Logging or Nologging: That is the Question” at the AUSOUG National Conference Series in Perth (Oct. 6-7) and Gold…
Author: admin
Perth, 2008 Australian User Group Conference
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Hi, Here are some pictures from the first day of the conference. Tomorrow I’ll present my paper, also I will post more pictures and a podcast of it too. (I’m posting the links because I’m…
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…
Grid Control (GC) Cheat Sheet
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Ensure the Oracle database version can be monitored by Grid Control in Metalink article “Note 412431.1 Oracle Enterprise Manager 10g Grid Control Checker”. Request firewall ports to be opened for 2 way traffic…
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…
Oracle Application Server (10.1.2) Reference Tips – Part I
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Starting an OracleAS infrastructure Start the database listener: # lsnrctl start Start the repository database: # sql> startup Start the processes of the Oracle Infrastructure instance: # opmnctl startall Start the OracleAS Console: #…
Overview of the Oracle Application Server (10.1.2) – Part I
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Oracle Application Server is a complete and integrated platform to develop, deploy, and administer a fast, scalable Internet application through built-in Web caching, load balancing and clustering capabilities. The Oracle Application Server solution areas…