POST-INSTALLATION
Edit the Database Startup Script parameter in /var/opt/oracle/oratab file to "Y"
ORASOL:/export/home/oracle/product/10.2.0/db_1:Y
VERIFICATION
1. Access Oracle Enterprise Manager URL: http://solaris10.server.com:1158/em
Login as: SYSTEM Password: oracle Connect As: Normal Then click I agree You should see the Oracle Enterprise Manager as in this picture. |
2. Access iSQL*Plus URL: http://solaris10.server.com:5560/isqlplus
Username: SYSTEM Password: oracle Connect Identifier: (leave it blank) Then click Login You should see the Oracle iSQL*Plus as in this picture. Here is the place you can simulate the SQL scripts. |
3. Setup iSQL*Plus DBA.
a. Configure ORACLE_HOME and JAVA_HOME variable.
bash-3.00# export ORACLE_HOME=/export/home/oracle/product/10.2.0/db_1
bash-3.00# export JAVA_HOME=$ORACLE_HOME/jdk
bash-3.00# export JAVA_HOME=$ORACLE_HOME/jdk
b. Create user who have access to the iSQL*Plus DBA.
bash-3.00# cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
bash-3.00# $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 -adduser "iSQL*Plus DBA" oracledba oracle
bash-3.00# $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 -adduser "iSQL*Plus DBA" oracledba oracle
c. Start the JAZN shell.
bash-3.00# $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
d. (Optional) List users who have been created and added to the iSQL*Plus DBA realm. We should have 2 users.
JAZN:> listusers "iSQL*Plus DBA"
admin
oracledba
admin
oracledba
e. Grant user to the webDba role.
JAZN:> grantrole webDba "iSQL*Plus DBA" oracledba
f. Exit the JAZN shell.
JAZN:> exit
4. Access iSQL*Plus DBA URL: http://solaris10.server.com:5560/isqlplus/dba
First, it will show the JAAS authentication window. User Name: oracledba Password: oracle Click OK |
5. In this iSQL*Plus DBA screen, put: