记一次Oracle无法动态注册问题

listener.ora内容如下：

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

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

    )
  )

[oracle@localhost admin]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
172.16.90.57            orcl.dlt   dbserver2   
::1             localhost6.localdomain6 localhost6

数据库启动后一直无法动态注册。

配置为静态注册：
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
        (GLOBAL_DBNAME =orcl)
        (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
        (SID_NAME =orcl)
    )
 
  )
 
远程客户端可以登录。

郁闷。。。。呀

[oracle@localhost admin]$ hostname
localhost.localdomain

机器名变了，我这台机器是从同一台机器中复制拷贝来的虚拟机，与原虚拟机同名，被VM给改了名。

 

vi /etc/sysconfig/network
修改：
HOSTNAME=orcl.dlt2

修改listener.ora文件中的orcl.dlt为orcl.dlt2

tnsnames.ora文件中的也要修改

 

/ect/hosts中增加：

172.16...            orcl.dlt2

 

[root@localhost ~]# reboot

Oracle动态注册成功！

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/195110/viewspace-713791/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/195110/viewspace-713791/