oracle修改用户名密码 以及初始化监听配置

sqlplus / as sysdba;


1.alter user sys identified by huozhe
2.grant connect to sys identified by 123456
show parameter instance_name;查看当前数据库实例

数据库修改密码：https://www.cnblogs.com/wy-ls/p/9284192.html
https://blog.csdn.net/qq_16183731/article/details/83864811
重启数据库：http://blog.sina.com.cn/s/blog_15f75e3210102wk1k.html

oracle配置监听
修改：listener.ora
原来

# listener.ora Network Configuration File: C:\app1\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.150.10)(PORT = 1521))
  )

ADR_BASE_LISTENER = C:\app1\Administrator

修改为

# listener.ora Network Configuration File: C:\app1\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
            (GLOBAL_DBNAME = orcl)
            (ORACLE_HOME = C:\app1\Administrator\product\11.2.0\dbhome_1)
            (SID_NAME = orcl)
        )
    )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.150.10)(PORT = 1521))
    )
  )

tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app1\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.150.10)(PORT = 1521))
    )
    (CONNECT_DATA =
	  (SID = orcl)
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )