Ubuntu104安裝Oracle11g及配置環(huán)境

Ubuntu16.04安裝Oraclellg及配置環(huán)境2016年12月21日星期三，最后一次更新。我遇到的第一個(gè)問題是本機(jī)系統(tǒng)和虛擬機(jī)系統(tǒng)不能分享文件，即無法從本機(jī)復(fù)制文件到虛擬機(jī)。原因是VmwareTools未安裝或受損。解決方案如下：點(diǎn)擊VMware菜單的-VM-InstallVmwareTools這時(shí)，在Ubuntu下會(huì)自動(dòng)加載Linux版的VMwareTools的安裝光盤鏡像。你會(huì)看到虛擬機(jī)的桌面上出現(xiàn)了一個(gè)名為VMwareTools的光盤圖標(biāo)，并且被自動(dòng)打開。其中包括VMwareTools-xxx-i386.rpm和VMwareTools-xxx.tar.gz兩個(gè)文件。把那個(gè).tar.gz文件拷貝而到桌面，右鍵菜單-解壓縮到此處。會(huì)自動(dòng)解壓為一個(gè)vmware-tools-distrib目錄。打開終端（系統(tǒng)的應(yīng)用程序菜單-附件-終端、或者Ctrl+Alt+T）依次執(zhí)行以下命令行：cdDesktopcdvmware-tools-distribsudo./vmware-install.pl（sudo是superuserdo的意思，即享有最高權(quán)限的超級(jí)用戶操作，回車后會(huì)提示輸入你的密碼，并且密碼不會(huì)顯示出來，表明你將以更高級(jí)權(quán)限執(zhí)行一個(gè)動(dòng)作一一安裝軟件；再次回車后安裝開始）經(jīng)過一番確認(rèn)回車后（相當(dāng)于在Windows里安裝軟件時(shí)所填答的諸多對(duì)話框，我們這里均采用缺省設(shè)置），直到最后出現(xiàn)“Enjoy——theVMwareteam”的字樣后，VMwareT001s終于安裝完成了。

重啟Ubuntu搞定。接下來開始做安裝Oracle的準(zhǔn)備工作：一、安裝JDK打開終端輸入以下命令sudoapt-getupdatesudoapt-getinstallopenjdk-8-jdk配置系統(tǒng)環(huán)境變量（以后的環(huán)境變量都是通過編輯/etc/profile文件實(shí)現(xiàn)的）cd/etcsudogeditprofile編輯/etc/profile文件，文件的末尾添加以下信息：exportJAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64exportJRE_HOME=${JAVA_HOME}/jreexportCLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/libexportPATH=${JAVA_HOME}/bin:$PATH單擊右上角的保存按鈕之后關(guān)閉窗口回到終端界面。使用source/etc/profile命令使剛才配置的信息生效。使用java-version命令進(jìn)行驗(yàn)證。yxg@ubuntu:/etc$source/etcyproftieyxg@ubuntu:/etc$java-versionopenjdkversion"laoill"openJDKRuntimeEnvironment(build1*s*o_Lii-8uiii-bi4-zubuntuo.is*04+z-bi4)OpenJDK64-BitServerVM(build2S.1mixednode)yxggubuntu;/etc5|二、安裝依賴包:sudoapt-getinstallautomake//成功sudoapt-getinstallautotools-dev//系統(tǒng)已經(jīng)安裝sudoapt-getinstallbinutils//只更新了一個(gè)文件，成功sudoapt-getinstallbzip2//系統(tǒng)已經(jīng)安裝sudoapt-getinstallelfutils//成功sudoapt-getinstall?*口2土//成功sudoapt-getinstallgawk//系統(tǒng)已經(jīng)安裝sudoapt-getinstallgcc//系統(tǒng)已經(jīng)安裝sudoapt-getinstallgcc-multilib//成功sudoapt-getinstallg++-multilib//成功

