Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨10£©£ºÊ¹ÓÃPL/SQL½øÐÐOracle±à³Ì

1¡¢±à³ÌÓïÑÔÓëOracleÊý¾Ý¿â
1.1¡¢´æ´¢µÄÓëÄäÃûµÄPL/SQL³ÌÐò¿é
Óë´æ´¢µÄPL/SQL³ÌÐò¿éÏà±È£¬ÄäÃûµÄPL/SQL³ÌÐò¿éЧÂʽϵͣ¬´ËÍâÓÉÓÚ¿ÉÄÜÔÚ¶ą̀»úÆ÷Öй«²¼Ô´´úÂ룬»¹»áÒý·¢¹ÜÀíÎÊÌâ¡£
1.2¡¢PL/SQL¶ÔÏó
PL/SQL¶ÔÏó¾ßÓÐÏÂÁÐ5ÖÖÀàÐÍ£º
¹ý³Ì
º¯Êý
³ÌÐò°ü
³ÌÐò°üÖ÷Ìå
´¥·¢Æ÷
2¡¢¹ý³Ì¡¢º¯ÊýÒÔ¼°³ÌÐò°ü
2.1¡¢¹ý³ÌÓëº¯Ê ......

Java²Ù×÷OracleÊý¾Ý¿â£¨½¨±í£¬²åÊý¾Ý£¬É¾³ý£©

ÓÃjpa²»Äܽ¨±í£¬sqlÓï¾äÊǶԵ쬲»¹ý¾ÍÊDz»Äܽ¨£¬Í¬ÑùµÄsql£¬ÔÚÏÂÃæµÄjdbcÖоͿÉÒÔ£¬¿ÉÄÜÊÇ¿ò¼ÜµÄÏÞÖÆ£¬Ï£Íû¸ßÈËÖ¸µã
import java.net.URL;
import java.sql.*;
public class Create {
public Create() {
}
public static void main(String[] args){
String url = "jdbc:oracle:thin:@10.0.1.3:1521:SDCDB" ......

oracle ÐÔÄÜÖ¸±êͼ


Ö¸±êÃû³Æ
 
Ö¸±êÃèÊö
 
Ö¸±ê·¶Î§
 
Ö¸±êµ¥Î»
1£®¹ØÓÚʵÀýЧÂÊ£¨Instance Efficiency Percentages£©µÄÐÔÄÜÖ¸±ê
 
»º³åÇøÎ´µÈ´ýÂÊ
 
(Buffer Nowait %)
Ö¸ÔÚ»º³åÇøÖлñÈ¡BufferµÄδµÈ´ý±ÈÂÊ¡£
¸ÃÖ¸±êµÄÖµÓ¦½Ó½ü100%£¬Èç¹û¸ÃÖµ½ÏµÍ£¬Ôò¿ÉÄÜÒªÔö´óbuffer cache¡£
%
Redo»º³åÇøÎ´µÈ´ý ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨1£©£ºOracleµÄ»ù±¾¸ÅÄî

ÏÈÀ´Á˽âϼ¸¸öÓ¢Îĵļò³Æ£¬ÔÚÒÔºó¾­³£»á¼ûµ½¡£
¶ÔÏó¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨Object Relational Database Management System£¬¼ò³ÆORDBMS£©
¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨Relational Database Management System£¬¼ò³ÆRDBMS£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£¬¼ò³ÆDBMS£©
½á¹¹»¯²éѯÓïÑÔ£¨Structured Query Langua ......

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ºÅ