Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨5£©£º¹ÜÀíOracle½ø³Ì

1¡¢Æô¶¯SQL*Plus
Æô¶¯ÓÃSQL*Plus¶¼»áÆô¶¯ÁË£¬ÕâÖÖ·½Ê½ºÏÊÊÕý³£µÄÖÕ¶ËÓû§Ê¹Óã¬×÷Ϊ¹ÜÀíÔ±ÎÒÃÇÓÐÁíÒ»Öֱ仯ÐÎʽNOLOG¿ª¹Ø¡£
?[Copy to clipboard]View Code BASH
$ sqlplus /nolog
2¡¢Æô¶¯iSQL*Plus
ÓÉÓÚ²»ÊÇÖ÷ҪѧÕâ¸ö£¬Ç°Ò»ÆªÒ²Ìá¹ýÕâ¸öÁË£¬¿´ÏÂǰһƪµÄÄÚÈݰɣ¬OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨ËÄ£©£º½ÓºÏOracleÊý¾Ý¿â
3¡¢Æô¶¯Database Listenter
Æô¶¯£º
?[Copy to clipboard]View Code BASH
$ lsnrctl start
¹Ø±Õ£º
?[Copy to clipboard]View Code BASH
$ lsnrctl stop
²é¿´£º
?[Copy to clipboard]View Code BASH
$ lsnrctl status
4¡¢Æô¶¯Database Control¶Ë¿Ú¼à¿Ø³ÌÐò
Æô¶¯£º
?[Copy to clipboard]View Code BASH
$ emctl start dbconsole
¹Ø±Õ£º
?[Copy to clipboard]View Code BASH
$ emctl stop dbconsole
²é¿´£º
?[Copy to clipboard]View Code BASH
$ emctl status dbconsole
Æô¶¯Ö®ºó£¬ÎÒÃÇÒ»Ñù¿ÉÒÔ´ò¿ªÍøÒ³²é¿´£¬ÊäÈëURL£ºhttp://<host.domain>:<port>/em
host.domain£ºÊý¾Ý¿â·þÎñÆ÷µÄµØÖ·¡£
port£º¶Ë¿ÚºÅ¡££¨ÊéÉϺÍÍøÉ϶¼¿´µ½ËµÄ¬ÈϵÚÒ»¸öÊý¾Ý¿âµÄ¶Ë¿Ú5500£¬ÎҵĺÃÏóÿ´Î°²×°OracleÔÚ´´½¨¿âµÄʱºòĬÈϵÄ1158Ò»Ñù£©
Ìáʾ£ºÒÔÉÏURLµØÖ·¶¼¿ÉÒÔÔÚ$ORACLE_HOME/install/readme.txtÎļþÖв鵽¡£
5¡¢Êý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ
Ñϸñ˵À´£¬ÎÒÃDz¢²»ÊÇÆô¶¯»òÍ£Ö¹Ò»¸öÊý¾Ý¿â£ºÊµÀý¿ÉÒÔ±»Æô¶¯ºÍÍ£Ö¹£»Êý¾Ý¿â¿ÉÒÔ±»¼ÓÔØºÍ´ò¿ª£¬Ëæºó»¹¿ÉÒÔ±»Ð¶Ôغ͹رա£
5.1¡¢Ê¹ÓÃÕýÈ·µÄȨÏÞ½øÐÐÁ¬½Ó
ÆÕͨÓû§ÎÞ·¨Æô¶¯»ò¹Ø±ÕÊý¾Ý¿â£¬ÆäÔ­ÒòÔÚÓÚÆÕͨÓû§ÒÀ¾ÝÊý¾Ý×ֵ佸ÐÐÉí·ÝÑéÖ¤£¬µ«ÊÇÊý¾Ý×ÖµäÔÚÊý¾Ý¿â´ò¿ªÇ°ÎÞ·¨±»¶ÁÈ¡£¬´Ó¶ø³öÏÖÆÕͨÓû§×¢¶¨ÎÞ·¨Æô¶¯£¨»ò´´½¨£©Êý¾Ý¿âµÄÇé¿ö¡£ËùÒÔÏëÒªÁ¬½ÓÊý¾Ý¿â£¬ÎÒÃÇÒªÓÃijÖÖÍⲿÉí·ÝÑéÖ¤£º×÷ΪOracleÈí¼þÓµÓÐ×éµÄÒ»¸ö³ÉÔ±£¬Í¨¹ýϵͳ½øÐÐÉí·ÝÑéÖ¤£»Í¨¹ý¸ø³ö´æÔÚÓÚÍⲿ¿ÚÁîÎļþµÄij¸öÓû§Ãû¿ÚÁî×éºÏ½øÐÐÉí·ÝÑéÖ¤¡£
CONNECTÃüÁî¿ÉÄܾßÓÐÏÂÁÐÓï·¨£º
?[Copy to clipboard]View Code SQL
SQL> connect user/pass[@db]
ÕâÊDZê×¼µÄÊý¾Ý×ÖµäÉí·ÝÑéÖ¤£¬Oracle»áÒÀ¾ÝÊý¾Ý×ÖµäÖеĴ洢ֵÀ´ÑéÖ¤Óû§Ãû/¿ÚÁî×éºÏ£¬´ËʱÊý¾Ý¿â±ØÐë±»´ò¿ª¡£
?[Copy to clipboard]View Code SQL
SQL> connect user/pass[@db] as sysdba
SQL> connect user/pass[@db] as sysoper
OracleÍⲿ¿ÚÁîÎļþÑéÖ¤Óû§Ãû/¿ÚÁî×éºÏ¡£
?[Copy to clipboard]View Code SQL
SQL> connect / as sysdba
SQL> connect


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÃÜÂëÎļþµÄ´´½¨£º

