从零安装oracle，让童鞋们不再困惑(三)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
)
)

B:sqlnet.ora
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

C:tnsnames.ora
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SHZQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = shzq)
)
)

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

8.oracle安装完成，系统自带的用户和密码

//internal/oracle
// sys/change_on_install
//system/manager
//scott/tiger
//sysman/oem_temp

三、使用PLSQL Developer 管理linux Oracle服务器
1.登陆

2.使用

3.功能

说明：
//1.本文不在于重在oracle安装，而是oracle安装过程中的排错
//2.安装后的调试（本文章只对此做技术支持MAIL: linuxhzg#qq.com 将#换为@）
//3.客户端和软件的使用
//4.下次更新tomcat应用连接oracle数据库
//5.仅作为推荐《Oracle Database 11g数据库管理艺术》给读者，无任何广告之意！