Install Oracle 10g in Solaris 10 x86 (Part 4)

This part is very straightforward. We just need to do post-installation and verification. All of this just to make sure that our installation is running completely and perfectly. This tutorial actually very basic installation and only install in one host. For better performance, normally Oracle is installed in the distributed environment. You can refer to official Oracle documentation for advanced installation.

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

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

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

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:

Username: SYSTEM Password: oracle Connect Identifier: (leave it blank) Privilege: SYSDBA Click Login You should see the Oracle iSQL*Plus DBA as in this picture. If you notice, this application is different with just normal Oracle iSQL*Plus.

« Previous1234

Next »