Oracle logs on to isql * plus with DBA Permissions

Source: Internet
Author: User
Tags configuration settings
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.