Oracle-win7环境用命令启动数据库过程

在笔记本win7 64位系统上安装了Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
开机后用命令启动数据过程：
1. 打开CMD窗口
    1> win + r 快速打开运行窗口，输出"CMD",确定
    2> "开始" --> "运行"，输出"CMD",确定


2. 查看监听服务是否启动 
    >lsnrctl [ start | stop | status ]
        lsnrctl命令详细用法及其他参数 >lsnrctl help
    这个命令与"计算机管理" --> "服务与应用程序" --> "服务" --> "OracleOraDb11g_home1TNSListener" 状态对应


3. 查看OracleServiceORCL服务 
    >net [start | stop ] OracleServiceOrcl
         net命令详细用法及其他参数 >net help
    这个命令与"计算机管理" --> "服务与应用程序" --> "服务" --> "OracleServiceORCL" 状态对应


4. 使用sqlplus连接数据库，并启动数据库
    C:\Users\lzhpc>sqlplus /nolog
      SQL> conn sys/orcl11R2@orcl as sysdba
           ERROR:ORA-28547: 连接服务器失败, 可能是 Oracle Net 管理错误
      SQL> conn sys/orcl11R2 as sysdba
           已连接到空闲例程。
      SQL> startup
           ORACLE 例程已经启动。
           Total System Global Area 1636814848 bytes
           Fixed Size                  2176248 bytes
           Variable Size            1056967432 bytes
           Database Buffers          570425344 bytes
           Redo Buffers                7245824 bytes
          数据库装载完毕。
          数据库已经打开。
      SQL> exit


注：在启动中有其他问题，大多与D:\app\lzhpc\product\11.2.0\dbhome_1\NETWORK\ADMIN下的listener.ora和tnsnames.ora文件有关：
######listener.ora############
# listener.ora Network Configuration File: D:\app\lzhpc\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)      # 本行有变动
      (ORACLE_HOME = D:\app\lzhpc\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\lzhpc\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = orcl))   # 本行有变动
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  # 本行有变动
    )
  )


ADR_BASE_LISTENER = D:\app\lzhpc


######tnsnames.ora############
# tnsnames.ora Network Configuration File: D:\app\lzhpc\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  # 本行有变动


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  # 本行有变动
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)   # 本行有变动
    )
  )