ORACLE DATABASE QUESTIONS TO READ

what is the use of orapwd file?

Creating a password file via orapwd enables remote users(we can give dba priviliges) to connect with administrative privileges through SQL*Net.  


1.when you are connecting to sysdba you are unable to connect and it is saying that archive log filled error?

2.If all are working fine,still concurrent requests are getting errored with unable to connect particular database.(all programs are erroring)?

FIX:in 10.1.2/bin we have reports executable there we have to set PATH of ORACLE_HOME

3.Control file is having different dbname and db is up with different name?what is the solution

we have to edit the pfile with new control file and recreate the control files

4.In adpatch ,A is the main patch and B,C are reqeuestion patches. if your junior applied the main patch and realized he was applying main patch with out applying the pre-req patches,what is the solution?

we have to take the two concurent tables

FND_CONCUREN_REQESTS

5.how to put trace for the long running programs?

6.tkprof sorting parameters and use?

it will give the top execution times

7.CCG sync process?

8.how to restore particular dbfile from RMAN Backup?

9.how to  Blocking Oracle access by IP Address?
The secret lies in the SQLNET.ORA file. This file can be found in your $ORACLE_HOME/network/admin directory along with your tnsnames.ora and listener.ora. Open it up and insert the following line:

tcp.validnode_checking = yes

This turns on the hostname/IP checking for your listeners. After this, you can supply lists of nodes to enable/disable, as such:

tcp.invited_nodes = (hostname1, hostname2)
tcp.excluded_nodes = (192.168.10.3)