oracle连接遇到的问题

oracle 启动监听服务
lsnrctl start
停止监听服务
lsnrctl stop

ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
需要配置oracle服务器(你安装oracle服务的机器)中listener.ora文件
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =

      (GLOBAL_DBNAME = orcl)

      (SID_NAME = orcl)

    )  
)

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

ADR_BASE_LISTENER = D:\oracle

启动监听服务后还需开启oracle服务
su - oracle
sqlplus '/as sysdba'
sql> startup

如果未开启oracle服务，可能会有ora-01034和27101错误
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available &<60;
的说明，解释为ORACLE_HOME或者ORACLE_SID设置不正确。
但检查bash_profile以后没有发现错误;
错误点，沒有开启oracle服务；