ORACLEµÄÓû§ÃûºÍÃÜÂëÊÇʲô£¿ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ¸Õ×°ÁËORACLE 11g£¬¿É´ò¿ªSQL PlusʱҪÇóÊäÈëÓû§ÃûºÍÃÜÂë¡£ËüÃÇÊÇʲô°¡£¿
×°µÄʱºò²»ÊǾÍÒªÄãÊäÈëÓû§ÃûºÍÃÜÂëµÄô£¿
ÔÚĬÈÏÇé¿öÏ£¬¼ÙÈçÄãµÇ¼OSµÄÓû§ÊÇDBA×éµÄ£¬¿ÉÒÔÕâÑù£º
sqlplus /nolog
sql>connect / as sysdba
ÕâÑù¾ÍÒÔSYSDBAȨÏÞÁ¬ÉÏÁË£¬È»ºó¿ÉÒÔ¸ÄÆäËüÈκÎÓû§µÄÃÜÂë
Oracle Óû§¼°½ÇÉ« ½éÉÜ
http://blog.csdn.net/tianlesoftware/archive/2009/11/09/4786956.aspx
ÏÂÃæÊÇOracleµÄÓû§ÃûºÍÃÜÂ룬¼°¶ÔÓû§µÄÃèÊö£º
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enterprise Manager Grid Control Installation and Basic Configuration
LBACSYS
LBACSYS
The Oracle Label Security administrator account
Oracle Label Security Administrator's Guide
MDDATA
MDDATA
The schema used by Oracle Spatial for storing Geocoder and router data
Oracle Spatial User's Guide and Reference
MDSYS
MDSYS
The Oracle Spatial and Oracle interMedia Locator administrator account
Oracle Spatial User's Guide and Reference<
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......