Oracle10g log on to SQL * Plus as a DBA

The following article describes how to log on to SQL * Plus as a DBA at Oracle10g. I saw several related articles on the internet two days ago, to learn how to install the actual operation steps on Windows XP Pro, you can change the path of the following article.

Oracle10g: How to log on to iSQL * Plus as a DBA

Generally, you can log on to the isqlplus website http: // iport/isqlplus. after entering the website, you can directly log on to the Database User Logon page and use the common users in the database to log on.

The DBA user logs on to the isqlpus website http: // iport/isqlplus/dba. after entering the website, a logon box is displayed. You must first enter the iSQL * Plus DBA user and password, note that this is not a database user, but the user and password required by the isqlplus application server.

To log on to isqlplus as a DBA, you must configure the Solaris User first. You can use either of the following authentication methods: xml-based configuration file jazn-data.xml)

LDAPOracle-based Internet Directory)

This article only involves the first method, that is, xml configuration file authentication. The configuration file is located at $ ORACLE_HOME/Solaris/j2ee/isqlplus/application-deployments/isqlplus/config.

However, the password in the configuration file is encrypted, so we cannot manually modify the file, but use the JAZNJava AuthoriZatioN) for configuration. JAZN is a JASSJava Authentication and Authorization Service provided by oracle. I don't know much about java. Fortunately, you only need to follow the document step by step.

With JAZN, you can complete the following tasks: Create users List users Grant the webDba role Remove users Revoke the webDba role Change user passwords

You can run the preceding tasks in the JAZN command environment or directly use a complete command line. The complete command line is simply to add the corresponding task option after the command to enter the JAZN. This article takes the JAZN command environment as an example.

How to enter the JAZN command environment

1. Go to the $ ORACLE_HOME/productname/j2ee/isqlplus/application-deployments/isqlplus/directory/

2. Make sure that the JAVA_HOME environment variable points to the correct jdk requires more than 1.4) path. You can use the jdk that comes with oracle, which is located at $ ORACLE_HOME/jdk.

3. run the following command: java-Djava. security. properties = $ ORACLE_HOME/sqlplus/admin/iplus/provider-jar $ ORACLE_HOME/Solaris/j2ee/home/jazn. jar-user "iSQL * Plus DBA/admin"-password welcome-shell

Realm = iSQL * Plus DBA, user = admin. You can see from the xml configuration file that the default admin password is welcome, but the admin user does not have the webDba permission by default, cannot be directly used to log on to isqlplus.

Note that this command must first go to the directory in step 1 and then run it. Otherwise, an error occurs in oracle. security. jazn. JAZNRuntimeException: Configuration file "configjazn. xml "does not exist. check your JAAS configuration settings. or Realm [iSQL * Plus DBA] does not exist in system.

If the preceding error is reported, check whether your current directory is exactly the same as the one given in step 1.

After entering the JAZN command environment, you can execute all the tasks:

1. New User ning, password pass JAZN:

 
 

  
  
> adduser "iSQL*Plus DBA" ning pass 
 
 

2. List user JAZN:

 
 

  
  
> listusers iSQL*Plus DBA/admin iSQL*Plus DBA/ning 
 
 

JAZN:

 
 

  
  
> listusers "iSQL*Plus DBA" admin ning 
 
 

3. Grant the user the following permissions to log on to isqlplus DBA:

 
 

  
  
> grantrole webDba "iSQL*Plus DBA" ning 
 
 

4. revoke the permission of the user to log on to isqlplus DBA. JAZN:

 
 

  
  
> revokerole webDba "iSQL*Plus DBA" ning 
 
 

5. delete user JAZN:

 
 

  
  
> remuser "iSQL*Plus DBA" ning 
 
 

6. Modify the User Password JAZN:

 
 

  
  
> setpasswd "iSQL*Plus DBA" ning pass newpass 
 
 

7. exit the JAZN command environment. JAZN:> exit

Assume that we have created a user named ning with the password "pass" and have granted the webDba permission.

Restart isqlplus Application Server isqlplusctl stop isqlplusctl start

In the displayed dialog box, enter "ning" and "pass" to go to the database logon page. Select "sysdba" or "sysoper" to log on to the database. The above content is for Oracle10g: the introduction of How to log on to SQL * Plus as a DBA.