在笔记本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) # 本行有变动
)
)
开机后用命令启动数据过程:
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) # 本行有变动
)
)