Linux_Oracle10 下载安装

Linux_Oracle10 安装文档及oracle下载地址

http://download.csdn.net/detail/u012750578/8177405

一、启动数据库服务

[root@hqw ~]# su oracle
[oracle@hqw root]$ sqlplus "/ as sysdba"


SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 12 16:25:45 2014


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to an idle instance.

SQL> startup
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size    1218992 bytes
Variable Size   92276304 bytes
Database Buffers  188743680 bytes
Redo Buffers    2973696 bytes
Database mounted.
Database opened.
SQL> 

SQL> conn scott/scott
Connected.
SQL> select * from tab;


TNAME       TABTYPECLUSTERID
------------------------------ ------- ----------
DEPT       TABLE
EMP       TABLE
BONUS       TABLE
SALGRADE       TABLE


SQL> select * from dept;


    DEPTNO DNAME  LOC
---------- -------------- -------------
10 ACCOUNTING  NEW YORK
20 RESEARCH  DALLAS
30 SALES  CHICAGO
40 OPERATIONS  BOSTON


SQL> 

二、启动数据库监听服务

未启动监听前

C:\Users\Administrator>sqlplus scott/scott@192.168.11.2:1521/orcl


SQL*Plus: Release 11.2.0.1.0 Production on 星期三 3月 16 15:43:27 2016


Copyright (c) 1982, 2010, Oracle.  All rights reserved.


ERROR:
ORA-12541: TNS: 无监听程序




请输入username:

启动监听

[oracle@hqw root]$ lsnrctl start


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-DEC-2014 16:29:27


Copyright (c) 1991, 2005, Oracle.  All rights reserved.


Starting /home/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hqw.net)(PORT=1521)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                12-DEC-2014 16:29:29
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /home/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hqw.net)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@hqw root]$ 

C:\Users\Administrator>sqlplus scott/scott@192.168.11.2:1521/orcl


SQL*Plus: Release 11.2.0.1.0 Production on 星期三 3月 16 15:44:48 2016


Copyright (c) 1982, 2010, Oracle.  All rights reserved.




连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> select * from dept;


    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON


SQL>

三、查看监听配置

[oracle@hqw root]$ cat /home/app/oracle/product/10.2.0/db_1/network/admin/listener.ora 
# listener.ora Network Configuration File: /home/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hqw.net)(PORT = 1521))
    )
  )


[oracle@hqw root]$ cat /home/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora 
# tnsnames.ora Network Configuration File: /home/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hqw.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


[oracle@hqw root]$