OracleDatabase实例创建[原创]

《OracleDatabase实例创建[原创]》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、信息技术最佳实践数据库实例创建数据库配置篇张博强Author:CreationDate:LastUpdated:DocumentRef:August1&2015August18,20151.0Version:Approvals:OQQQOAMMQQCopyNumberDocumentControlChangeRecord18-Aug-15Boqiang.ZhangLONoPreviousDocumentDateAuthorVersionChangeReferenceReviewersN

2、amePositionDistribution1LibraryMasterProjectLibrary2ProjectManager34CopyNo・NameLocationNoteToHolders:Ifyoureceiveanelectroniccopyofthisdocumentandprint让out,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.Ifyoureceiveahardcopyofthisdocument

3、,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.ContentsDocumentControlxviii1.环境配置21.1.服务器信息21.2.启动VNC21.3.添加X-Window访问权限22.数据库实例创建42.1.数据库创建42.2.创建监听112.3.修改local_listener163.数据库登录验证183.1.配置tnsname.ora1832背录验证181.OpenandClosedIssuesforthisDeliverable2

4、0OpenIssues20ClosedIssues201.环境配置1.1.服务器信息IP地址机器用途用户名密码10.1.11.111DEVTEST环境数据库root/rootl23fmwtest/fmwtestvncpassword：1234561.2.启动VNC以root川户建立至服务器的ssh连接，使川如下命令启动vnc#vncserver:1如果是初次启动，需要输入vnc登录密码，这里已经设置好vnc登录密码为12345613添加X-Window访问权限使用vncviewerS录，登录信息如图，点击OkVNCViewer

5、:ConnectionDetails>彳CServer:Encryption:LetServerChoose(Default)▼▼About...Options…(OK1CancelPassword:123456，点击Ok完成登录VNCAuthentication:10.1.11.111:1[NoEncryption]康动终端，在终端下运行如下命令开始X-Window访问权限FileEditViewSearchTerminalHelp[root@wandatest~]#xhost+accesscontroldisabled,cl

6、ientscanconnectfromanyhost[root@wandatest-]#

7、1.数据库实例创建注：本文档以OADEV实例为例进行创建，后续如需要创建其它实例只需确定与变更文档中的实例名与端口即可2.1.数据库创建2.1.1.切换至数据库用户fmwtest#su・fmwtest2.1.2.运行数据库配置向导$dbcaDatabaseOperation数据库操作选项选择界而，选择CreateDatabase,点击NextDatabaseConfigurationAssistant-Welcome-Step1of6Dat

8、abaseOperationDATABASE丫丫丫丫丫)DaiaDaseOperationUyionModeHNpSelecttheoperationthatyouwanttoperform®CreateDatabaseC)ConfigureDatabaseOptions.?ODatTabaseC)ManageTemplatesCManagePluggableDatabasesHext>(_CancciCreateMode选择Advanced，点击NextHelpvQ&c衣

9、Be">£inisHCancelDatabaseTem

10、plate保留默认，点击NextDatabaseConfigurationAssistant-CreateDatabase-Step3of14DatabaseTemplateDATABASECmtionModeDatad>ascTemplateTemplates