Oracle OCA Exam dumps for 9i , 10g

You can download following dumps for 1Z0-042 and 1Z0-031 from the following site http://braindupms.com

DBA and SYSDBA - Tips to a newbie(3)

SYSDBA and DBA are often misunderstood. In short, SYSDBA is a system privilege whereas DBA is a role.
The DBA role does not include the SYSDBA or SYSOPER system privileges. SYSDBA and SYSOPER are special administrative privileges that allow an administrator to perform basic database administration tasks, such as creating the database, instance startup and shutdown, drop a database, open and mount a database, place database in archivelog mode or remove it from archivelog mode.
About SYSDBA system privilege

The SYSDBA and SYSOPER system privileges allow access to a database instance even when the database is not open. Control of these privileges is totally outside of the database itself. The SYSDBA and SYSOPER privileges can also be thought of as types of connections that enable you to perform certain database operations for which privileges cannot be granted in any other fashion. For example, if you have the SYSDBA privilege, you can connect to the database by specifying CONNECT AS SYSDBA

courtesy :

http://momendba.blogspot.com/2007/07/closer-look-at-sysdba-and-dba.html

Troubleshooting Enteprise manager-Tips to a newbie(2)

Have you come across a situation where you try to connect to Enterprise manager using the URL but unable to connect, giving some weird error messages.

Like java.lang.Exception: Exception in sending Request :: null or agent not found or similar ??

This is probably due to a problem with dbconsole agent.

Most of the time this is caused by the incorrect time zone selected in emd.properties

emd.properties file is found in 'Oracle_home\sysman'

Try some of there steps to solve. Might be useful

start oracle service

set oracle_sid=orcl

check timezone in emd.properties

if no valid time, set the OS time zone and add a supported entry(agentTZRegion=Asia/Calcutta)

reset agent

emctl resetTZ agent

start console

emctl status dbconsole

set agent path

set oracle_home=D:\oracle\product\10.2.0\db_1

start agent

emctl start agent

to check staus

emctl status dbcolsole

emctl status agent

to get time zone from config

emctl config getTZ

Setting up Oracle 10g in Windows - Tips to a Newbie

Are you new to Oracle? Have you been spending tiresome hours troubleshooting Oracle?
Well.. I would say 'Yes' if someone asked me :)
But I never think that the time has been wasted. Remember... 'No pain, No gain' :)
Recently I did setup an Oracle 10g on a Vista machine and I would like to share some important scenarios that I experienced.

1. Is your Oracle compatible with the OS?
Well.. the first issue came across is this. I tried to install 10.2.0.3 on a XP machine and it says 'Your OS does not support...'. I should have had 10.2.0.1 to install in a XP

How the DB is versioned?
10.2.0 is the actual release version and '3' is the patch set. Check Oracle site (http://www.oracle.com/technology/software/products/database/index.html) for compatibility, before you download.

2. Is your DB server DHCP enabled?

If your server is DHCP enabled, you will get a test failed condition in verification phase. To solve this add a Microsoft loop back adapter
Go to Control panel->Add Hardware
Select Network adapters
select Microsoft Loop back adapter
Once Installed, configure properties for IPV4 with following static IP values 10.10.10.10/255.255.255.0

3. Have you come across a situation where you are in front of the Db server and trying to connect to the database via sqlplus "/ as sydba", and get the following error 'ORA-01031: insufficient privileges' enter your use-name: and your sys password is not accepted

One reason might probably be that you have logged in to the DB server not as the administrator.(or probably not as product owner). If that is the case and if you are unable to log in as product owner, and if you still want to log in to database, there is a work around for you.

1. Delete and recreate a new password file
give password file name and location, and password
In DOS prompt type:
orapwd file = c:\ora_home\database\pwdfile.ora password=oracle

2. Restart Oracle database
Go to Services and restart the service (OracleService)

3. Now try to log in to DB via sqlplus "/ as sydba" with new password