Install the Oracle database 10g_5 on Linux x86

Conclusion

Now that your database has been started and running, you can start to use ORACLE 10G. It is best to start using Oracle Enterprise Manager because it is completely rewritten and uses a Web-based interface. If you are not sure where to start,OracleConcept GuideAndDBATwo-day Quick Start GuideIt will help you familiarize yourself with the new database. OTN also provides some help to make full use of 10G. My favorite is the series of articles "Oracle Database 10" written by Arup Nanda.G: The 20 most important features provided by DBAs ."

In the next article, we will gradually explain how to install and configure a fully functional dual-node Oracle RAC 10GDatabase.

Appendix

Use SQL * Plus to access the database

Log on to Linux as an oracle user. Set the environment.

Set Oracle environment variables:

$ Export oracle_base =/u01/APP/Oracle

$ Export oracle_sid = demo1

$ Export ORACLE_HOME = $ oracle_base/product/ 10.1.0 /Db_1

$ Export Path = $ path: $ ORACLE_HOME/bin

Run SQL * Plus:

$ Sqlplus

 

SQL * Plus: Release 10.1.0 . 2.0-production on Sat Jun 5 16:59:21 2004

 

Copyright (c) 1982,200 4, Oracle. All rights reserved.

 

Enter user-Name:/As sysdba

 

Connected:

Oracle Database 10g Enterprise Edition Release 10.1.0 . 2.0-Production

With the partitioning, OLAP and Data Mining options

 

SQL>

Use Oracle Enterprise Manager 10GDatabase Control

In a Web browser, connect to the URL provided during installation.

For example:
Http://ds1.orademo.org: 5500/EM (if the server is not in DNS, you must replace the host name with an IP address .)

Username: SYS
Password: <password selected during installation>
Connection: sysdba

Click <login>

Welcome to Oracle Enterprise Manager 10GThe wonderful world of Database Control!

Start and Stop Oracle Enterprise Manager Database Control:

$ Emctl start dbconsole

$ Emctl stop dbconsole

Use iSQL * Plus to access the database

ISQL * Plus is a Web-based SQL * Plus interactive tool that has a long history and is used to access databases. To use iSQL * Plus, click the iSQL * Plus link in the related links section of the OEM console or point the browser to the iSQL * Plus URL provided during installation.

For example:
Http://ds1.orademo.org: 5560/isqlplus (if the database server is not in DNS, you must replace the host name with an IP address .)

User name: System
Password: <password selected during installation>

Click <login>.

Enter the SQL command in the workspace box, and then clickExecute.

Start and Stop iSQL * Plus:

$ Isqlplusctl start

$ Isqlplusctl stop

Start and Stop listeners:

The Listener accepts client connection requests and creates a database connection after verifying the certificate. To use OEM or iSQL * Plus, you must first start the listener.

$ LSNRCTL start

$ LSNRCTL stop

Start and Stop a database:

The simplest way to start and stop a database is to start and stop it from the OEM console. To perform this operation from the command line, use SQL * Plus after logging on as an oracle user, as shown below:

Start:

$ Sqlplus

 

SQL * Plus: Release 10.1.0 . 2.0-production on Sun Jun 13 22:27:48 2004

 

Copyright (c) 1982,200 4, Oracle. All rights reserved.

 

Enter user-Name:/As sysdba

Connected to an idle instance.

 

SQL> startup

Oracle instance started.

 

Total system global area 188743680 bytes

Fixed size 778036 bytes

Variable Size 162275532 bytes

Database buffers 25165824 bytes

Redo buffers 524288 bytes

Database mounted.

Database opened.

SQL> exit

Shutdown:

$ Sqlplus

 

SQL * Plus: Release 10.1.0 . 2.0-production on Sun Jun 13 22:25:55 2004

 

Copyright (c) 1982,200 4, Oracle. All rights reserved.

 

Enter user-Name:/As sysdba

 

Connected:

Oracle Database 10g Enterprise Edition Release 10.1.0 . 2.0-Production

With the partitioning, OLAP and Data Mining options

 

SQL> shutdown immediate

Database closed.

Database dismounted.

Oracle instance shut down.

SQL> exit

List Oracle processes:

$ PS a € "fuoracle

What is the ocssd. Bin process?

Oracle cluster Synchronization Service (ocssd) is a component of Oracle cluster readiness Service (CRS). It is used for RAC and a single instance Database Using ASM. It is installed by default and uses a small amount of system resources and is configured in the/etc/inittab. These processes are automatically started every time the system starts. We recommend that you do not disable ocssd even if you are not running ASM.