Configuring SQLPlus.docx
- 文档编号:12304514
- 上传时间:2023-04-18
- 格式:DOCX
- 页数:31
- 大小:31.62KB
Configuring SQLPlus.docx
《Configuring SQLPlus.docx》由会员分享,可在线阅读,更多相关《Configuring SQLPlus.docx(31页珍藏版)》请在冰豆网上搜索。
ConfiguringSQLPlus
ConfiguringSQL*Plus
ThischapterexplainshowtoconfigureyourSQL*Pluscommand-line,WindowsGUI,andiSQL*Plusenvironments.Ithasthefollowingtopics:
∙SQL*PlusandiSQL*PlusEnvironmentVariables
∙SQL*PlusandiSQL*PlusConfiguration
∙iSQL*PlusApplicationServerConfiguration
∙iSQL*PlusWebBrowserConfiguration
∙WindowsGraphicalUserInterfaceConfiguration
SQL*PlusandiSQL*PlusEnvironmentVariables
TheseenvironmentvariablesspecifythelocationorpathoffilesusedbySQL*PlusandtheiSQL*PlusApplicationServer.ForotherenvironmentvariablesthatinfluencethebehaviorofSQL*Plus,seetheOracleDatabaseAdministrator'sReference.
Table3-1ParametersorEnvironmentVariablesinfluencingSQL*PlusandiSQL*Plus
ParameterorVariable
Description
LD_LIBRARY_PATH
EnvironmentvariabletospecifythepathusedtosearchforlibrariesonUNIX.Theenvironmentvariablemayhaveadifferentnameonsomeoperatingsystems,suchasLIBPATH,SHLIB_PATH,LD_LIBRARY_PATH64.
NotapplicabletoWindows
Example
$ORACLE_HOME/lib
LOCAL
Windowsenvironmentvariabletospecifyaconnectionstring.PerformsthesamefunctionasTWO_TASKonUNIX.
NLS_LANG
Environmentvariabletospecifyglobalizationbehavior.
Example
american_america.utf8
ORACLE_HOME
EnvironmentvariabletospecifywhereSQL*Plusisinstalled.ItisalsousedbySQL*Plustospecifywheremessagefilesarelocated.
Examples:
d:
\oracle\10g
/u01/app/oracle/product/v10g
ORA_NLS10
EnvironmentvariabletospecifythelocationsoftheNLSdataandtheuserbootfileinSQL*Plus10.1.Thedefaultlocationis$ORACLE_HOME/nls/data.InasystemwithbothOracle9iand10g,orasystemunderversionupgrade,youshouldsetORA_NLS10forOracle10gandsetORA_NLS33for9i.ThedefaultNLSlocationin9iwas$ORACLE_HOME/common/nls/admin/data.
ORACLE_PATH
EnvironmentvariabletospecifythelocationofSQLscripts.IfSQL*PluscannotfindthefileinORACLE_PATH,orifORACLE_PATHisnotset,itsearchesforthefileinthecurrentworkingdirectory.
NotapplicabletoWindows
ORACLE_SID
Environmentvariabletospecifythedatabaseinstance,optional
PATH
Environmentvariabletospecifythepathtosearchforexecutables,andDLLsinWindows.TypicallyincludesORACLE_HOME/bin
SQLPATH
EnvironmentvariableorWindowsregistryentrytospecifythelocationofSQLscripts.SQL*PlussearchesforSQLscripts,includinglogin.sql,inthecurrentdirectoryandtheninthedirectoriesspecifiedbySQLPATH.SQLPATHisacolonseparatedlistofdirectories.ThereisnodefaultvaluesetinUNIXinstallations.
InWindows,SQLPATHisdefinedinaregistryentryduringinstallation.FormoreinformationabouttheSQLPATHregistryentry,see"SQLPATHRegistryEntry".
SQLPLUS
EnvironmentvariabletospecifythelocationofSQL*PlusmessagefilesinWindows.Thisenvironmentvariableissetduringinstallation.Ithasadefaultvalueof:
%ORACLE_HOME%\SQLPLUS\MESG
NotapplicabletoUNIX.
SQLPLUS_FONT
WindowsregistryentrytospecifythefontfaceusedintheSQL*PlusWindowsGUI.IftheSQLPLUS_FONTentryisnotcreated,orifithasaninvalidnameorvalue,thedefaultface,Fixedsys,isused.
SQLPLUS_FONT_SIZE
WindowsregistryentrytospecifythefontsizeusedintheSQL*PlusWindowsGUI.IftheSQLPLUS_FONT_SIZEentryisnotcreated,orifithasaninvalidnameorvalue,thedefaultsize,16,isused.
TNS_ADMIN
Environmentvariabletospecifythelocationofthetnsnames.orafile.Ifnotspecified,$ORACLE_HOME/network/adminisused
Example
h:
\network
/var/opt/oracle
TWO_TASK
UNIXenvironmentvariabletospecifyaconnectionstring.ConnectionsthatdonotspecifyadatabasewillconnecttothedatabasespecifiedinTWO_TASK.
Example
TWO_TASK=MYDBexportTWO_TASKsqlplushr/your_password
isthesameas:
sqlplushr/your_password@MYDB
iSQLPlusAllowUserMarkup
iSQL*PlusconfigurationfileoptiontospecifywhetherHTML,entitymappingreplacescharactersofspecialsignificancewithprintablerepresentationsofthosecharacters.Entitymappingisenabledbydefault,preventingtheuseofuserdefinedHTMLiniSQL*Plusoutput.TheiSQLPlusAllowUserMarkupoptioncontrolswhetheraniSQL*PlusApplicationServerenablesuserstochangetheentitymappingsetting,orusethecustomHTMLheader,bodyandtabletags.
FormoreinformationaboutuserdefinedHTML,see"EnablingUserDefinedHTMLMarkup".
iSQLPlusConnectIdList
iSQL*PlusconfigurationfileoptiontospecifythedatabasesthatuserscanaccessiniSQL*Plus.Whenenabled,adropdownlistofavailabledatabasesisdisplayedinplaceoftheConnectionIdentifiertextfieldontheLoginscreen.ThisenablesgreatersecurityforiSQL*PlusServersinhostedenvironments.
Formoreinformationaboutrestricteddatabaseaccess,see"EnablingorDisablingRestrictedDatabaseAccess".
log4j.rootLogger
iSQL*PlusconfigurationfileoptiontospecifytheleveltowhichmessagesareloggedintheiSQL*PlusApplicationServererrorlogs.
FormoreinformationaboutiSQL*Pluslogging,see"SettingtheLevelofiSQL*PlusLogging".
SQL*PlusandiSQL*PlusConfiguration
YoucansetupyourSQL*PlusoriSQL*PlusApplicationServerenvironmenttousethesamesettingswitheachsession.
Therearetwooperatingsystemfilestodothis:
∙TheSiteProfilefile,glogin.sql,forsitewidesettings,andsettingsfortheiSQL*PlussessionsfromaniSQL*PlusApplicationServer.
∙Additionally,inthecommand-lineuserinterfaceandtheWindowsGUI,theUserProfile,login.sql,setsuserspecificsettings.
Theexactnamesofthesefilesissystemdependent.
Thefollowingtablesshowtheprofilescripts,andsomecommandsandsettingsthataffecttheCommand-line,WindowsandiSQL*Plususerinterfaces.
Table3-2ProfileScriptsaffectingSQL*PlusUserInterfaceSettings
Thisscript...
isrunintheCommand-lineandWindowsGUI...
isrunintheiSQL*PlusServer...
SiteProfile(glogin.sql)
CancontainanycontentthatcanbeincludedinaSQL*Plusscript,suchassystemvariablesettingsorotherglobalsettingstheDBAwantstoimplement.
AftersuccessfulOracleDatabaseconnectionfromaSQLPLUSorCONNECTcommand.
Where/NOLOGisspecified.
OnsuccessfulOracleDatabaseconnectionfromaniSQL*PlussessionoraCONNECTcommandfromaniSQL*Plussession.
UserProfile(login.sql)
CancontainanycontentthatcanbeincludedinaSQL*Plusscript,butthesettingsareonlyapplicabletotheuser'ssessions.
ImmediatelyaftertheSiteProfile.
NotApplicable
Table3-3CommandsinProfilescriptsaffectingSQL*PlusUserInterfaceSettings
Inaprofilescript,thiscommand...
affectstheCommand-lineandWindowsGUIby...
affectstheiSQL*PlusServerby...
SETSQLPLUSCOMPAT[IBILITY]{x.y[.z]}
Alsoseethe"SQL*PlusCompatibilityMatrix".
SettingtheSQL*PluscompatibilitymodetoobtainthebehaviortheDBAwantsforthissite.
SettingtheSQL*PluscompatibilitymodetoobtainthebehaviortheDBAwantsforthissite.
SQLPLUScommandCOMPATIBILITYOption
AsforSETSQLPLUSCOMPATIBILITYbutsetwiththeSQLPLUScommandCOMPATIBILITYoption.
NotApplicable
SQLPLUScommandRESTRICTOption
StartingSQL*PluswiththeRESTRICToptionsetto3preventstheUserProfilescriptfrombeingread.
NotApplicable
SiteProfile
ASiteProfilescriptiscreatedduringinstallation.ItisusedbythedatabaseadministratortoconfiguresessionwidebehaviorforSQL*PlusCommand-line,WindowsGUIandiSQL*Plusconnections.
TheSiteProfilescriptisgenerallynamedglogin.sql.SQL*PlusortheiSQL*PlusServerexecutesthisscriptwheneverauserstartsaSQL*PlusoriSQL*PlussessionandsuccessfullyestablishestheOracleDatabaseconnection.
TheSiteProfileenablestheDBAtosetupSQL*PlusenvironmentdefaultsforallusersofaparticularSQL*PlusoriSQL*PlusApplicationServerinstallation
UserscannotdirectlyaccesstheSiteProfile.
DefaultSiteProfileScript
TheSiteProfilescriptis$ORACLE_HOME/sqlplus/admin/glogin.sqlinUNIX,and%ORACLE_HOME%\sqlplus\admin\glogin.sqlinWindows.IfaSiteProfilealreadyexistsatthislocation,itisoverwrittenwhenyouinstallSQL*Plus.IfSQL*Plusisremoved,theSiteProfilescriptisdeleted.
ThedefaultSiteProfilescriptcontainsthefollowing:
--
--Copyright(c)1988,2003,OracleCorporation.AllRightsReserved.
--
--NAME
--glogin.sql
--
--DESCRIPTION
--SQL*Plusgloballogin"siteprofile"file
--
--AddanySQL*Pluscommandsherethataretobeexecutedwhena
--userstartsSQL*Plus,orusestheSQL*PlusCONNECTcommand
--
--USAGE
--Thisscriptisautomaticallyrun
--
--UsedbyTrustedOracle
COLUMNROWLABELFORMATA15
--UsedfortheSHOWERRORScommand
COLUMNLINE/COLFORMATA8
COLUMNERRORFORMATA65WORD_WRAPPED
--UsedfortheSHOWSGAcommand
COLUMNname_col_plus_show_sgaFORMATa24
--DefaultsforSHOWPARAMETERS
COLUMNname_col_plus_show_paramFORMATa36HEADINGNAME
COLUMNvalue_col_plus_show_paramFORMATa30HEADINGVALUE
--DefaultsforSHOWRECYCLEBIN
COLUMNorigname_plus_show_recycFORMATa16HEADING'ORIGINALNAME'
COLUMNobjectname_plus_show_recycFORMATa30HEADING'RECYCLEBINNAME'
COLUMNobjtype_plus_show_recycFORMATa12HEADING'OBJECTTYPE'
COLUMNdroptime_plus_show_recycFORMATa19HEADING'DROPTIME'
--DefaultsforSETAUTOTRACEEXPLAINreport
COLUMNid_plus_expFORMAT990HEADINGi
COLUMNparent_id_plus_expFORMAT990HEADINGp
COLUMNplan_plus_expFORMATa60
COLUMNobject_node_plus_expFORMATa8
COLUMNother_tag_plus_expFORMATa29
COLUMNother_plus_expFORMATa44
UserProfile
ForSQL*Pluscommand-lineandWindowsGUIconnections,SQL*PlusalsosupportsaUserProfilescript.TheUserProfileisexecutedaftertheSiteProfileandisintendedtoallowuserstospe
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Configuring SQLPlus