sudoapt-getinstallia32-libs//lib32ncurses5和lib32z1代替sudoapt-getinstall卜$卜//成功sudoapt-getinstallless//成功sudoapt-getinstalllesstif2sudoapt-getinstalllesstif2-dev/*這兩個(gè)包是32位包，需要換源安裝：sudo-icd/etc/apt/sources.list.decho“debhttp://old-releases.ubuntu/raringmainrestricteduniversemultiverse” >ia32-libs-raring.listapt-getupdateapt-getinstall+包名*/yxg@ubuntu:sudo-i「口dt/ubuntu cd/etc,/apt/sourcestlistedroot@ubuntu:/etc/apt/sourc&s?list,d#echoHdebhttp/old-releases^ubuntu+con/ubuntu/rartrgnatnrestrictedmultiverse"?LaS2-1tbs-raring.listrootgubuntu:/etc/apt/sQurc&srlist,d#apt-getupdateign:1http://old-releases.jbuntu.cora/ubunturaringinRel&aseGethttp://old'releases.ubuntu.cort/ubunturaringRelease[40-8kB]G&t:3http://old-releases.ubuntu.con/ubunturaringRelease.gpg[933B]Get14http：//old-releases.ubuntu.can/ubunturaring/nainandC4Packages[1,17&kB安裝成功之后再還原：rm/etc/apt/sources.list.d/ia32-libs-raring.listapt-getupdateexitsudoapt-getinstalllib32z1//系統(tǒng)已經(jīng)安裝sudoapt-getinstalllibaio1//成功sudoapt-getinstalllibaio-dev//成功sudoapt-getinstalllibc6-dev//系統(tǒng)已經(jīng)安裝sudoapt-getinstalllibc6-dev-i386//系統(tǒng)已經(jīng)安裝sudoapt-getinstalllibc6-i386〃系統(tǒng)已經(jīng)安裝sudoapt-getinstalllibelf-dev//成功sudoapt-getinstalllibltdl-dev//成功sudoapt-getinstalllibmotif4//成功sudoapt-getinstalllibodbcinstq4-1//成功sudoapt-getinstalllibodbcinstq4T:i386//成功sudoapt-getinstalllibpth-dev//成功sudoapt-getinstalllibpthread-stubs0//成功

sudoapt-getinstalllibpthread-stubs0-dev〃系統(tǒng)已經(jīng)安裝sudoapt-getinstalllibstdc++5〃成功sudoapt-getinstalllsb-cxx〃成功sudoapt-getinstallmake//系統(tǒng)已經(jīng)安裝sudoapt-getinstallopenssh-server//成功sudoapt-getinstallpdksh//成功sudoapt-getinstall討亞9口//成功sudoapt-getinstallrpm//系統(tǒng)已經(jīng)安裝sudoapt-getinstall$丫$$土2土//成功sudoapt-getinstallunixodbc//成功sudoapt-getinstallunixodbc-dev//成功sudoapt-getinstallunzip//系統(tǒng)已經(jīng)安裝sudoapt-getinstallx11-utils//系統(tǒng)已經(jīng)安裝sudoapt-getinstallzlibc//成功三、配置Oracle環(huán)境1、用以下命令檢查系統(tǒng)變量/sbin/sysctl-a|grepsemkernel*sen匚32000 1024909000 5日。 320&9kernel.Sfi_next_id=-1/sbin/sysctl-a|grepshmkerrel.shi_next_i.d=-1kerrel.shnirmtdforced=0kerrel.SiI=927743&9kerrel.shnnex=18446744073692774399kerrel*nni=4096vm.huge-tlbshgroup=0/sbin/sysctl-a|grepfile-max/sbin/sysctl-a|grepaio-max/sbin/sysctl-a|grepip_local_port_rangesysctL：pernissTonaenieoonKeynet.ipvo.connetitpv4Ap1ocalport^rante=327&S 50999

