仓酷云

标题: MYSQL教程之oracle 10G 安装 for Linux86 [打印本页]

作者: 飘飘悠悠 时间: 2015-1-16 22:41
标题: MYSQL教程之oracle 10G 安装 for Linux86
曾经的功能列表可能会迅速变得过时了。而且，有些功能对有的应用程序非常重要，但是对别的应用程序则不一定。oracleConfiguringLinuxfortheInstallationofOracleDatabase10gPurpose
Inthislesson,youlearnhowtoconfigureLinuxandpreparefortheinstallationofOracleDatabase10g.
Topics
Thislessoncoversthefollowingtopics:

OverviewPrerequisitesCheckingtheHardwareRequirementsConfiguringtheKernelandCreatingtheoracleUser
ViewingScreenshots
Placethecursoronthisicontodisplayallthescreenshotsinthelesson.Youcanalsoplacethecursoroneachindividualiconinthefollowingstepstoseeonlythescreenshotthatisassociatedwiththatstep.
Overview
BacktoList

ThelessonpreparestheLinuxoperatingsystemfortheinstallationofOracleDatabase10g.

Prerequisites
BacktoTopicList

Beforestartingthislesson,youshouldhave:

1.
InstalledanOracleDatabase10gcertifiedversionofLinuxonaplatformcertifiedforthatversionofLinux.Toseethelatestcertificationinformation,useMetalinkandselectCertify&Availability.YoucanalsouseOTN.

CheckingtheHardwareRequirements
BacktoTopicList

ThesystemonwhichyouinstallLinuxmustmeetthefollowingrequirements:

512MBofphysicalrandomaccessmemory(RAM)

1GBofswapspace(ortwicethesizeofRAM)

SwapspacebetweenoneandtwotimesthesizeofRAM(onsystemswith2GBormoreofRAM)

400MBofdiskspaceinthe/tmpdirectory

2.1GBofdiskspacefortheOraclesoftwareandSampleSchemaDatabase

ConfiguringtheKernelandCreatingtheoracleUser
BacktoTopicList

Toconfigurethesystem,followthesesteps(writtenforBourne,Korn,andbashshells):

1.
Openaterminalwindowandloginastherootuser.

2.
ThefollowinglocalUNIXgroupsandusermustexistonthesystem:

Groups:oinstallanddba
User:oracle

Optionally,theopergroupcanbecreated.

Group:oper

Wenowcreatethethreegroupsoinstall,dba,andoper:

/usr/sbin/groupaddoinstall/usr/sbin/groupadddba/usr/sbin/groupaddoper

3.
Createtheoperatingsystemuseroracle:

/usr/sbin/useradd-goinstall-Gdba,operoracle

4.
Enterthefollowingcommandtosetthepasswordoftheoracleuser:

/usr/bin/passwdoracle

5.
Withaneditorofyourchoosing,open/home/oracle/.bash_profile.Ifyouareusinganothershell,pleaseaddtheentriestotheappropriatefile.

umask022PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/binLD_LIBRARY_PATH=/usr/lib:/usr/X11R6/libORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1ORACLE_SID=orclPATH=$ORACLE_HOME/bin:$PATHexportPATHLD_LIBRARY_PATHexportORACLE_BASEORACLE_HOMEORACLE_SID

6.
Createthedirectoryforthesoftwareinstallationandassignownershiptooracle:oinstall.Intheexample,youuse/u01/app/oracle.

mkdir-p/u01/app/oraclechown-Roracle:oinstall/u01/appchmod-R775/u01/app

7.
Setrequiredkernelparameters:

ParameterValue---------------------------------------------kernel.semmsl250kernel.semmns3200kernel.semopm100kernel.semmni128kernel.shmall2097152kernel.shmmax2147483648kernel.shmmni4096fs.file-max65536net.ipv4.ip_local_port_range102465000

Openthe/etc/sysctl.conffileinanytexteditorandaddlinessimilartothefollowing:

kernel.sem=25032000100128
kernel.shmall=2097152
kernel.shmmax=2147483648
kernel.shmmni=4096
fs.file-max=65536
net.ipv4.ip_local_port_range=102465000

Withspecifiedvaluesfortheseparametersinthe/etc/sysctl.conffile,thevaluespersistwhenyourebootthesystem.

8.
Thekernelchangesmadepreviouslytakeeffectwitheachreboot.

Issuethiscommandtosetthekernelparameters:

/sbin/sysctl-p

9.
Loginasoperatingsystemuseroracle.YoumustinstallthesoftwarefromanXWindowSystemworkstation,anXterminal,oraPCorothersystemwithXserversoftwareinstalled.

InstallingOracleDatabase10gonLinuxPurpose
Inthislesson,youlearnhowtoinstallOracleDatabase10gonLinux.
Topics
Thislessoncoversthefollowingtopics:

OverviewPrerequisitesInstallingOracleDatabase10gonLinux
ViewingScreenshots
Placethecursoronthisicontodisplayallthescreenshotsinthelesson.Youcanalsoplacethecursoroneachindividualiconinthefollowingstepstoseeonlythescreenshotthatisassociatedwiththatstep.
Overview
BacktoList

