Windows install Oracle,sqlplus Connection start Oracle (what is the Oracle host string input)

1.oracle Installation

Refer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here

2. Command line sqlplus Connect Oracle

(1) Check the monitoring status

c:\>lsnrctl Status

Lsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:01

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (Description= (address= (protocol=tcp) (Host=oyez) (port=1521))tns-12541:tns: No listener tns-12560:tns: Protocol Adapter Error TNS-00511: No listener 32-bit Windows Erro R:61:unknown error is connected to (description= (address= (PROTOCOL=IPC) (KEY=EXTPROC0))) Tns-12541:t NS: No listener tns-12560:tns: Protocol Adapter Error TNS-00511: No listener 32-bit Windows error:2: No such file or directory

The above information indicates that no listener is started.

(2) Start monitoring

C:\>lsnrctl Start

Lsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:36

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Start Tnslsnr: Please wait ...

Tnslsnr for 32-bit windows:version 9.2.0.1.0-production system parameter file F:\oracle\ora92\network\admin\listener.ora write f:\ Log information for Oracle\ora92\network\log\listener.log             Monitoring: (Description= (Address= (protocol=tcp) (Host=oyez) (port=1521)) Monitoring: (Description= (Address= (PROTOCOL=IPC) ( PIPENAME=\\.\PIPE\EXTPROC0IPC)))

Connecting to (Description= (address= (protocol=tcp) (Host=oyez) (port=1521))              LISTENER's STATUS            ----- -------------------aliases                         LISTENER version                         Tnslsnr for 32-bit Windows: Version 9.2.0.1.0-production Start Date                     2 August-June-2005 11:01:38 uptime                 0 days 0 hours 0 minutes 2 seconds             Tracking level & Nbsp;                &nbSp Off Security                       OFF             snmp                         OFF Listener parameters file            F:\oracle\ora92\network\admin\ Listener.ora Listener log Files            F:\oracle\ora92\network\log\ Listener.log Monitoring Endpoint Overview ...             (description= (address= ( PROTOCOL=TCP) (Host=oyez) (port=1521)))             ( Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC0IPC)))

(3) connect to the database

c:\>sqlplus \nolog

Sql*plus:release 9.2.0.1.0-production on Tuesday June 28 11:05:27 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

sql> Conn user/[email protected] as sysdba//user and password are your needs bark username and password, such as sys/ 123456

error:ora-12500:tns: Listener cannot start private server process

Sql>exit;

Cause: The local database corresponding service is not open, in the service to the Oracleu corresponding service opened

(4) connect to the database

e:\>sqlplus/nolog

Sql*plus:release 9.2.0.1.0-production on Tuesday June 28 11:17:53 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

sql> Conn user/[email protected] as sysdba connected. Sql>

3. Connect Oracle with your own sql*plus

When using Sql*plus to connect to the database, a dialog box is required to fill in the user name, password, and host string information. The former two needless to say, I will fill in the right, but this host string does not know what meaning, through the data to understand, in fact, this string is automatically generated when the installation of Oracle, it is the configuration of the database connection service name, general and you set at the installation of the global database name consistent,     The default is ORCL, so when connecting, you should fill in the host string as ORCL as SYSDBA. With SYS as the user name, password as the password, SYSDBA login for the connection or connect to Sql*plus, enter the user name: sys, password: password, host string: ORCL as Sysdba

If the host string is wrong, it will always be error-filled.

Install Oracle,sqlplus connection under Windows Start Oracle (what is the Oracle host string input)