0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 (SELECT username FROM dba_users) AND grantee NOT…
Month: September 2008
How to migrate from 32 bit to 64 bit using RMAN?
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 type disk; allocate channel c2 type disk; …
How to Start and Stop a RAC Environment
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 script. On server boot the dbora script…
Grid Control (GC) Cheat Sheet
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 between your target and your Grid Control…
How can I start a trace?
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 processes sql_trace = TRUE to enable it…
How to setup a Basic Audit?
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 for a specific object run the following…
Oracle Application Server (10.1.2) Reference Tips – Part I
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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: # emctl start iasconsole – then try it…
Overview of the Oracle Application Server (10.1.2) – Part I
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 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 are: J2EE, and Internet Applications:J2EE enables the…
Some Good or Bad news, I’m not sure Yet…
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email The company I work for here in New Zealand is not currently supporting me and overloading me of work because they have only interest on explore my new ACE status to get new clients and projects, due to this situation I’m currently suffering…
Oracle is the #1 Relational Database
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email Gartner 2007 Worldwide RDBMS Market Share Reports 48.6% Share for Oracle (*) Gartner has published their market share numbers by operating system for 2007 based on total software revenues. According to Gartner, Oracle Has 48.6 percent share (up from 47.9 percent…