Linux under the Oracle Boot process __ Applet

Under Linux to start Oracle and in Windows is different, for general in Windows operating habits people have a lot of not adapt, so I write this article to facilitate the novice to operate, the following step-by-step to explain the start process.
1. Connect to the Linux server through the terminal, of course such software many such as PUTTY,SECURECRT, and with the Oracle user login, otherwise start Oracle will be wrong, do not have permission to start. (user root can also log in, and then Su-oracle)
2. User SYS connects to the database and executes the following command.
A.sqlplus/nolog;
B.conn sys/passwd as SYSDBA;
3. Start the database, because there are many kinds of startup methods such as using Pfile,spfile, here I do not elaborate on the specific starting mode, to the simplest example for the explanation, startup to start (the actual is to start with SPFile), under the prompts to run.
Startup
(Note that the general boot will have three steps corresponding to the database to do three things.)
A.startup Nomount Open Instance
B.alter Database mount data file
C.alter database open Open Data file
)
4. Start up the database in general, the client can not connect to the server, we want to start the listener program. Move step 3rd out of the Sqlplus to the command prompt to start listening and execute the following command.
A.lsnrctl (Play pro-hearing procedure)
B.status (View listening status)
C.start (Start listening)
D.stop (Turn off listening)
If the above is OK, we can configure our client's TNS file with the display information that is started.
5. TNSNames. Format files are as follows (service_name to be consistent with the listener instance name of the server)
# Tnsnames.ora Network Configuration File:e:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.1.98) (PORT = 1566))
)
(Connect_data =
(service_name = Oracle)
)
)
ORACLE11 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.1.22) (PORT = 1521))
)
(Connect_data =
(service_name = Oracle)
)
)
SuSE =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.1.177) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
Suse1 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.1.109) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
oracle10g=
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.1.103) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
6. After configuring TNS, we test the network configuration and TNS configuration first
A.ping 192.168.1.177 (this refers to the server IP) if there is a return value is passed, otherwise the network has problems, please check the network or appropriate configuration.
B.tnsping SuSE (the alias of the connection) if there is a return value indicating that the configuration is normal, there is a problem with TNS configuration (most of the problems are that we are not case-sensitive or that the writing is not recognized)
After all of the above is passed, we can connect the client to the server, such as Pl/sql,sqlplus,toad.