Ubuntu104安装Oracle11g及配置环境

Ubuntu16.04安装Oraclellg及配置环境2016年12月21日星期三，最后一次更新。我遇到的第一个问题是本机系统和虚拟机系统不能分享文件，即无法从本机复制文件到虚拟机。原因是VmwareTools未安装或受损。解决方案如下：点击VMware菜单的-VM-InstallVmwareTools这时，在Ubuntu下会自动加载Linux版的VMwareTools的安装光盘镜像。你会看到虚拟机的桌面上出现了一个名为VMwareTools的光盘图标，并且被自动打开。其中包括VMwareTools-xxx-i386.rpm和VMwareTools-xxx.tar.gz两个文件。把那个.tar.gz文件拷贝而到桌面，右键菜单-解压缩到此处。会自动解压为一个vmware-tools-distrib目录。打开终端（系统的应用程序菜单-附件-终端、或者Ctrl+Alt+T）依次执行以下命令行：cdDesktopcdvmware-tools-distribsudo./vmware-install.pl（sudo是superuserdo的意思，即享有最高权限的超级用户操作，回车后会提示输入你的密码，并且密码不会显示出来，表明你将以更高级权限执行一个动作一一安装软件；再次回车后安装开始）经过一番确认回车后（相当于在Windows里安装软件时所填答的诸多对话框，我们这里均采用缺省设置），直到最后出现“Enjoy——theVMwareteam”的字样后，VMwareT001s终于安装完成了。

重启Ubuntu搞定。接下来开始做安装Oracle的准备工作：一、安装JDK打开终端输入以下命令sudoapt-getupdatesudoapt-getinstallopenjdk-8-jdk配置系统环境变量（以后的环境变量都是通过编辑/etc/profile文件实现的）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单击右上角的保存按钮之后关闭窗口回到终端界面。使用source/etc/profile命令使刚才配置的信息生效。使用java-version命令进行验证。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//系统已经安装sudoapt-getinstallbinutils//只更新了一个文件，成功sudoapt-getinstallbzip2//系统已经安装sudoapt-getinstallelfutils//成功sudoapt-getinstall©*口2土//成功sudoapt-getinstallgawk//系统已经安装sudoapt-getinstallgcc//系统已经安装sudoapt-getinstallgcc-multilib//成功sudoapt-getinstallg++-multilib//成功

sudoapt-getinstallia32-libs//lib32ncurses5和lib32z1代替sudoapt-getinstall卜$卜//成功sudoapt-getinstallless//成功sudoapt-getinstalllesstif2sudoapt-getinstalllesstif2-dev/*这两个包是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//系统已经安装sudoapt-getinstalllibaio1//成功sudoapt-getinstalllibaio-dev//成功sudoapt-getinstalllibc6-dev//系统已经安装sudoapt-getinstalllibc6-dev-i386//系统已经安装sudoapt-getinstalllibc6-i386〃系统已经安装sudoapt-getinstalllibelf-dev//成功sudoapt-getinstalllibltdl-dev//成功sudoapt-getinstalllibmotif4//成功sudoapt-getinstalllibodbcinstq4-1//成功sudoapt-getinstalllibodbcinstq4T:i386//成功sudoapt-getinstalllibpth-dev//成功sudoapt-getinstalllibpthread-stubs0//成功

sudoapt-getinstalllibpthread-stubs0-dev〃系统已经安装sudoapt-getinstalllibstdc++5〃成功sudoapt-getinstalllsb-cxx〃成功sudoapt-getinstallmake//系统已经安装sudoapt-getinstallopenssh-server//成功sudoapt-getinstallpdksh//成功sudoapt-getinstall讨亚9口//成功sudoapt-getinstallrpm//系统已经安装sudoapt-getinstall$丫$$土2土//成功sudoapt-getinstallunixodbc//成功sudoapt-getinstallunixodbc-dev//成功sudoapt-getinstallunzip//系统已经安装sudoapt-getinstallx11-utils//系统已经安装sudoapt-getinstallzlibc//成功三、配置Oracle环境1、用以下命令检查系统变量/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、根据上面命令中得到的参数值在/etc/sysctl.conf中增加对应数据cd/etc/sudogedit/etc/sysctl.conf〃注释：gedit就是打开文件的命令，可以通过这个命令打开文件然后编辑并保存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

