WARNING: Oracle executable binary mismatch detected.

WARNING: Oracle executable binary mismatch detected.
Binary of new process does not match binary which started instance
issue alter system set "_disable_image_check" = true to disable these messages

This message was showing in my one of development database after performing some disabling Database Vault configurations.

Oracle recommends for this warning set _disable_image_check= true

what I did:

I bounce my database solved the issue. No message showing in alert log file.

*** As we dont have chance to bounce the production DB better to set the parameter

Database init params error showing while installing fusion (IDM,SOA)

While Installing Repository Creation Utility (RCU) Installation the following error occurs:
I need to create schema with RCU to install Fusion Apps and SOA.

RCU:6107 DB Init Param Error

This can be removed simply by the following:

1. Login on your database with system user.
2. Write > show parameters processes (which will show the current value of processes).
3. If its value is less than 500 then type the following command:
ALTER SYSTEM SET PROCESSES=500 SCOPE=SPFILE;
4. Write > show parameters open_cursors (which will show the current value of open_cursors).
5. If its value is less than 500 then write the following command:
ALTER SYSTEM SET OPEN_CURSORS=500 SCOPE=SPFILE;
6. Restart your DB or system.
7. Also you can check job_queue_processes with the same above.

Imp Linux commands I often use

To find a file :

1) find -name filename1
2) find . -name *.trc -mtime +10 -exec rm {}\;   --- It finds the file and remove if it exists from before 10 days.
3) file  file_name      <---- to fine file type
4) find -name *.req -ctime +10 -exec rm{}\;

Different TAR commands:

1) tar   -cvzf   target_file.tgz  file1 file2 file3    <---
2) tar   -xvzf   file_name.tgz     <---- To extract the TAR file
3) tar   -ztvf   file_name.tgz      <----  To see the contents of a TAR file.

Memory Usage commands:

1)  df -Th
2)  du
3)  du -sh    <----To know particular directory size
4) free -m
5) top

Unzip commands:
1) unzip filename.zip
2) unzip filename.zip -d  /dir/.   ---->> unzip a file to a particular directory  

Telnet command:

1) telnet  IPaddress  portnumber

How To mount a directory in nfs :

 In host system do the following :
( from which system you want to share a directory ) :

1)  vi /etc/exports

 

Here is softwares is the directory I want to mount 

2) restart the nfs and network with below commands:

  
 From the guest machine where you wanted that mounted directory:

1) create a mounted directory structure as in host system:
Here For Ex  : mkdir -p /mnt/softwares
2) mount -t nfs -o rw IPadressofHost:/mnt/softwares /mnt/softwares

11g database generating excessive .trc and .trm files

Hi, One of my development database generating excessive .trm and .trc files. As well as writing shell script to delete them I used adrci utility to drop them.

adrci is the utility provided to purge the diag_dest

$ adrci
adrci > purge -age 60 -type trace

above command will delete all the trace files older than one hour.

and to create a permanent policy you can use following command on the adrci prompt.

adrci> set control (SHORTP_POLICY = 24) ### Here time is in hours.

If we set control like above it will delete the files with 1 day difference.

also I found one intresting thing that is incident directory under /u01/app/oracle/diag/rdbms/dev/dev/incident

It contains more number of .trc and .trm files . I deleted them by using below command with adrci utility:


adrci > purge -age 60 -type incident

To rename database national character set

When creating a new database, the NCHAR was not set properly for 11GR2.
 We followed the below steps in order to change NCHAR set.  
Steps to be followed, 
 Step 1: shutdown immediate;  
Step 2: startup mount;  
Step 3: alter system enable restricted session;
Step 4: alter system set job_queue_processes=0;
Step 5: alter system set aq_tm_processes=0;  
Step 6: alter database open;  
Step 7: alter database national character set UTF8;  
Step 8: shutdown immediate;  
Step 9: Startup  
Step 10: Check NCHAR values

Query to find the SCHEMA Size in oracle database

Here the query,
SELECT s.owner,SUM (s.BYTES) / (1024 * 1024 * 1024) SIZE_IN_GB
FROM dba_segments s
GROUP BY s.owner;