MYSQL教程之oracle 10G 安装 for Linux86
曾经的功能列表可能会迅速变得过时了。而且，有些功能对有的应用程序非常重要，但是对别的应用程序则不一定。oracleConfiguringLinuxfortheInstallationofOracleDatabase10gPurposeInthislesson,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的被广泛接受。 无法深入到数据库系统层面去了解和探究 如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。 对于微软系列的东西除了一遍遍尝试还真没有太好的办法 如果是将来做数据库的开发设计，就应该详细学习T-SQL的各种细节，包括T-SQL的程序设计、存储过程、触发器以及具体使用某个开发语言来访问数据库。 总感觉自己还是不会SQL 对于微软系列的东西除了一遍遍尝试还真没有太好的办法 相信各位对数据库和怎么样学习数据库都有一些经验和看法，也会有人走了一些弯路总结出自己的经验来，希望大家能把各自的看法和经验拿出来分享，给别人一份帮助，给自己一份快乐 至于淘汰的问题，只能说在你的项目周期之内，微软应该都不会倒闭。
页:
[1]