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 server. Test by issuing telnet commands on port 4889 from your target to your…
How can I start a trace?
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 or to disable trace use sql_trace = FALSE 2)To enable tracing without restarting the…
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 following command: SQL>AUDIT SELECT, INSERT, UPDATE, DELETE ON SCHEMA.TABLE; To stop auditing use: SQL>NOAUDIT SELECT,…
Oracle Application Server (10.1.2) Reference Tips – Part I
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 http://host:1810 Stop an OracleAS infrastructure Stop the OracleAS Console: # emctl stop iasconsole…
Overview of the Oracle Application Server (10.1.2) – Part I
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 use of a comprehensive and flexible framework that allows you to design, develop, and…
Some Good or Bad news, I’m not sure Yet…
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 a severe asthma problem triggered by severe stress. Last week I had a meeting where…
Oracle is the #1 Relational Database
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 in 2006) growing at 14.9 percent Is growing faster than the market average of…
Win a cool Oracle 11g Watch
Refer your colleagues to subscribe to the Database Insider newsletter and when any two of them subscribe, you’ll be entered in drawing to win this cool, limited edition Oracle Database 11g watch! To participate please click HERE. Note: Drawing will be on October 1, 2008 and winners will be notified via email from Oracle.
Learning and Preparing to a DBA Interview
“The main idea of this article is to help you to prepare to an Oracle DBA Interview and at the same time help you to learn and understand the most important basic points that a good Oracle DBA need to know. “ Advice: Be brief and stick to the topic in your answers. The interviewer will ask…
NZ Tech-ed 2008
Hi, Here are some pictures from the Tech-ed NZ 2008: Soon I will upload some presentations and videos from this Microsoft Event. Regards, Francisco Munoz Alvarez