The concise installation and operation instructions of oracle8.05 oralce's support for Linux gives us a good opportunity to free her, but many netizens are not professionals (just like me ), I will write some of my operation programs, hoping to help you. I. Preparations before installation 1: Create an oracle installation user, because oracle cannot use r ORACLE8
Brief installation and operation instructions for oracle 8.05
Oralce's support for Linux gives us a free opportunity to release her, but many netizens are not professionals (just like me), so I will write out some of my operation programs, I hope it will help you.
I. Preparations before installation
1. create an oracle installation user. because oracle cannot be installed with root, if it is forcibly used as root, an error will be reported and a strike will be reported.
# Useradd oracle (of course, it can be any name, but oracle is recommended as the user name)
# Passwd oracle
Enter/etc/group to find the oracle group and change the group name to dba (not required, but recommended)
# Cd/etc
# Vi group
Note: Make sure that oracle users are in only one group. Otherwise, the correct control file cannot be created when oracle installer creates a database.
2. create an oracle installation directory and a database mount point. For example, I created 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 an oracle user)
# Chgro dba/oracle (change the directory group to dba)
# Cd/oracle
# Su oracle (switch to oracle user)
$ Mkdir home (oracle's home)
$ Mkdir db1 (three storage points of the oracle database "mount point")
$ Mkdir db2
$ Mkdir db3
3. in the oracle user's login Directory, modify the. proflie file and add the required environment variables:
$ Cd ~ Oracle
$ Vi. profile includes the following content:
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
Make the settings take effect:
$ Source. profile
4. decompress the oralce 8.05 compressed file as root:
$ Su root
# Tar xzvf filename (it should be a .tar.gz file) (for the convenience of the following instructions, assume that the file is decompressed in the/download/directory)
Enter/download/orainst/run oratab. sh
# Cd/download/orainst
#./Oratab. sh
After the setting is successful, you can start installation.
II. Installation
The installation is simple. you only need to run oarinst and follow the prompts. occasionally, an error is reported indicating that the file or directory does not exist. it may be her bug. you only need to switch to a console to manually create a directory, or re-run the installer. if you have installed the installer, you will be skipped.
$ Cd/download/orainst
$./Orainst
Parameters to be entered:
If. the profile file takes effect. the OARCLE_HOME, ORACLE_BASE, and ORACLE_SID files to be entered during installation are automatically filled in. the only mount point for the three databases to be manually filled in. (/oracle/db1,/oracle/db2,/oracle/db3)
III. subsequent configuration and basic operations
1. Start and close oracle server
If the installation is normal, you can start it. go to server manager to start oracle server.
$ Svrmgrl
Sml> connect internal
Sml> startup
Sml> exit
In this way, oracle is started.
To disable:
$ Svrmgrl
Sml> connect internal
Sml> shutdown
Sml> exit
If it cannot be started, check whether the initmytable. ora file exists in your/oracle/home/dbs directory and check that table_name = mytable has been set. otherwise, manually click here. Others can be left unchanged.
If you do not have this file, you can copy the init. ora file in this directory, change it to initmytable. ora, and change table_name. (Table_name = default before modification)
This should be done.
2. use sqlplus to query
After the server is started, you can use sqlplus to connect to the server. (By default, oracle has created two users with dba permissions: system/manager and sys/change_on_install)
$ Sqlplus system/manager
SQL> select * from user_tables
Wow, a bunch of things !!
Alas, I don't care about sqlplus operations here.
3. sqlplus remote connection
I tested the remote connection using sqlplus 8.0 of oarcle 8.0 for NT.
If it is fully installed by default, Net 8 should have been configured.
Start the listener:
$ Lsnrctl
Lsn> start
Lsn> exit
In this way, the listener will get up. you can use sqlplus on other machines to try it. it's fun.
If not,
A. Check whether your adapter is installed.
$ Adapters
If not, run oarinst under/download/orainst/to install the adapter.
B. locate lintener. ora and my files under oacle_home/network/admin. if not, copy them.
# This file is 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. check the services file under/etc to see if a similar line exists.
Listener 1521 # oracle tcp listener
If not, add it.
Reboot, you should be able to pull
Haola, it's here, it's here.
Auther: charcoal
E-mail: charcoal@mail.hn.cninfo.net
In Changsha
-------------------------------------------------------------------------- ZZZXXXZZZ
E-group home: http://www.eGroups.com/list/njlug
Free Web-based e-mail groups by eGroups.com
