OracleDatabase实例创建[原创]

1、信息技术最佳实践 数据库实例创建 数据库配置篇张博强author:creation date:last updated:document ref:august 1& 2015august 18, 20151.0version:approvals: <approvcr 1><approvcr 2>oq qqoa mm qqcopy numberdocument controlchange record18-aug-15boqiang.zhanglono previous documentdateauthorversion change referencerevie

2、wersnamepositiondistribution1library masterproject library2project manager34copy no namelocationnote to holders:if you receive an electronic copy of this document and print 让 out, please write your name on the equivalent of the cover page, for document control purposes.if you receive a hard copy of

3、this document, please write your name on the front cover, for document control purposes.contentsdocument controlxviii1. 环境配置21.1. 服务器信息21.2. 启动 vnc21.3. 添加x-window访问权限22. 数据库实例创建42.1. 数据库创建42.2. 创建监听112.3. 修改 local_listener163. 数据库登录验证183.1. 配置 tnsname.ora1832背录验证181. open and closed issues for this

4、 deliverable20open issues20closed issues201. 环境配置1.1.服务器信息ip地址机器用途用户名密码10.1.11.111devtest 环境 数据库root/rootl23 fmwtest / fmwtest vncpassword：1234561.2. 启动vnc以root川户建立至服务器的ssh连接，使川如下命令启动vnc#vncserver :1如果是初次启动，需要输入vnc登录密码，这里已经设置好vnc登录密码为12345613添加x-window访问权限使用vncviewers录，登录信息如图，点击okvnc viewer : connec

5、tion details> 彳cserver:encryption: let server choose (default)about.optio ns (ok 1cancelpassword: 123456，点击ok完成登录vnc authentication: 10.1.11.111:1 no encryption康动终端，在终端下运行如下命令开始x-window访问权限file edit view search terminal helprootwandatest # xhost +access control disabled, clients can connect from

6、any host rootwandatest -# |2. 数据库实例创建注：本文档以oadev实例为例进行创建，后续如需要创建其它实例只需确定与变更文 档中的实例名与端口即可2.1.数据库创建2.1.1. 切换至数据库用户fmwtest#su fmwtest2.1.2. 运行数据库配置向导$dbcadatabase operation数据库操作选项选择界而，选择create database,点击nextdatabase configuration assistant - welcome - step 1 of 6database operationdatabase丫丫丫丫丫)daiadas

7、e operationuy ion modehnpselect the operation that you want to perform® create databasec)configure database options .? odattabasec)manage templatesc manage pluggable databaseshext >( _canccicreate mode选择 advanced，点击 nexthelpv q&c衣 | be" >£inishcanceldatabase template保留默认，点击n

8、extdatabase configuration assistant - create database - step 3 of 14database templatedatabasecmtion modedatad>asc templatetemplates that include datafiles contain pre-creaxed databases. they allowyou to create a new database in minutes, as opposed to an hour or more. use templates without datafil

9、es only vuien necessary, such as vshen you need to change attributes like block size, vuiich cannot be altered after database creation.丫丫丫丫丫丫丫丫丫丫)database iderhificatioriselecttemplateincludes datafilesgeneral purpose or transaction processingyesocustom databasenoodatawarehouseyesselect a template f

10、or your database.show details.旦elp< back | next >canceldatabase identificationglobal database name： oadevsid： oadev不勾选create as container database,点击nextmanagement option取消勾选，点击nextdatabase credentials选择： use the same administrative password for all accountspassword: managerl 0confirm password

11、: manager!0点击nextdatabase configuration assistant - create database - step 6 of 14database credentialsoraui-wdatabasedatabase operationcreation modedatabase templatefor security reasons, you must specify passwords for the following user accounts in the new database.use different administrative passw

12、ordsdatabase identificmionodtions9/ database ci edent ialsuser namepasswordconfirm passwordsyssystem丫 丫 丫 丫 丫 丫 丫 7sioraa© lomonsdatabase optionsinitialization parameterscreation optionsprerequisite checkssummaryprogress pagefinish*? u$c the same administrative password for all accounts passwor

13、d:會confirm password: !< "ck | 理n >network configuration取消勾选，点击nextstorage location収消specify fast recovery area勾选，其它保留默认，点击nextdatabase option保留默认，点击nextin让ializaion settings设置 memory size (sg a and pc a) : 4096勾选use automatic memory managementdatabase configuration assistant create databa

