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的被广泛接受。

无法深入到数据库系统层面去了解和探究

如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。

对于微软系列的东西除了一遍遍尝试还真没有太好的办法

如果是将来做数据库的开发设计，就应该详细学习T-SQL的各种细节，包括T-SQL的程序设计、存储过程、触发器以及具体使用某个开发语言来访问数据库。

总感觉自己还是不会SQL

对于微软系列的东西除了一遍遍尝试还真没有太好的办法

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

至于淘汰的问题，只能说在你的项目周期之内，微软应该都不会倒闭。