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

Generally, you can log on to the ISQLPLUS website http: // ip: Port/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: // ip: Port/isqlplus/DBA. after entering the website, a login 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 to authenticate your account: XML-based configuration file (jazn-data.xml) LDAP-based (Oracle 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 configure it through Java authorization. Jazn is a jass (Java authentication and authorization Service) tool provided by Oracle. I don't know much about Java. Fortunately, you only need to follow the document step by step. You can complete the following tasks through the jazn: 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. Execute 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, you cannot directly log on to ISQLPLUS. Note that this command must first go to the directory in step 1 before execution. Otherwise, an error will be reported. 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 and password pass Jazn:> adduser "iSQL * Plus dba" Ning pass 2. List users Jazn:> listusers ISQL * Plus DBA/admin ISQL * Plus DBA/Ning Jazn:> listusers "iSQL * Plus dba" Admin Ning 3. Grant the user the permission to log on to ISQLPLUS DBA Jazn:> grantrole webdba "iSQL * Plus dba" Ning 4. revoke the user's permission to log on to ISQLPLUS DBA Jazn:> revokerole webdba "iSQL * Plus dba" Ning 5. delete a user Jazn:> remuser "iSQL * Plus dba" Ning 6. Change 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 the ISQLPLUS application server. Isqlplusctl stop Isqlplusctl start Go to the URL http: // ip: Port/isqlplus/DBA. In the displayed dialog box, enter Ning and pass to go to the database logon page, log On As sysdba or sysoper. ReferenceArticle How does Oracle10g enable ISQLPLUS: http://ningoo.itpub.net/post/2149/200372 How to enable DBA login ISQLPLUS: http://download-west.oracle.com/doc...h2.htm#CIHDEFBA in Oracle official documentation Note: This article is taken from the network and the version belongs to the original author.