这里可以选择一种适合你的数据库模版一般我们选第一种通用的数据库模版如果你需要使用数据仓库则可以使用选择数据仓库的模版进行安装确认后按Next进入下一步
这一步是确认Oraclei的SID和全局数据库的名字SID的值我们在环境变量中已经设好了所以这里就自动显示了全局数据库名(Global Database Name)我们可以也指定成和SID的值相同确认后按Next进入下一步
前面我们提到了数据库的字符类型在数据库超作中是很关键的这一步就是设置数据库的字符集前面我们设置的是NLS_LANG=american_americaZHSGBK所以我们选择Simplifiled Chinese ZHSGBK按Next进入下一步
因为我们在前面选择了Enterprise的版本进行安装系统会安装Oracle Web Server安装Oracle Web Server需要使用JDK我们使用Browse按钮把前面安装JDK的目录指定好以便系统能在安装过程中找到需要的应用程序确认按Next进入下一步
进行完所有选择后系统会给出一个安装概要这里列举了你选择安装的组件确认你要安装的东西都在列表内后安Install钮进行安装如果不需要安装其它的程序则按Exit退出安装界面
Oracle的安装速度视服务器的性能一般来说需要装分钟的时间在安装过程中可能会有对话框弹出对话框内会有一些需要root运行的命令要求你执行这时候另外开一个控制台窗口su成root并运行提示框内的命令运行完毕后按确定继续安装
安装完数据库后系统会运行配置工具对系统进行网络和数据库的配置配置完成后系统会自动启动数据库并开启Oracle Web Server所有配置完后按Next完成安装
如果一切正常OUI会出现The Installation Of Oraclei Database Was successful的字样这表明你的Oraclei数据库安装正常了如果需要安装其它的内容按Next Install钮进行其它内容的安装否则按Exit退出安装
使用Oracle i 数据库
安装完毕后Oracle数据库会自动启动下面我们用实际超作来说明一下Oracle i数据库的启动和关闭
以oracle用户登陆数据库开个控制台窗口
关闭Oracle i 数据库
[oracle@wing /oracle]$ sqlplus / as sysdba //以sysdba用户登陆数据库
SQL*Plus: Release Production on Wed Jul ::
(c) Copyright Oracle Corporation All rights reserved
Connected to:
Oraclei Enterprise Edition Release Production
With the Partitioning option
JServer Release Production
运行shudown命令关闭数据库
SQL> shutdown
Database closed
Database dismounted
ORACLE instance shut down
SQL>
启动Oracle i 数据库
[oracle@wing bin]$ sqlplus / as sysdba
SQL*Plus: Release Production on Wed Jul ::
(c) Copyright Oracle Corporation All rights reserved
Connected to an idle instance
SQL> startup
ORACLE instance started
Total System Global Area bytes
Fixed Size bytes
Variable Size bytes
Database Buffers bytes
Redo Buffers bytes
Database mounted
Database opened
SQL>
启动Oracle i监听程序
Oracle的监听程序主要是为客户端的连接提供接口
[oracle@wing bin]$ lsnrctl
LSNRCTL for Linux: Version Production on JUL ::
Copyright (c) Oracle Corporation All rights reserved
Welcome to LSNRCTL type help for information
LSNRCTL> start
Starting /oracle/product//bin/tnslsnr: please wait
TNSLSNR for Linux: Version Production
System parameter file is /oracle/product//network/admin/listenerora
Log messages written to /oracle/product//network/log/listenerlog
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version Production
Start Date JUL ::
Uptime days hr min sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/product//network/admin/listenerora
Listener Log File /oracle/product//network/log/listenerlog
Listening Endpoints Summary
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=)))
Services Summary
Service PLSExtProc has instance(s)
Instance PLSExtProc status UNKNOWN has handler(s) for this service
Service oracle has instance(s)
Instance oracle status UNKNOWN has handler(s) for this service
The command completed successfully
LSNRCTL>
关闭Oracle i监听程序
[oracle@wing bin]$ lsnrctl
LSNRCTL for Linux: Version Production on JUL ::
Copyright (c) Oracle Corporation All rights reserved
Welcome to LSNRCTL type help for information
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
LSNRCTL>
关闭Oracle Web Server
cd $ORACLE_HOME/Apache/Apache/bin
/stopJServsh
/oracle/product//Apache/Apache/bin/apachectl stop: httpd stopped
启动Oracle Web Server
cd $ORACLE_HOME/Apache/Apache/bin[oracle@wing bin]$ /startJServsh
/oracle/product//Apache/Apache/bin/apachectl start: httpd started
启动Oracle Web Server后默认的端口号是
在客户端浏览器地址栏输入
如果浏览器出现以下界面则表示Oracle Web Server运行正常
//gif >