/sbin/sysctl-a|greprmem_defaultnet,coreLrmen_default=212952口e「ni￡￡iDndeniedonk。/sbin/sysctl-a|greprmem_maxsysctl:pernissionde-niedonnet.core.rmen_nax=212952sysctlipe「Fii￡siDndcriicd13n/sbin/sysctl-a|grepwmem_default/sbin/sysctl-a|grepwmem_max2、根據(jù)上面命令中得到的參數(shù)值在/etc/sysctl.conf中增加對(duì)應(yīng)數(shù)據(jù)cd/etc/sudogedit/etc/sysctl.conf〃注釋：gedit就是打開文件的命令，可以通過這個(gè)命令打開文件然后編輯并保存fs.aio-max-nr=65536fs.file-max=198237kernel.shmall=18446744073692774399kernel.shmmax=18446744073692774399kernel.shmmni=4096kernel.sem=32000102400000050032000net.ipv4.ip_local_port_range=3276860999net.core.rmem_default=212992net.core.rmem_max=212992net.core.wmem_default=212992net.core.wmem_max=212992

保存之后關(guān)掉這個(gè)窗口回到命令行終端：運(yùn)行以下命令更新內(nèi)核參數(shù)：sysctl-p添加對(duì)用戶的內(nèi)核限制：3、添加對(duì)yxg用戶的內(nèi)核限制在/etc/security/limits.conf文件中增加以下數(shù)據(jù),注:其中yxg是我ubuntu系統(tǒng)的普通用戶cd/etc/security/sudogeditlimits.conf打開文件之后在末尾加入以下幾行：yxgsoftnproc2047yxghardnproc16384yxgsoftnofile1024yxghardnofile65536yxgsoftstack10240保存之后關(guān)閉文件窗口。同樣的方法打開文件/etc/pam.d/login，增加以下行（有了就不用增加了）：sessionrequiredpam_limits.so同樣檢查/etc/pam.d/su，沒有以下行就自己加上：sessionrequiredpam_limits.so4、創(chuàng)建需要的文件夾mkdir/home/yxg/toolsmkdir/home/yxg/tools/oracle11gchmod577tools-R 〃給文件夾賦予權(quán)限5、為Oracle配置環(huán)境變量在/etc/profile中追加

exportORACLE_BASE=/home/yxg/tools/oracle11g//oracle安裝目錄，第4步創(chuàng)建的文件夾exportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1〃現(xiàn)在還看不到這個(gè)文件夾，在Oracle安裝過程中系統(tǒng)會(huì)自動(dòng)創(chuàng)建，后面安裝時(shí)選擇路徑要和這里設(shè)置的一致。Oracleba.se:Softwarelocation:/home/yxg/tools/oraclellg/liQnie/yxg/taah/oracleLlg/product/li,2.0/dbhaiTie_lOracleba.se:Softwarelocation:/fiome/yxg/tools/oraclellg/oradataexportORACLE_SID=orcl〃在安裝時(shí)會(huì)有一個(gè)設(shè)置的地方，默認(rèn)是orcl，也可以設(shè)置成其他Globaldatabasenime:exportORACLE_UNQNAME=orcl〃默認(rèn)字符集exportNLS_LANG=.AL32UTF8〃環(huán)境變量exportPATH=${PATH}:${ORACLE_HOME}/bin/:$ORACLE_HOME/lib64;6、欺騙oracle的安裝程序Oracle本身并不支持ubuntu來安裝，所以要進(jìn)行欺騙oracle的安裝程序（sudo執(zhí)行）：用root用戶mkdir/usr/lib64ln-s/etc/etc/rc.dln-s/lib/x86_64-linux-gnu/libgcc_s.so.1/lib64/ln-s/usr/bin/awk/bin/awkln-s/usr/bin/basename/bin/basenameln-s/usr/bin/rpm/bin/rpmln-s/usr/lib/x86_64-linux-gnu/libc_nonshared.a/usr/lib64/ln-s/usr/lib/x86_64-linux-gnu/libpthread_nonshared.a/usr/lib64/ln-s/usr/lib/x86_64-linux-gnu/libstdc++.so.6/lib64/ln-s/usr/lib/x86_64-linux-gnu/libstdc++.so.6/usr/lib64/echo'RedHatLinuxrelease5'>/etc/redhat-release最后這一步提示權(quán)限不夠，應(yīng)該是權(quán)限設(shè)置的問題

