Fedora is a Linux based operating system designed by Red Hat that provides users with access to the latest free and open source software, in a stable, secure and easy to manage form. Fedora is the largest of many free software creations of the Fedora Project, a partnership of free software community members from around the globe. The goal of The Fedora Project is to work with the Linux community to build a complete, general purpose operating system exclusively from open source software. In this tutorial, I will explain how to install Fedora 10 on VMware Workstation 6.5

Everytime I shutdown my Solaris 10, sometimes I forget how to start and stop database Oracle 10g. So, I write down this article to remind me again if I forget to start/stop my database. You have to refer to this article Install Oracle 10g in Solaris 10 x86 as a reference for some configurations.

START AND STOP DATABASE ORACLE 10g

---

1. Login as database owner user. In this case, the user is oracle.

bash-3.00# su - oracle
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005

2. Set ORACLE_HOME and ORACLE_SID.

bash-3.00$ export ORACLE_HOME=/export/home/oracle/product/10.2.0/db_1
bash-3.00$ export ORACLE_SID=ORASOL

3. Goto the Oracle instance folder.

bash-3.00$ cd /export/home/oracle/product/10.2.0/db_1/bin/

4. Execute SQL*Plus.

bash-3.00$ ./sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 5 12:41:03 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL>

5. Connect database as sysdba account.

SQL> connect / as sysdba
Connected to an idle instance.

6. Start database.

SQL> startup
ORACLE instance started.

Total System Global Area 289406976 bytes
Fixed Size 1279820 bytes
Variable Size 92276916 bytes
Database Buffers 192937984 bytes
Redo Buffers 2912256 bytes
Database mounted.
Database opened.

7. Verify database by executing simple SQL script.

SQL> SELECT * FROM tab;

8. Stop database.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

9. Exit SQL*Plus.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$

START AND STOP LISTENER ORACLE 10g

---

We will use lsnrctl command to start/stop listener. Basically lsnrctl (Listener Control) is an SQL*Net utility used for controlling database listeners. A listener is required for allowing remote (not local) clients to connect to the Oracle database via the network. This utility cannot create or configure listeners, but provides commands to control listener functions such as starting and stopping listeners, reporting the status of listeners, changing parameter listener settings, etc.

1. Under root login, make sure that you have configure your host. Please check it using this command.

bash-3.00# cat /etc/hosts
#
# Internet host table
#
::1             localhost
127.0.0.1       localhost
192.168.56.132  solaris10.server.com    solaris10       unknown # Added by DHCP

2. Login as database owner user. In this case, the user is oracle.

bash-3.00# su - oracle
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005

3. Goto the Oracle instance folder.

bash-3.00$ cd /export/home/oracle/product/10.2.0/db_1/bin/

4. Start listener.

bash-3.00$ ./lsnrctl start

5. Stop listener.

bash-3.00$ ./lsnrctl stop

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 »

After all the preparation tasks is done. Now we are ready to install Oracle 10g. We will install Oracle 10g using GUI, so that it will be easier to configure and install. This part is very straightforward, so you just follow the step-by-step based on the picture.

INSTALLATION

---

Before we do this steps, make sure that you login as a root, unless it mentions to login as other user.

1. Check the IP address:

bash-3.00# ifconfig -a
lo0: flags=2001000849 mtu 8232 index 1
inet 127.0.0.1 netmask ff000000
e1000g0: flags=1004843 mtu 1500 index 2
inet 192.168.56.132 netmask ffffff00 broadcast 192.168.56.255
ether 0:c:29:72:90:cd

2. Enter the following command:

bash-3.00# xhost 192.168.56.132
192.168.56.132 being added to access control list

3. Login as oracle:

bash-3.00# su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005

4. Enter the following command:

$ bash
bash-3.00$ DISPLAY=192.168.56.132:0.0; export DISPLAY

5. Run the Oracle installer:

bash-3.00$ cd /export/home/oracle_installer/database/
bash-3.00$ ./runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be 5.10. Actual 5.10
Passed

Checking Temp space: must be greater than 250 MB. Actual 2010 MB Passed
Checking swap space: must be greater than 500 MB. Actual 2341 MB Passed
Checking monitor: must be configured to display at least 256 colors.
Actual 16777216 Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer
from /tmp/OraInstall2009-04-22_10-13-53PM. Please wait ...

6. Please wait for a while until it show the installer. Choose Advanced Installation. Click Next.

7. Click Next.

8. Choose Enterprise Edition (1.38GB). Click Next.

9. Click Next.

10. Just wait for a while, until all the Prerequisite Checks are succeeded.

Then click Next.

11. Click Next.

12. Click Next.

13. If you notice the SID, actually this value we have already set in /export/home/oracle/.profile file (See Part 2). We don't need to change anything.

Click Next.

14. Click Next.

15. Click Next.

16. Click Next.

17. Here, we just use the same password for all the user account. For example password: oracle

Click Next.

18. Click Install.

19. We just wait until the installation finished.

20. Again, we just wait until Database Configuration finished.

21. Click OK.

22. Don't click OK. We have to run the scripts as instruction here.

Run orainstRoot.sh

bash-3.00# /export/home/oracle/oraInventory/orainstRoot.sh
Changing permissions of /export/home/oracle/oraInventory to 770.
Changing groupname of /export/home/oracle/oraInventory to oinstall.
The execution of the script is complete

Run root.sh

bash-3.00# /export/home/oracle/product/10.2.0/db_1/root.sh
Running Oracle 10g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /export/home/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

Then go back to the window and click OK.

23. CONGRATULATIONS...!! Oracle 10g has been installed successfully in Solaris 10 x86.

Click Exit.

Continue to PART 4...

« Previous1234Next »