OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨12£©£ºÅäÖÃOracle»¥Áª
1¡¢Oracle NetÓëͨÐÅÐÒé¼ò½é
OracleµÄÍøÂçÖ§³Ö±»ÏÞÖÆÓÚTCP¡¢ÃüÃû¹ÜµÀ£¨Named Pipes£¬¼òдSDP£©¡£ËùÓеIJÙ×÷ϵͳ¶¼¾ßÓÐÒ»¸ö±¾²Ù×÷ϵͳרÓеĽø³Ì¼äͨÐÅ£¨Inter-Process Communication£¬¼òдIPC£©ÐÒé¡£
2¡¢½¨Á¢»á»°
ͨ¹ýÓû§½ø³Ì½¨Á¢Õë¶ÔʵÀýµÄ»á»°£¬¿ÉÒÔÖ´ÐУº
?[Copy to clipboard]View Code SQL
SQL> connect scott/tiger@ora
Ê×ÏÈ£¬½«Õâ¸öÃüÁî·Ö½âΪÏÂÁÐ×é¼þ£ºÊý¾Ý¿âÓû§Ãû“scott”£¬¿ÚÁî“tiger”£¬·Ö¸ôÓû§Óë¿ÚÁîµÄ“/”£¬“@”·ûºÅ£¬Á¬½Ó´®“ora”¡£ÆäÖГ@”·ûºÅָʾÁËÍøÂçÁ¬½ÓËùÐèµÄÓû§½ø³Ì¡£Èç¹ûÊ¡ÂÔ“@”·ûºÅÓëÁ¬½Ó´®£¬ÄÇôÓû§½ø³Ì±»È϶¨Á¬½ÓʵÀýÔÚ±¾µØ»úÆ÷ÉÏÔËÐУ¬²¢ÇÒʼÖÕÄܹ»Ê¹ÓÃIPCÐÒé¡£Èç¹ûÃüÁîÖаüº¬“@”·ûºÅÓë×Ö·û´®£¬Óû§Àï³ÌÈ϶¨ÊÇÇëÇóÁ¬½ÓÔ¶³Ì»úÆ÷ÉϵÄÒ»¸öʵÀý¡£
2.1¡¢Á¬½Ó±¾µØʵÀý
ËùÓÐOracle»á»°¶¼Ê¹ÓÃÁËÍøÂçÐÒé¡£²»¹ý±¾µØÁ¬½ÓËùʹÓõÄÍøÂçÐÒéΪIPC¡£IPCÓɲÙ×÷ϵͳÌṩ£¬²¢ÔÊÐí¸÷ÖÖ½ø³ÌÔÚÖ÷»úÄÚ½øÐÐͨÐÅ¡£±¾µØÁ¬½ÓÊÇΨһ²»ÐèÒªÕìÌýÆ÷µÄÁ¬½ÓÀàÐÍ¡£±¾µØÁ¬½Ó²»±Ø½øÐÐÈκÎÅäÖᣱ¾µØ¼ÆËã»ú¿ÉÒÔÔËÐÐÈô¸ÉʵÀý£¬Í¨¹ý»·¾³±äÁ¿ÎªÓû§½ø³ÌÌṩϣÍûÁ¬½ÓµÄʵÀý¡£
?[Copy to clipboard]View Code SQL
$ export ORACLE_SID=ocp
$ sqlplus / as sysdba
SQL> startup
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
ocp
SQL> exit
$ export ORACLE_SID=ora
$ sqlplus / as sysdba
SQL> startup
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
ora
2.2¡¢Ãû³Æ½âÎö
ʹÓÃOracle Net½øÐÐÁ¬½Óʱ£¬µÚÒ»¸ö½×¶ÎÊÇ·¢ÏÖʵ¼ÊÏ£ÍûÁ¬½ÓµÄʵÀý¡£Õâ¸ö½×¶Î¾ÍÊÇÃû³Æ½âÎö¹ý³Ì¡£Èç¹ûÁ¬½Ó´®Îª“ora”£¬ÄÇOracle Net¾Í±ØÐëÀí½â“ora”µÄº¬Òå¡£Á¬½Ó´®µÄº¬Òå±»½âÎöΪÏÂÁÐ4²¿·Ö£ºÏ£ÍûʹÓõÄÐÒ飨ͨ³£È϶¨ÎªTCP£©£¬ÔËÐÐÊý¾Ý¿âÕìÌýÆ÷µÄIPµØÖ·£¨Ö÷»úÃûÒ²¿É£¬Ö÷»úÃûÒ²»á±»½âÎö³ÉIP£©£¬ÕìÌýÆ÷¼àÊÓÒýÈëÁ¬½ÓÇëÇóµÄ¶Ë¿Ú£¬Ï£ÍûÁ¬½ÓµÄʵÀýÃû³Æ£¨¿ÉÄÜÊÇ“·þÎñ”Ãû³Æ£¬ÒòΪRACÒ»¸ö“·þÎñ”ÃûÓÉÐí¶àʵÀý×é³É£©¡£
2.3¡¢Æô¶¯·þÎñÆ÷½ø³Ì
·þÎñÆ÷ÉÏÔËÐÐÊý¾Ý¿âÕìÌýÆ÷ʹÓÃÒ»ÖÖ»ò¶àÖÖÐÒéÔÚÈô¸ÉÍøÂç½Ó¿Ú¿¨ÉϵÄÈô¸É¶Ë¿Ú¼àÊÓÒýÈëÁ¬½ÓÇëÇó¡£Èç¹ûÊÇһ̨»úÆ÷ÔËÐ
Ïà¹ØÎĵµ£º
1. ²é¿´ÃÜÂëÎļþÖеijÉÔ±£º
¿ÉÒÔͨ¹ý²éѯÊÓͼV$PWFILE_USERSÀ´»ñÈ¡ÓµÓÐSYSOPER/SYSDBAϵͳȨÏÞµÄÓû§µÄÐÅÏ¢£¬±íÖÐSYSOPER/SYSDBAÁеÄÈ¡ÖµTRUE/FALSE±íʾ´ËÓû§ÊÇ·ñÓµÓÐÏàÓ¦µÄȨÏÞ¡£ÕâЩÓû§Ò²¾ÍÊÇÏàÓ¦µØ´æÔÚÓÚÃÜÂëÎļþÖеijÉÔ±¡£
2. À©Õ¹ÃÜÂëÎļþµÄÓû§ÊýÁ¿£º
µ±ÏòOracleÊý¾Ý¿âÃÜÂëÎļþÌí¼ÓµÄÕʺÅÊýÄ¿³¬¹ý´´½¨ÃÜÂëÎļþʱ ......
OracleÈëÃÅÊé¼®ÍƼö
ºÜ¶àÅóÓÑÒªÎÒ°ïæÍƼöÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²á ......
´´½¨±íµÄÓï·¨
-´´½¨±í¸ñÓï·¨:
create table ±íÃû(
×Ö¶ÎÃû1 ×Ö¶ÎÀàÐÍ(³¤¶È) ÊÇ·ñΪ¿Õ,
×Ö¶ÎÃû2 ×Ö¶ÎÀàÐÍ ÊÇ·ñΪ¿Õ
);
-Ôö¼ÓÖ÷¼ü
alter table ±íÃû add constraint Ö÷¼üÃû primary key (×Ö¶ÎÃû1);
-Ôö¼ÓÍâ¼ü:
alter table ±íÃû
  ......
1¡¢µ÷ÕûĬÈϵݲȫÉèÖÃ
1.1¡¢Ä¬ÈϵÄÓû§
²é¿´Êý¾Ý¿âµÄÓû§ºÍ״̬£¬¿ÉÒÔ²éѯDBA_USERSÊÓͼ¡£
?[Copy to clipboard]View Code SQL
SQL> select username,account_status from dba_users;
1.2¡¢PUBLICȨÏÞ
OracleÖдæÔÚÒ»¸öÃûΪPUBLICµÄαÓû§¡£Ö»ÒªÓÃPUBLICÊÚÓèij¸öȨÏÞ£¬ÄÇôËùÓÐÓû§¶¼»á±»ÊÚÓèÕâ¸öȨÏÞ¡£
?[Copy ......