14、se step 10 of 15initialization parametersepnncciion moaeoracle- odatabasei 盗丫 丫 丫 丫 丫 丫 丫 丫 r十ycrcation modedatabase templatedatabase identificationmanagement optionsdatabase credeniialsnetwork configurationstorage loc&tionsdatabase optionsinitialization paiaineteiscreation omionsmem orysizing c

15、haracter sets:typical settingsmemory size (sca and pca) 4096 mbpercentage:6 xuse automatic memory managementcustom settings250 mb64440 mbshojymemory distribution.all initialization parameters .help<back nexr >cancel点击character sets tab几 设置数据库字符集选中use unicode (al32utf8),其它默认，点击nextdatabase conf

16、iguration assistant - create database - step 10 of 15initialization parametersoracle*database丫丫丫丫丫database templatedatabase identificationmanagement optionsdatabase credentialsnetwork configurationmmory 'ring character sets connection modeo use the defaultthe default character set for this datab

17、ase is based on the language setting of this operating system: we8mswin1252.9 3)use unicode (al32utf8)setting character set to unicode (al32utf8) enables you to store multiple language groups.()choose from the list of character setsy storage location$d<itcist ooiionsy initialization paranieters c

18、reation odyionsq at abase character snational character set-|al16utf1£- unicode utf丄6 universal character setdefault language:default territorx：| americanunited statescancel &all inhiahzation parameters旦elpcreate option保留默认，点击nextsummary在该界面重点关注红椎标注出的属性值，是否设宜正确，点击finishprogress page进入数据库创建进

19、度界面finish该界面的信息冇必耍记录下來后续使川2.2.创建监听221 切换至f m wtest用户#su - fmwtest2.2.2.运行监听配置向导$netcawelcome选择listener configuration,丿!击nextlistener configuration选择add,点击nextlistener name： oadev,点击nextfor remote connections to be made to your oracle database you must have at least one oracle net listener. enter the

20、 name of the listener you want tocreate:listener name:qadevicancelnext保留默认点击next选择use another port number： 1592, 点击nextwhich tcp/ip port number should the listener use? the port number selected should nol be used by any other software on this computer.use the standard port number of 1521* use anothe

21、r port number:|1592|cancelhelp j< backwould you like to configure another listener? 选择no,点击nextoracle net configuration assistant: listener configuration, more listen xwould you like to con figure another liste n”?<8 no宦yqscancel i help i匕 back uext>)select a listener you want to start选择oad

22、ev,点击nextselect a listener you warn to start:也:二二二二:二二:二习« back next ：$> jconfigure complete点击nextoraclecancel help )listener uonfiguration complete!y eack |ljcxtwelcome进入welcome界uh,点击finish结束配置2.3. 修改local_listener2.3.1 修改o racle sid 值使用fmwtestffl丿'1修改变量or acle_sid值为o ade v$export oracl

23、e_sid=oadev以sysdba登录数据fmwtestcawandatest $ sqlpluj /nologsql*plus: release 12.1.0.2.0 production on tue aug 18 16:33:52 2015copyright (c) 1982r 2014, oracle. all rights reserved.sql> conn /as sysdba|2.3.2. 修改数据库parameter iocal listener 使用alter system命令修改localjistener参数sql> alter system set loc

24、al_listener='10.1.11.111:1592' scope=spfile;2.33.重启数据库sql> shutdown immediate;database closed.database dismounted.oracle instance shut down.sql> startuporacle instance started.4294967296 bytes4505496 bytes 2533359720 bytes 1744830464 bytes 12271616 bytestotal system global areafixed si

25、zevariable size 1database buffersredo buffersdatabase mounted.database opened.sql> |2.3.4.检查参数配置结果sql> show parameter local listenernametypevaluelocal listenerstring1o.l11.111：1592sql> |_3数据库登录验证3.1 配置tnsname.ora配置已安装好的plsql工具的tns文件，添加至oadev数据库的链接信息*黒oadev =(description =(address = (protocol = tcp) (host = 10.1.1l111) (port = 1592)(connect_data =(server = dedicated)(service_name = oadev)3.2.登录验证打开plsq developer t 具username: systempassword: managerl 0database： oadev 点击ok进行数据库链接背录plsql developer登录成功界面file project edit session debug tools