Install Oracle Database on Linux server



Install oracle Database:

useradd -g oinstall -G dba,oper "OS username"
passwd *****
mkdir -p /db/oracle/11.2.0.3/
chown -R oracle:oinstall /db/oracle
chmod -R 775 /db/oracle

Edit .bash_profile
Read More

DIA-48448: This command does not support multiple ADR homes


DIA-48448: This command does not support multiple ADR homes



This error come because ADRCI in server has multiple Oracle instances on it.

To check the error in your environment please use the below command:
adrci> show control
DIA-48448: This command does not support multiple ADR homes
Read More

How to check the Oracle database version ?

You can know the Oracle Database version by the following way :

 login to sqlplus by  SYSTEM user OR SYSDBA.

 Then Type one of the following command:
Read More

How to change SYSADMIN password ?

How to change SYSADMIN password ?

To change SYSADMIN password please fellow the below steps:

 1- Shut down all application server services:
Read More

Purge trace and diagnostic files using ADRCI Command


1. Ensure the $ORACLE_HOME and PATH environment  are set .

2. The PATH environment variable must include ORACLE_HOME/bin.
Read More
Subscribe to: Posts (Atom)