Oracle11g安装教程以及解决问题方法

安装教程可参考此博主
https://blog.csdn.net/u012039040/article/details/131454311?spm=1001.2014.3001.5506

后续遇到的问题：
1.服务器本机可以访问，但是telnet 1521 不通
修改host文件即可
2.登陆遇到ora-12514监听程序当前无法识别连接描述符中请求的服务报错
修改listener.ora文件

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    #######新增静态数据库这一段
	(SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = orcl)
     )
     ######
  )

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

ADR_BASE_LISTENER = D:\app\Administrator

常用命令
lsnrctl status
lsnrctl stop
lsnrctl start
sqlplus / as sysdba
配置oracle数据库完成