Oracle10g.CentOS6安装_遇到的问题（02）

1、创建了一个 数据库实例之后，需要配置 listener.ora，不然那个实例默认是不监听的

　1.1、我修改了 这个文件，记录下来：

　　（1）修改前的：（原来 安装好Oracle后就存在的，没有动过的）

# listener.ora Network Configuration File: /opt/oracle/102/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/102)
      (PROGRAM = extproc)
    )
  )

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

　　（2）修改后的：

# listener.ora Network Configuration File: /opt/oracle/102/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/102)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = zzorcl)
      (ORACLE_HOME = /opt/oracle/102)
      (GLOBAL_DBNAME = zzorcl)
    )
  )

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

　　　　ZC：暂时还不太明白里面的含义，只是仿照网页上搜索到的写了一下，暂时只要做到能用就行...

 

2、新建的实例 默认是不运行的状态(idle)，需要startup操作后 才能 做 "create user"等的操作

3、

4、

5、