Oracle logs on to isql * plus with DBA Permissions

After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle. Two isqlplus websites are available.

After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle, including two isqlplus websites. This is because common users and dba users log on to

After the Oracle 10g Database is installed, the web page is installed by default to manage the Oracle access path, including:

Em: 1158/em

Isql * plus: 5560/isqlplus and: 5560/isqlplus/dba

Two isqlplus websites are available, because common users and dba users log in.

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)

The second type is looking for a test. If any of the tests come out, share them.

Test in the first way, that is, using xml configuration file authentication. The configuration file is located in

% ORACLE_HOME %/productname/j2ee/isqlplus/application-deployments/isqlplus/config ($ ORACLE_HOME for linux or unix)

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. jdk is required or the built-in jdk of oracle can be used, under % ORACLE_HOME/jdk.

You need to configure java_home and path, which will not be described here.

Under dos, if the installation path is different from that of oracle to switch to the same drive letter, we need an absolute path.

After understanding the prerequisites, we will start:

Go to the database installation directory.

% ORACLE_HOME %/productname/j2ee/isqlplus/application-deployments/isqlplus/

Run the following command:

D: \ oracle \ product \ 10.2.0 \ db_1 \ BIN> java-Djava. security. properties = D: \ oracle \ prod
Uct \ 10.2.0 \ db_1 \ sqlplus \ admin \ iplus \ provider-jar D: \ oracle \ product \ 10.2.0 \ db_1 \
Productname \ j2ee \ home \ jazn. jar-user "iSQL * Plus DBA/admin"-password welcome-shell

After entering:

JAZN:>

Add a user:

JAZN:> adduser "iSQL * Plus DBA" user password

View users:

JAZN:> listusers "iSQL * Plus DBA"
Admin
Gyc

Grant permissions:

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

Revoke permissions

JAZN:> revokerole webDba "iSQL * Plus DBA" gyc

Restart isql * plus

Isqlplusctl stop

Isqlplusctl start

Log on to isqlplus again with the sysdba permission.

If the path is incorrect, the following error is prompted:

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.