Installation of oracle8i under Linux (Turn)

Concise installation and operation instructions for Oracle Oracle 8.05
Oralce Support Linux gave us a free to lift her a good opportunity, but there are many netizens are not the professionals (just like me), I have some of my operating procedures written out, I hope it will help.
One. Pre-Installation Preparation
1, set up an Oracle installation user, because Oracle can not be installed with root, if forced to use root she will complain, and then strike.
#useradd Oracle (of course it can be any name, but it is recommended to use Oracle as username)
#passwd Oracle
Go to/etc/group find Oracle Group, change group name to DBA (not necessarily, but recommended)
#cd/etc
#vi Group
Note: It is important to ensure that Oracle users are in only one group, otherwise the correct control files cannot be established when Oracle installer establishes the database.
2, build Oracle installation directory and database mount point. For example, I set up a/oracle directory under the root directory as the installation point for Oracle 8.05.
#cd/
#mkdir/oracle
#chown oracle/oracle (Change the owner of the directory to Oracle users)
#chgro dba/oracle (change the group of directories to DBA Group)
#cd/oracle
#su Oracle (Switch to Oracle user)
$mkdir Home (Oracle's Home)
$mkdir DB1 (three storage points for Oracle database "mount point")
$mkdir DB2
$mkdir DB3
3, in the Oracle user's Landing directory, modify the. proflie file, add the necessary environment variables:
$CD ~oracle
$vi. Profile to add the following:
Oracle_owner=oracle
Export Oracle_owner
Oracle_home=/oracle/home
Export Oracle_home
Oracle_sid=mytable
Export Oracle_sid
ld_library_path=/oracle/home/lib/
Export Ld_library_path
Oracle_base=/oracle
Export Oracle_base
Path= "$PATH:/oracle/home/bin:usr/local/bin"
#the End
To give effect to just the setting:
$source. Profile

4, using ROOT to extract the compressed files of Oralce 8.05:
$SU Root
#tar XZVF filename (should be a. tar.gz file) (convenient for the following instructions, assuming decompression in the/download/directory)

Enter/download/orainst/run oratab.sh
#cd/download/orainst
#./oratab.sh
Once the settings are successful, you can start the installation.
Second, install
Installation is very simple, as long as the operation Oarinst Press the prompt operation can, occasionally have an error said that the file or directory does not exist, may be her bug, as long as the switch to a console manually set up a directory, or rerun Setup, installed parts will be prompted to skip.
$CD/download/orainst
$./orainst
Parameters to enter:
If the. profile file has been in effect, the oarcle_home,oracle_base to be entered during installation, Oracle_sid will be filled in automatically, and the only three databases to be manually filled in are mount point. (/ORACLE/DB1,/ORACLE/DB2,/ORACLE/DB3)
Third, late configuration and basic operation
1. Starting and shutting down Oracle server
If installed properly, you should be able to boot up and go to Server Manager to start Oracle server
$svrmgrl
Sml>connect Internal
Sml>startup
Sml>exit
So Oracle starts up.
To turn off:
$svrmgrl
Sml>connect Internal
Sml>shutdown
Sml>exit
If you cannot start, check your/oracle/home/dbs directory to see if there is a Initmytable.ora file, confirm that the table_name=mytable has been set, otherwise manual should come. Other can not move.
Without this file, you can change the Init.ora copy of the catalogue to Initmytable.ora and table_name. (Before change is Table_name=default)
That should be it.
2. Use Sqlplus to query
After starting the server, you can go through the Sqlplus server, cool. (Oracle has established two users with DBA authority by default: System/manager and Sys/change_on_install)
$sqlplus System/manager
Sql>select * from User_tables
Wow, what a bunch of things!!
Alas, Sqlplus's operation I do not care about Luo.
Remote connection for 3,sqlplus
I tested remote connections with Oarcle 8.0 for NT sqlplus 8.0来
If the default is fully installed, Net 8 should already be ready.
Start Listener:
$lsnrctl
Lsn>start
Lsn>exit
So the listener is up, you can use the other machine sqlplus try, quite fun.
If you don't get up,
A. See if your adapter is loaded.
$adapters
If not installed to run/download/orainst/under the Oarinst to load the adapter.
B. Under the oacle_home/network/admin to find a lintener.ora with my file on the right, no words on the cuff over.

# This file was locate in: ~oracle_home/network/admin
#
# installation generated Net8 Configuration
# Version date:jun-17-97
# Filename:Listener.ora
#
LISTENER =
(Address_list =
(address= (protocol= IPC) (key= mytable))
(address= (protocol= IPC) (key= Pnpkey))
(address= (protocol= TCP) (host= Yourhonst.yourdoman) (port= 1521))
)
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname= Yourhost.yourdoman.)
(Oracle_home=/oracle/home)
(Sid_name = RSB)
)
(Sid_desc =
(Sid_name = Extproc)
(Oracle_home =/oracle/home)
(program = Extproc)
)
)
Startup_wait_time_listener = 0
Connect_timeout_listener = 10
Trace_level_listener = Off
#The end.

C. View the Services file under/etc to see if there is a similar line
Listener 1521 #oracle TCP Listener
If not, add it.
Reboot, you should be able to pull
All right, here we go, here we go.
Auther:charcoal
E-mail:charcoal@mail.hn.cninfo.net
1998/12/26 in Changsha
------------------------------------------------------------------------zzzxxxzzz
E-group Home:http://www.egroups.com/list/njlug
Free web-based e-mail groups by egroups.com