UsingtheOracleUniversalInstaller,youinstalltheOracleDatabase10gsoftwareandcreateadatabase.

Prerequisites
BacktoTopicList

Beforestartingthislesson,youshouldhave:

1.
CompletedtheConfiguringLinuxfortheInstallationofOracleDatabase10glesson.

InstallingOracleDatabase10gonLinux
BacktoTopicList

ToinstalltheOraclesoftware,youmustusetheGUIinstaller.

1.
LogintotheLinuxboxasuseroracleandmounttheOracleDatabase10gCD.ChangedirectorytotheCDandexecutethescript/mnt/cdrom/runInstallerfromyourhomedirectory:

/mnt/cdrom/runInstaller

2.
AttheWelcomewindow,clickNext.

3.
YouneedtospecifyyourInventorydirectory.Thelocationshouldbesetto/u01/app/oracle/oraInventory.AcceptthedefaultOperatingSystemgroupname,oinstall.ThenclickNext.

4.
Thefollowingwindowappears.Leavethiswindowopen.

5.
YouneedtoexecuteorainstRoot.shastherootuser.Openaterminalwindowandenterthefollowingcommands:

su<rootpassword>cd/u01/app/oracle/oraInventory./orainstRoot.shexitexit

6.
SwitchbacktotheUniversalInstallerwindowandclickContinue.

7.
AttheSpecifyFileLocationswindow,changethepathto/u01/app/oracle/product/10.1.0/db_1.ThenclickNext.

8.
MakesuretheInstallationTypeEnterpriseEditionisselectedandclickNext.

9.
Theinstallernowverifiesthatthesystemmeetsalltheminimumrequirementsforinstallingandconfiguringthechosenproduct.Pleasecorrectanyreportedissuesbeforecontinuing.Whenthechecksuccessfullycompletes,clickNext.

10.
Youwanttocreateastarterdatabase.MakesurethatCreateastarterdatabaseandGeneralPurposearebothselected.ThenclickNext.

11.
Enterorcl.oracle.comintheGlobalDatabaseNamefield,andselecttheCreatedatabasewithexampleschemascheckbox.ThenclickNext.Ifyouplantoperformanyofthemultilinguallessons,youshouldselectUnicodestandardUTF-8AL32UTF8asthedatabasecharacterset.

12.
TheSelectDatabaseManagementOptionwindowenablesyoutochoosebetweenDatabaseControlorGridControlofyourdatabase.Inthisexample,youacceptthedefault,whichisDatabaseControl.ClickNext.

13.
Specifythedatabasefilelocationas/u01/app/oracle/oradataandclickNext.

14.
IntheSpecifyBackupandRecoveryOptionswindow,youdonotwanttoenableautomatedbackupsatthistime.AcceptthedefaultandclickNext.

15.
Enterandconfirmapasswordforallaccounts,andthenclickNext.

16.
ReviewtheSummarywindowtoverifywhatistobeinstalled.ThenclickInstall.

17.
Theprogresswindowappears.

18.
TheConfigurationAssistantswindowappears.

19.
Yourdatabaseisnowbeingcreated.

20.
Whenthedatabaseiscreated,clickOK.

21.
WhentheSetupPrivilegeswindowappears,openanewterminalwindow.

22.
Youneedtoexecuteroot.shastherootuser.Fromyourterminalwindow,enterthefollowingcommands:

cd$ORACLE_BASE/product/10.1.0/db_1su<rootpassword>./root.shexitexit

23.
TheEndofInstallationsummaryappears.Theportsshowninthesummarycanbefoundin$ORACLE_BASE/product/10.1.0/db_1/portlist.ini.ClickOK.

24.
ClickYestoexit.

Placethecursoronthisicontohideallscreenshots.
每个人都在使用它。MySQL是开源LAMP组合的一个标准组件：Linux、Apache、MySQL和Perl/PHP。根据Evans的调查，LAMP组合的迅速推广很大程度上代表着MySQL的被广泛接受。

作者: 只想知道 时间: 2015-1-19 21:18
无法深入到数据库系统层面去了解和探究

作者: 柔情似水 时间: 2015-1-26 22:35
如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。

作者: 山那边是海 时间: 2015-2-4 21:10
对于微软系列的东西除了一遍遍尝试还真没有太好的办法

作者: 愤怒的大鸟 时间: 2015-2-10 11:06
如果是将来做数据库的开发设计，就应该详细学习T-SQL的各种细节，包括T-SQL的程序设计、存储过程、触发器以及具体使用某个开发语言来访问数据库。

作者: 因胸联盟 时间: 2015-3-1 09:42
总感觉自己还是不会SQL

作者: 再见西城 时间: 2015-3-10 13:09
对于微软系列的东西除了一遍遍尝试还真没有太好的办法

作者: 小魔女 时间: 2015-3-17 08:08
相信各位对数据库和怎么样学习数据库都有一些经验和看法，也会有人走了一些弯路总结出自己的经验来，希望大家能把各自的看法和经验拿出来分享，给别人一份帮助，给自己一份快乐

作者: 灵魂腐蚀 时间: 2015-3-24 02:59
至于淘汰的问题，只能说在你的项目周期之内，微软应该都不会倒闭。

欢迎光临仓酷云 (http://ckuyun.com/)