¡¡¡¡ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME\DATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪPWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´¡¡£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽ ......

OracleÊý¾Ý¿âÃÜÂëÎļþÖÐÔö¼Ó¡¢É¾³ýÓû§£º

µ±³õʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILEÉèÖÃΪEXCLUSIVEʱ£¬ÏµÍ³ÔÊÐí³ýINTERNAL/SYSÒÔÍâµÄÆäËûÓû§ÒÔ¹ÜÀíÔ±Éí·Ý´ÓÔ¶¶Ë»ò±¾»úµÇ¼µ½OracleÊý¾Ý¿âϵͳ£¬Ö´ÐÐÊý¾Ý¿â¹ÜÀí¹¤×÷;ÕâЩÓû§Ãû±ØÐë´æÔÚÓÚÃÜÂëÎļþÖУ¬ÏµÍ³²ÅÄÜʶ±ðËûÃÇ¡£ÓÉÓÚ²»¹ÜÊÇÔÚ´´½¨Êý¾Ý¿âʵÀýʱ×Ô¶¯´´½¨µÄÃÜÂëÎļþ£¬»¹ÊÇʹÓù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨µÄÃÜÂëÎļþ£¬¶ ......

Oracle Job ²»Ö´ÐÐ

¹ØÓÚOracle Job ²»Ö´ÐÐ
2008-11-11 19:48
ÎÒÃÇÓõÄÉú²ú»·¾³JobÊÇ¿ÉÒÔÕý³£Ö´ÐеÄ,µ«ÊÇÔÚ²âÊÔ»·¾³ÊDz»¿ÉÒÔÖ´ÐеÄ
ÔÚÍøÉϲéÁËÒ»ÏÂÔ­ÒòÈçÏÂ
SQL> show parameter job
NAME                        ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨2£©£º°²×°Oracle Database 10G

ÏëÔÚLinuxϵͳ°ÑOralce°²×°ºÃ£¬È·ÊµÊǸö²»Ð¡µÄÌôÕ½£¬×îÆðÂëµÄ£¬Ê×ÏÈÒª¶ÔLinuxϵͳÓÐËùÁ˽⣬²»Ëµ¶àµÄ£¬¼òµ¥µÄһЩÅäÖÃÎļþºÍ³£ÓÃÃüÁî×ÜÒªÖªµÀ£¬Òª²»Õæ²»ÖªµÀÈçºÎÏÂÊÖ¡£½ñÌì°´Êé±¾µÄÆôʾ£¬ºÍÍøÉϱðÈËдµÄÎÄÕ»¹ÓÐOralce¹Ù·½µÄ°ïÖú¸Ð¾õ¶¼¶ÔÎÒ°ïÖúÉõ΢°¡¡£¡£¡£²»¹ý¸Ð¾õ×îºó»¹ÊÇÔÚQQȺºÍ°Ù¶ÈµÄ°ïÖúÏ£¬µ±È»Êé±¾ºÍÄÇЩÎÄÕ¶¼Æðµ½ ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨3£©

ÊÖ¶¯½¨¿âÆäʵҲ¿ÉÒÔ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊDz»Ê¹ÓÃOMF´´½¨£¬ÁíÒ»ÖÖÊÇʹÓÃOMF´´½¨¡£
Ò»¡¢²»Ê¹ÓÃOMFÊÖ¶¯´´½¨Êý¾Ý¿â
1¡¢´´½¨Îļþ¼Ð¡££¨¸ù¾Ý¸Õ²Å/ora01/db/oracle/admin/ocpÖеÄĿ¼£¬ÎÒÃÇҲͬÑù´´½¨£©
?[Copy to clipboard]View Code BASH
$ mkdir /ora01/db/oracle/admin/mydb
$ cd /ora01/db/oracle/admin/mydb
$ mkdir bdum ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