Oracle²Ù×÷ϵͳÈÏÖ¤
ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆÎªOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTHENTICATION_SERVICES
²ÎÊýÀ´¿ØÖƵġ£ÓÐÈý¸öÖµ¿ÉÈ¡£º
1¡¢NTS¡£Õâ¸ö²ÎÊýÊÇÖ÷»ú²Ù×÷ϵͳÊÇwindowsµÄʱºòרÓõġ£µ±ÔÚwindowsÉÏÉèÖøòÎ
Êýºó£¬¼´¿É½øÐÐOSÈÏÖ¤¡£ÐèҪעÒâµÄÊÇ£¬¸Ã²ÎÊýÊÇwindowsרÓõġ£Èç¹ûoracleÊÇ
×°ÔÚunixÀàϵͳÉÏ£¬OSÈÏÖ¤¶¼»áʧ°ÜµÄ¡£
2¡¢NONE¡£±íʾ²»×ö²Ù×÷ϵͳÈÏÖ¤£¬¼´ÒªÇóÊäÈëÃÜÂë¡£
3¡¢ALL¡£¼´ËùÓÐÈÏÖ¤·½Ê½¶¼¿ÉÒÔ¡£
ËùÒÔÒªÔÚÖ÷»úÉϽøÐÐosÈÏÖ¤Ö±½ÓµÇ¼sys as sysdba£¬Ö»ÒªÉ趨ΪALL»òÕß²»É趨¸Ã²ÎÊý£¨
¼´×¢Ê͵ô¸ÃÐУ©¾ÍÐÐÁË¡£
Èç¹ûÒª½ûÖ¹OSÈÏÖ¤£¬ÔòÖ»ÒªÉèÖÃΪNONE¼´¿É¡£
ÌâÍâ»°£º
¹ØÓÚOSÈÏÖ¤µÄ£¬Æäʵһ¿ªÊ¼Óëremote_login_passwordfile»ìÏýÆðÀ´ÁË¡£
1¡¢OSÈÏÖ¤ÊÇÖ¸Ö÷»úÉϰ²×°OracleµÄÓû§µÄ¹ÜÀíÔ±µÇ¼ÈÏÖ¤·½Ê½¡£
2¡¢µ±Õâ¸ö¹ÜÀíÔ±³¢ÊÔͨ¹ýÍøÂçÀ´µÇ¼Oracle DBʱ£¬½«»áʧ°Ü¡££¨ÒÔÍøÂ緽ʽµÇ¼Êý¾Ý¿â£¬¼´Ê¹Í¨¹ý½«·Ç³£²»°²È«µÄ²ÎÊýremote_os_authentÉèÖÃΪtrue£¬²Ù×÷ϵͳÈÏÖ¤Ò²²»»áÉúЧ¡££©
ÒªÔÊÐíÔ¶³Ì¹ÜÀíÔ±sysµÇ¼Êý¾Ý¿â£¬ÔòÒªÇóÉèÖÃ
remote_login_passwordfile = exclusive
È»ºó´´½¨passowrd file£º
orapwd file=orapw$ORACLE_SID passwd=passwd entries=10 force=y
ÐèҪעÒâµÄÊÇÕâÀïµÄpassword fileÎļþÃüÃûÐèÒª·ûºÏÌØ¶¨µÄÕâ¸ö¸ñʽ£¬Èç¹ûÃüÃû²»¶Ô£¬ÏµÍ³½«»áÕÒ²»µ½Õâ¸öÃÜÂëÎļþ£¬¶ø²úÉú£º
08:38:36 idle> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
ÉÏÃæÕâ¸ö´íÎó¡£Ò²¾Íµ¼ÖÂÁËsysdba»òÕß¹ÜÀíÔ±Óû§²»ÄÜÔ¶³ÌµÇ¼Êý¾Ý¿â¡£
Òª¼ì²éÊÇ·ñÒѾ½«sysÓû§·ÅÈëÃÜÂëÎļþ£¬¿ÉÒÔ²éѯ£º
08:49:04 idle> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER
--------------- --------------- -------------------
SYS TRUE &
Ïà¹ØÎĵµ£º
ÐÞ¸ÄOracleµÄ½ø³ÌÊý[processes]¼°»á»°Êý[sessions]
1.ͨ¹ýSQLPlusÐÞ¸Ä
OracleµÄsessionsºÍprocessesµÄ¹ØÏµÊÇ
sessions=1.1*processes + 5
ʹÓÃsys£¬ÒÔsysdbaȨÏ޵Ǽ£º
SQL> show parameter processes;
NAME &n ......
ORACLE³£ÓÃÃüÁî
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂ
ÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR& ......
1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄ
Êý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´
²Ù×÷Ïൠ......
ϵͳȨÏÞ£º »ØÊÕʱ²»»á²úÉú¼¶Áª»ØÊÕ
conn / as sysdba;
create user t1 identified by t1;
create user t2 identified by t2;
grant connect to t1,t2;
grant create table, create view to t1 with admin option;
conn t1/t1
grant create table to t2;
conn / as sysdba;
select * from dba_sys_privs where gra ......
ÒÔϼ¸ÖÖÔ¼Êø ¡¢²¢ Ò»Ò»Áо٣º
1.Ö÷¼üÔ¼Êø£º
Òª¶ÔÒ»¸öÁмÓÖ÷¼üÔ¼ÊøµÄ»°£¬ÕâÁоͱØÐëÒªÂú×ãµÄÌõ¼þ¾ÍÊÇ·Ö¿Õ
ÒòΪÖ÷¼üÔ¼Êø£º¾ÍÊǶÔÒ»¸öÁнøÐÐÁËÔ¼Êø£¬Ô¼ÊøÎª£¨·Ç¿Õ¡¢²»Öظ´£©
ÒÔÏÂÊÇ´úÂë Òª¶ÔÒ»¸öÁмÓÖ÷¼ü£¬ÁÐÃûΪid,±íÃûΪemp
¸ñʽΪ£º
alter table ±í¸ñÃû³Æ add constraint Ô¼ÊøÃû³Æ Ôö¼ÓµÄÔ¼ÊøÀàÐÍ £¨ÁÐÃû£©
À ......