chown-Ryxg:yxg/etc,然后就可以了。/*大家要謹(jǐn)慎執(zhí)行這一步啊，這條命令是把/etc文件夾下的所有文件的所有權(quán)都賦給yxg組下的yxg用戶了，后面會(huì)造成很多麻煩。這里如果你也執(zhí)行了這一條那請(qǐng)立馬用以下命令改回來：chown-Rroot:root/etc*/四、終于到正式安裝Oracle啦復(fù)制Oracle安裝包至Uhome/yxg/tools/oracle11g §linux,x64_lLgatabase_Lof2.zip灌Iinux,x64lLgR2database2of2.ziporacl?11gVMwareWorkstation正在將交件“Mu%油4_llgR2_由VMwareWorkstation正在將交件“Mu%油4_llgR2_由ta位5已_232即簟制到虛捌機(jī)取消Titctt>pjmen1Mt)改?￡FileOperaHonsJreSPreparingPreparingtoco-py0Files(Qbytes)然后解壓：cd/home/yxg/tools/oracle11gunziplinux.x64_11gR2_database_1of2.zipunziplinux.x64_11gR2_database_2of2.zipcd/home/yxg/tools/oracle11g/databasechmod777runInstaller 〃賦予可讀可寫可執(zhí)行權(quán)限./runInstaller

gi3>ubuiituORAULE［竄DATABASEORACLe-U4加11：50PM空6777216installerf「”i/t^p/orginstallZB16-12-19_11checkingTempspact：nustbegreatercheckingEwapspace；nustbegreaterCheckingnonitor:nustbeconfiguredPassedPassedActualgi3>ubuiituORAULE［竄DATABASEORACLe-U4加11：50PM空6777216installerf「”i/t^p/orginstallZB16-12-19_11checkingTempspact：nustbegreatercheckingEwapspace；nustbegreaterCheckingnonitor:nustbeconfiguredPassedPassedActual1Preparingtolaunchoracleuniversalz.-.；.r/：.-50-45PMrPleasewdtt...yxgQubuntu:-/t0Dl￡/oraclellg/databa&e$QthanI2eme+Actual21Z5Shrthdin150MB-Actual2944NBtodisplayatleast25Gcolors.Onometookoracle11ginflatiiaFiles/ftlinflatiidFiles/ffyxg^ubuntuyxg也ubuntuyxgQubuntustarting…'"一「勺13,*rCheckingcheckingChecking6777216Prepartng-39-37PM.Startingb/11.2,0,1.0/1/Datt)/lK2*B+KB/l/Databasestall201fi-12-1911$*/runinstaller61MR■1MB□LorsPassedPassedActual1PerformfullDa.taba.seinstallationwithbasicconfiguration.Oraclebase;/horre/yxgjtools/oraclellg▼Softwarejocatior:/hoirie/yxgJtool5/oraclellg/product/L1,2.0Jdbhorne_l▼D.ata.basefilelocation:/horne/y^gytools/orackllg/oradataData.baseedition:EnterpriseEdition(4.29CB)一CharacterSei：Default(WE8M5WIN125Z),OSDBACroup;丁犯 ▼Qotialdatabasename:orciAdmini5trativet^iWtC.0nfirinPassword:TnYTr應(yīng)該在68%的時(shí)候會(huì)報(bào)3次錯(cuò)，順序不定，看清錯(cuò)誤target第一個(gè)報(bào)錯(cuò)

OracleDatabase11gRelease2IristailerErrorininvokingtarget'instairofmakefile7honie/yxg/tooh/ora.clellg/|3roduct/lL.2.0/dbhonie_l/ctx/lib/ins_ctx.mk'.'/home/yxg/tools/oreinventory/logs/insiallActions201^-12-19_01-01-59AM.log1fordetails.AbortRetry^ortinueAbortRetry^ortinue這個(gè)問題先跳過，選擇continue第二個(gè)報(bào)錯(cuò)：Errorininvokingtarget‘a(chǎn)gentnmhs’ofmakefile‘/home/yxg/tools/oracle11g/product/11.2.0/dbhome1/sysman/lib/insemagent.mk'解決方案：Ctrl+Alt+T打開新的終端窗口執(zhí)行以下命令cd/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/sysman/lib/sudogeditins_emagent.mk將文件中的$(MK_EMAGENT_NMECTL)修改成$(MK_EMAGENT_NMECTL)-lnnz11即可(應(yīng)該有兩處需要修改)。$(S￥SMANBIN)endctl：$[MK_EMAGENT_NMECTL-lnn211)|然后點(diǎn)擊retry，接著往下執(zhí)行第三個(gè)錯(cuò)誤：解決辦法：打開一個(gè)新的終端，輸入如下四個(gè)命令:

sudosed-i's/\(TNSLSNR_LINKLINE.*\$(TNSLSNR_OFILES)\)\(\$(LINKTTLIBS)\)/\1-Wl,--no-as-needed\2/g'/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/network/lib/env_network.mksudosed-i's/\(ORACLE_LINKLINE.*\$(ORACLE_LINKER)\)\(\$(PL_FLAGS)\)/\1-Wl,--no-as-needed\2/g'/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mksudosed-i's/\(\$LD\$LD_RUNTIME\)\(\$LD_OPT\)/\1-Wl,--no-as-needed\2/g'/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/bin/genorasdkshsudosed-i's/\(\s*\)\(\$(OCRLIBS_DEFAULT)\)/\1-Wl,--no-as-needed\2/g'/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/srvm/lib/ins_srvm.mk〃如果不行的話嘗試進(jìn)入文件路徑之后在執(zhí)行然后在圖形界面點(diǎn)擊‘Retry’就能繼續(xù)安裝了。TheinstillationofOracleDcLtaba.sewassuccessful.Note;EnterpriseMana.qerDatabaseC口□!：「□IURL-(or-cl):alh 8/m什iDatabaseConFigurationAssistantHigherAvailabilityRailingupgradeswithPhysicalStandbyHigherAvailabilityRailingupgradeswithPhysicalStandbyRcaM^mereportingwithPhysicalStandbyHqtpatching/CreatingandstartingOracleinstanceCompletingDatabaseCreationClonedatabasecreationinprogress46%Logfilesforthecurrentoperationarelocatedat:/home/yxg/tools/oraclellg/cfgtoollogs/dbca/orcl2O@DatabaseCanHguratfonAssistant:WarningEnterorisemaragerconlgurationsucceededwi:hthefolbwinjwa-ning-Frrnr；口「urin口 rnn'ml^ 「nirrnl卜鼻。h口口nnmiijhtupin-irin-：a「u-anode.TosecuretheDatabaseControlexecutethefollovdngcomnand(s):Settheenvironment/ariaole0RACLE_SDtoorci/homc/'-j-cig,took/oriclcllg/prodict/l1.2.('/dbnomc.l/bin/cmctlstopdbc?nsocW)/home/yxgftool;/orcClellg/|crodLct/lL.2.0/dbiome_l/bin/emctlconfgemkey-repossysnian.pwd;PosswcrdfcrSY5MAPIuser>/home/y}{gftool5/orcClellg/|crodLct/lL.2.(i/dbiome_l/bin/emctlsecuredbconsole-iyiiiidii.pwdv-Pdi.?wuiJfui3T5MAhlu%el3/home/y}{gftool5/orcClellg/|zrodLct/lL,2.0/dbiome_l/bin/emctlstartdbconsoeTosecureEmKe兄run/homeMg/tojls/craclEllgfproduct;ll.LO/cbhome_l/binfemctlO信DatabaseConfigurationAssFstantDatabasecreationcomplete.Fordetailscheck,theloqfile;at:/home/yxgAools/oraclellg/cfgtoDllogs/dbca/oncl.DatabaseInformaticn:GlooalDatabaseName: ordSysiemIdeitifierfSD): ordSer/ierParameter:ilename:/hcme/yxg/tools/oraclellg/product/ll.Z.O/dahome.l/dbSjSpfileorcl.oraTheDatabaseControlURLishttp://localhost:1158/emNote:AJIdatabaseeccountsexcep:SYS,S'^STEM,DBSNM^andSYSMAharelocked.SelectthEPasswordManagementbuttontoMemacompletelis:oflockedaccountso-tomanagethedatabaseaccounts(exLtplDB5HMPdridSySMaJM).FrurriiheFaiiwurJManajerrierilwinduw,uriluLkunlyneauLurilbyujwilluse.OracleCorporationstronglyrecommendschangingtiedefcultpasswordsimmediatelyafterunlockingtheaccount.PasswordMaiagemGnt...*'flnsible-2［正?。?OracleVMVirtualBdkOracleDatabase11gReLease2Instslier-Installingdatabase-Step11of12InstaJNProdiLictOWACLE(1/DATABASE酗制）1:06AM方Util■-.□nrlgureSttunryUpaufi^OracleDatabase11gReLease2Instslier-Installingdatabase-Step11of12InstaJNProdiLictOWACLE(1/DATABASE酗制）1:06AM方Util■-.□nrlgureSttunryUpaufi^Injtdl-ition^pdonGridOptloriTProductLangua.ge3DatabaseEditioninjtdlitionLcciHcnCreareInyenroryljOperalingSysrfctmCroupi丁PrerequlskeChecksljSummaryEtilingup'OrarltDari3.b3.rt11g11.2.D1□OracleDalaba工，i口」taJhitiQn lu亡匚e■心dudExecuteUonfigu國七IqhscrFpts?LnkbinanTheTnllaixingcoriTiguraiion5cr1pi：5needrobeenecucedasitie"roDTuser.Setup■flitsEiecuttRdoI： 在「DO照戶不執(zhí)行標(biāo)出來的去個(gè)文件Scripts1abeexecuiedFinishNumber|FinishNumber|ScripiLocation1fhoiriej'i：tfic；i：n：iol5j'oraJnvenitD中」口「司一班口口|：.51rl2 Jhomej'c<ic；tD：iol5j'iDracleLlgjproducl；11.2j3Jdbhonie=LJmot.EhToeKecureiheconngurarlonscriptE：1Openalermlnal癡nmw2.LogToeKecureiheconngurarlonscriptE：1Openalermlnal癡nmw2.Loginas.「口WMRunihescripts耳Returnid(his前ndowandd忙K/'dl?iocomlnueXT■皿E:SecuiritYandGomiHelp|百cl]圖「:解值1nm由03⑥回拈出ctri.然后按照安裝程序提示最后執(zhí)行兩個(gè)腳本（這一步我只遇到一個(gè)腳本，但是并不影響）:sudo/home/yxg/tools/Inventory/orainstRoot.shsudo/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/root.sh五、測(cè)試Oracle是否安裝成功1、先測(cè)試一下oracle的環(huán)境變量，在終端輸入命令echo$ORACLE_BASEecho$ORACLE_HOMEecho$PATH看看是不是你配置的值，沒問題繼續(xù)向下2、開啟監(jiān)聽器，在終端輸入命令lsnrctlstart^xggubuntui?$IsnrctlstartLSNRCTLforLinux:Version11*33+1.6-Productionon2O-DEC-201&白4:49:35Copyright(c)1991,2009pOracle*Allrightsreserved*Starting/hene/yxg/tools/oracle11g/product/IltZ.fl/dbhonel/btn/tnslsnr:pleasewattxx.TNSLSNRforLinux:Version1L2+@*1?^xggubuntui?$IsnrctlstartLSNRCTLforLinux:Version11*33+1.6-Productionon2O-DEC-201&白4:49:35Copyright(c)1991,2009pOracle*Allrightsreserved*Starting/hene/yxg/tools/oracle11g/product/IltZ.fl/dbhonel/btn/tnslsnr:pleasewattxx.TNSLSNRforLinux:Version1L2+@*1?D*Productionsystempa「自再白terfilets/ht)ne/y*g/tool&/uracialig/praduct/11.2.o/dbho?&_l/network/adnin/Listener*oraLognessageswrittento/hone/yxg/tools/oraclellg/diag/tnslsnryubuntj/ltatener/ag「t八嗎.XElListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tpc)(KEY=EXrPROC15Zl)))Ltstentngon：(dE^CFIIPTJQNmjA□口RE5s=(PR口TQ匚01_=七七口)(^105丁=127a.01)(PDRT=1521)))ConnectingtoSTArusofthe(DESCRIPTION=(ADDRESS=(PROTOCOL=LPC)(KE￥=EXrPROC15Zl)))LISTENERLISTENERversion1NSLSMRforLtnux:Version11.2,0.1,0-ProductionStartDateuptimeTraceLevelSecuritySNMPListenerParaneterFileprk/adntn/ltstener.oraListenerLogFile/dlert/logxxnl2D-DEC-20L504:43:070days0hr.omtn.osecoffON;Local05ftuthenticationOFF/hone/yxg/tQols/ordclellg/product/ll<Z*oydbhone_l/netw/hone/yxg/tools/oraclellg/dtag/tnslsnr/ubuntu/listenerListeningEndpointsSummary,.,(DESCRIPriON-(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC152L)))ListeningEndpaintsSunnary.(DESCRIPTIOM=(ADDRE￡￡=(PROTOCOL-tpc)(KEY.EXTPROC1521)))(DFSCRrPTIOM=(ADDRFSS=(PROTOCOI=tcp)(H05T=127+0.OU)(PORr=1521)))ThelistenersupportsnoservicesThecomnardconpLetedsuccessfullyyxggubuntu|命令I(lǐng)snrctlstatus可以查看監(jiān)聽信息yxg^ubuntu:^5IsnrctlstatusLSNRCTLforLinux;Version11,2-0*1.0-Productionon20BEC201617:38:22Copyright(c)1991,2099,OraclerAllrightsreserved,Connectingto(DESCRlPTIOM=(ADDRES5=(PROrOCOL=IPC)(key=extprociszi)))STATUSoftheLISTEMERAliasVersionLISTENERFNSLSNRforLinux:Version11*2*0-1*0-ProductionstartDate2Q-DEC-2Q1517：38t07UptineTraceLevelSecuritySNMPListenerParaneterFileork/adnin/listener?oraListenerLogFile0days0hr40nin*16secOffON:LocalOSAuthenticationOFF/hone/yxg/tools/oraclellg/praducty11.ZT0/dbhone_l/netw/hone/y)tg/to0'L5/orac'Lellg/diag/tnslsnr/ubuntu/listener/alert/log.xnlListeningEndpointsSunnary,.?(DESCRIPTION=(ADDRESS=(PROTOCOL=lpC)(KE￥=EXTPROCI52I)))(DESCRIPTION=CADDRESS=(PROTOCOL=tcp}(HDST=127,e.O*l)(PORT=1521)))ThelistenersupportsnoservicesTheconnandcompletedsuccessfully啟動(dòng)oracle數(shù)據(jù)庫

sqlplus/nologyxg@ubuntu:"$sqlplus/nologSQL*PlusiRelease11*2*0*1*0ProductiononTueDec2017:39:232016Copyright(c)1982,2009,Oracle*Allrightsreserved*SQL〉conn/assysdba以系統(tǒng)默認(rèn)用戶sysdba登錄SQL?conn/assysdbaConrectedtoanidleinstance.SQL>startupSQL>startupORACLEinstancestarted*826753024bytes2217872bytes826753024bytes2217872bytes49493463Zbytes322961408bytes664371ZbytesSQL,|創(chuàng)建用戶并設(shè)置密碼，之后據(jù)說還要賦權(quán)，具體怎么做之后再研究。SQL>createuserzyxidentifiedbyzyx;User「「eatcd.退出SQL>exitDisconnectedfronoracleDatabase11gEnterpriseEditionRelease -64bitProduicttanWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsyx典ubuntu關(guān)閉監(jiān)聽器yxgOubuntuIsnrctlstopLSNRCTLforLinux:Version11.2,0,1.0-Productionon20-DEC-2ei&17:44:04Copyright(c)1991,2099,Oracle.Allrightsreserved.Connectingto(DESCRIPTIOhl=(ADDRESS-(PROTOCOL-IPC)(KEV=EXTPROC1S?1)))