Sunday, September 30, 2007

Oracle Database 11g New Features for Administrators (1Z1 - 050 Beta Exam)

Dear friends,

The Beta Exam on Oracle Database 11g New Features for Administrators is now available.

Exam Number: 1Z1-050 ( Beta Exam )
Exam Registration: Pre-registration begins September 29, 2007.Beta Exam available November 1 – December 15, 2007
Exam Price: Beta Exam $50 US
Duration: 190 minutes
Number of Questions: 180-220
Passing Score: TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam.

For more information on training, preparation, exam topics and other information, please take a look at the below URL.

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1001&lang=US&p_exam_id=1Z0_050

Preparation Books/Documents:

http://www.amazon.com/OCP-Oracle-Database-11g-Administrators/dp/0071496823

http://www.amazon.com/Oracle-Database-11g-New-Features/dp/0071496610/ref=pd_sxp_grid_pt_0_0/102-4078405-8004159

*** When you take this exam, please share your experience with this exam in this blog as comments ***

Thanks & Regards,

Sabdar Syed,

http://sabdarsyed.blogspot.com

Monday, September 10, 2007

How to find the ORACLE_HOME path in Oracle Database?

In 9i:

SELECT substr(file_spec,1,instr(file_spec,'lib')-2) ORACLE_HOME FROM dba_libraries
WHERE library_name='DBMS_SUMADV_LIB';

In 10g:

SQL > var OHM varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL > PRINT OHM

Linux/Unix:

echo $ORACLE_HOME

Windows:

start - run - regedit (enter) - HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE

Type the below command at prompt if the environment variable is defined for ORACLE_HOME

c:\> set oracle_home (ENTER)

Update: Take a look at my other post on "Setting an Oracle Environment variable – ORACLE_HOME"

Saturday, September 1, 2007

My blog has been added in Oracle Blogs list !!

Dear Friend,

This is to inform you that my blog http://sabdarsyed.blogspot.com has been reviewed by Oracle and added in Oracle’s official web site http://blogs.oracle.com/ where all most all top blogs, on Oracle Technology, have been registered.

Happy Reading !!

With Best Regards,

Sabdar Syed,