Analysis on how Oracle 10g isqlplus uses DBA account

This article mainly introducesOracle 10g isqlplusUseDBA accountNext, we will introduce them one by one.

1. vi. bash_profile

Add Environment Variables

 
 

  
  
export JAVA_HOME=$ORACLE_HOME/jdk 
 
 

Save and exit.

 
 

  
  
source .bash_profile 
 
 

2. Switch to the correct directory

 
 

  
  
cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus 
 
 

3. Run the JAZN shell.

 
 

  
  
$JAVA_HOME/bin/java -Djava.security.properties=$ORACLE_HOME/sqlplus/admin/iplus/provider  
  
  
 
  
  
 -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar  
  
  
 
  
  
 -user "iSQL*Plus DBA/admin" -password welcome -shell 
 
 

Or

 
 

  
  
$JAVA_HOME/bin/java -Djava.security.properties=$ORACLE_HOME/oc4j/j2ee/home/config/jazn.security.props   
  
  
 
  
  
-jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar   
  
  
 
  
  
-user "iSQL*Plus DBA/admin" -password welcome -shell 
 
 

4. Create a user

 
 

  
  
JAZN:> adduser "iSQL*Plus DBA" oracle oracle 
 
 

In this example, the user oracle is created and the password is oracle. Syntax:

 
 

  
  
adduser "iSQL*Plus DBA" username password 
 
 

5. Grant the webDba role to the user

 
 

  
  
JAZN:> grantrole webDba "iSQL*Plus DBA" oracle 
 
 

6. Exit the JAZN shell.

 
 

  
  
JAZN:> exit 
 
 

This section describes how to use the DBA account for Oracle 10g isqlplus. We hope this will bring you some benefits!