保存之后关掉这个窗口回到命令行终端：运行以下命令更新内核参数：sysctl-p添加对用户的内核限制：3、添加对yxg用户的内核限制在/etc/security/limits.conf文件中增加以下数据,注:其中yxg是我ubuntu系统的普通用户cd/etc/security/sudogeditlimits.conf打开文件之后在末尾加入以下几行：yxgsoftnproc2047yxghardnproc16384yxgsoftnofile1024yxghardnofile65536yxgsoftstack10240保存之后关闭文件窗口。同样的方法打开文件/etc/pam.d/login，增加以下行（有了就不用增加了）：sessionrequiredpam_limits.so同样检查/etc/pam.d/su，没有以下行就自己加上：sessionrequiredpam_limits.so4、创建需要的文件夹mkdir/home/yxg/toolsmkdir/home/yxg/tools/oracle11gchmod577tools-R 〃给文件夹赋予权限5、为Oracle配置环境变量在/etc/profile中追加

exportORACLE_BASE=/home/yxg/tools/oracle11g//oracle安装目录，第4步创建的文件夹exportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1〃现在还看不到这个文件夹，在Oracle安装过程中系统会自动创建，后面安装时选择路径要和这里设置的一致。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〃在安装时会有一个设置的地方，默认是orcl，也可以设置成其他Globaldatabasenime:exportORACLE_UNQNAME=orcl〃默认字符集exportNLS_LANG=.AL32UTF8〃环境变量exportPATH=${PATH}:${ORACLE_HOME}/bin/:$ORACLE_HOME/lib64;6、欺骗oracle的安装程序Oracle本身并不支持ubuntu来安装，所以要进行欺骗oracle的安装程序（sudo执行）：用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最后这一步提示权限不够，应该是权限设置的问题

chown-Ryxg:yxg/etc,然后就可以了。/*大家要谨慎执行这一步啊，这条命令是把/etc文件夹下的所有文件的所有权都赋给yxg组下的yxg用户了，后面会造成很多麻烦。这里如果你也执行了这一条那请立马用以下命令改回来：chown-Rroot:root/etc*/四、终于到正式安装Oracle啦复制Oracle安装包至Uhome/yxg/tools/oracle11g §linux,x64_lLgatabase_Lof2.zip灌Iinux,x64lLgR2database2of2.ziporacl«11gVMwareWorkstation正在将交件“Mu%油4_llgR2_由VMwareWorkstation正在将交件“Mu%油4_llgR2_由ta位5已_232即簟制到虚捌机取消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 〃赋予可读可写可执行权限./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应该在68%的时候会报3次错，顺序不定，看清错误target第一个报错

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这个问题先跳过，选择continue第二个报错：Errorininvokingtarget‘agentnmhs’ofmakefile‘/home/yxg/tools/oracle11g/product/11.2.0/dbhome1/sysman/lib/insemagent.mk'解决方案：Ctrl+Alt+T打开新的终端窗口执行以下命令cd/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/sysman/lib/sudogeditins_emagent.mk将文件中的$(MK_EMAGENT_NMECTL)修改成$(MK_EMAGENT_NMECTL)-lnnz11即可(应该有两处需要修改)。$(S¥SMANBIN)endctl：$[MK_EMAGENT_NMECTL-lnn211)|然后点击retry，接着往下执行第三个错误：解决办法：打开一个新的终端，输入如下四个命令:

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〃如果不行的话尝试进入文件路径之后在执行然后在图形界面点击‘Retry’就能继续安装了。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照户不执行标出来的去个文件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.然后按照安装程序提示最后执行两个脚本（这一步我只遇到一个脚本，但是并不影响）:sudo/home/yxg/tools/Inventory/orainstRoot.shsudo/home/yxg/tools/oracle11g/product/11.2.0/dbhome_1/root.sh五、测试Oracle是否安装成功1、先测试一下oracle的环境变量，在终端输入命令echo$ORACLE_BASEecho$ORACLE_HOMEecho$PATH看看是不是你配置的值，没问题继续向下2、开启监听器，在终端输入命令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|命令Isnrctlstatus可以查看监听信息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启动oracle数据库

sqlplus/nologyxg@ubuntu:"$sqlplus/nologSQL*PlusiRelease11*2*0*1*0ProductiononTueDec2017:39:232016Copyright(c)1982,2009,Oracle*Allrightsreserved*SQL〉conn/assysdba以系统默认用户sysdba登录SQL?conn/assysdbaConrectedtoanidleinstance.SQL>startupSQL>startupORACLEinstancestarted*826753024bytes2217872bytes826753024bytes2217872bytes49493463Zbytes322961408bytes664371ZbytesSQL,|创建用户并设置密码，之后据说还要赋权，具体怎么做之后再研究。SQL>createuserzyxidentifiedbyzyx;User「「eatcd.退出SQL>exitDisconnectedfronoracleDatabase11gEnterpriseEditionRelease -64bitProduicttanWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsyx典ubuntu关闭监听器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)))