|
|
[ÀϹÝ] ORACLEÀÌ DEFAULT·Î »ý¼ºÇØÁÖ´Â DATABASE USERS |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:3600 |
|
|
No. 17189
(V8.X. ~ V9.X) ORACLEÀÌ DEFAULT·Î »ý¼ºÇØÁÖ´Â DATABASE USERS
===========================================================
PURPOSE
-------
ÀÌ ÀÚ·á´Â µ¥ÀÌŸº£À̽º ³»¿¡ DEFAULT·Î »ý¼ºµÇ´Â °¢ userµé¿¡ ´ëÇÑ ¼³¸íÀÌ´Ù.
Explanation
-----------
´ÙÀ½Àº µ¥ÀÌŸº£À̽º »ý¼º ½Ã °°ÀÌ »ý¼ºµÇ´Â userµéÀÇ listÀÌ´Ù.
1) Default·Î µ¥ÀÌŸº£À̽º°¡ »ý¼ºµÇ´Â µ¿¾È ÀÚµ¿À¸·Î »ý¼ºµÇ´Â user´Â ´ÙÀ½°ú °°´Ù.
SCOTT by script $ORACLE_HOME/rdbms/admin/utlsampl.sql
OUTLN by script $ORACLE_HOME/rdbms/admin/sql.bsq
2) ´ÙÀ½Àº OptionalÇÏ°Ô ¼±ÅÃÇÒ ¼ö ÀÖ´Â userµéÀÌ´Ù.
DBSNMP if Enterprise Manager Intelligent Agent is installed
TRACESVR if Enterprise Manager is installed
AURORA$ORB$UNAUTHENTICATED \
AURORA$JIS$UTILITY$ -- if Oracle Servlet Engine (OSE) is installed
OSE$HTTP$ADMIN /
MDSYS if Oracle Spatial option is installed
ORDSYS if interMedia Audio option is installed
ORDPLUGINS if interMedia Audio option is installed
CTXSYS if Oracle Text option is installed
REPADMIN if Replication Option is installed
Oracle9i Sample Schemas if you need to test through a complete sample
system of information
°¢ userµé¿¡ ´ëÇÑ ¼³¸íÀ» Çϳª¾¿ º¸±â·Î ÇÑ´Ù.
A) SCOTT user´Â sample user tableµéÀ» Á¦°øÇϱâ À§ÇØ default·Î »ý¼ºµÈ´Ù.
SCOTT userÀÇ password¸¦ º¯°æÇÒ ¼ö ÀÖ°í, default tableµéÀ» »ý¼ºÇϱâ
À§Çؼ´Â ´ÙÀ½ÀÇ ½ºÅ©¸³Æ®¸¦ ¼öÇàÇÏ¸é µÈ´Ù.
$ORACLE_HOME/sqlplus/demo/demobld.sql
¶ÇÇÑ, ±× default tableµéÀ» dropÇϱâ À§Çؼ´Â, ´ÙÀ½ÀÇ ½ºÅ©¸³Æ®¸¦ ¼öÇàÇÑ´Ù.
$ORACLE_HOME/sqlplus/demo/demodrop.sql
B) OUTLN user´Â Oracle8i¿Í Oracle9i ¼¹ö¸¦ installÇÏ´Â µ¿¾È ÀÚµ¿À¸·Î »ý¼ºµÈ´Ù.
OUTLNÀº Stored OutlinesÀÇ schema ÀÌ´Ù.
OUTLN_PKG ¶ó´Â package´Â stored outlines¿Í categories¸¦ °ü¸®ÇÏ´Â µ¥
»ç¿ëµÈ´Ù.
OUTLN user´Â OL$, OL$HINTS(Oracle8i) table°ú OL$NODES(Oracle9i) tableÀÇ
ownerÀÌ´Ù. ÀÌ tableµéÀº stored outlinesÀÇ hint¸¦ ÀúÀåÇϱâ À§ÇØ »ç¿ëµÈ´Ù.
OUTLN userÀÇ password´Â SYS ¶Ç´Â SYSTEM user°¡ º¯°æÇÒ ¼ö ÀÖ´Ù.
C) TRACESVR user´Â OEMÀ» installÇÏ´Â µ¿¾È¿¡ »ý¼ºµÇ´Âµ¥,
$ORACLE_HOME/otrace/admin/otrcsvr.sql ½ºÅ©¸³Æ®¿¡ ÀÇÇؼ »ý¼ºµÈ´Ù.
¸¸¾à, TRACESVR userÀÇ password¸¦ º¯°æÇÑ´Ù¸é OTrace collectionÀ»
¼öÇàÇÒ ¼ö ¾ø°Ô µÈ´Ù.
ÀÌ user´Â data collectionÀ» start/stopÇϱâ À§Çؼ stored procedure°¡
OTrace¿¡ ÀÇÇØ »ç¿ëµÇ´Â 7.x µ¥ÀÌŸº£À̽º¿¡¼¸¸ »ç¿ëµÈ´Ù.
TRACESVR/stored procedure ¸ÞÄ¿´ÏÁòÀº 8.x µ¥ÀÌŸº£À̽º¿¡¼´Â OTrace
collections startingÀ» controlÇϱâ À§Çؼ ´õÀÌ»ó »ç¿ëµÇÁö ¾Ê´Â´Ù.
±×·¯¹Ç·Î, ÀÌ °æ¿ì¿¡´Â TRACESVR userÀÇ password¸¦ º¯°æÇصµ µÇ°í,
user¸¦ dropÇÏ´Â °Íµµ °¡´ÉÇÏ´Ù.
D) DBSNMP user´Â catnsnmp.sql ½ºÅ©¸³Æ®¸¦ ¼öÇàÇϸé dropÇÒ ¼ö ÀÖ´Ù.
¸¸¾à, ½Ç¼ö·Î dropÇÏ¿© ´Ù½Ã »ý¼ºÇϱâ À§Çؼ´Â catsnmp.sql ½ºÅ©¸³Æ®¸¦
¼öÇàÇÏ¸é µÈ´Ù. ´Ü, ½ºÅ©¸³Æ®¸¦ ¼öÇàÇϱâ Àü¿¡ OEM¿¡ ¼öÇà ÁßÀÎ job
¶Ç´Â schedulµÈ jobÀÌ ¾ø¾î¾ß ÇÑ´Ù.
E) ¼¼ °¡ÁöÀÇ JSERV account(AURORA$JIS$UTILITY$, AURORA$ORB$UNAUTHENTICATED
and OSE$HTTP$ADMIN)°¡ Àִµ¥, ÀÌ userµéÀº Enterprise Java Beans¿Í
CORBA Tools¿¡ ÀÇÇؼ ³»ºÎÀûÀ¸·Î »ç¿ëµÇ°í, randomÇÏ°Ô generateµÈ
password Áï, 'INVALID_ENCRYPTED_PASSWORD' ¸¦ °¡Áö°í »ý¼ºµÈ´Ù.
-> jisorb.sql ½ºÅ©¸³Æ®´Â AURORA$ORB$UNAUTHENTICATED user¸¦ »ý¼ºÇÑ´Ù.
-> jisbgn.sql ½ºÅ©¸³Æ®´Â AURORA$JIS$UTILITY$ user¸¦ »ý¼ºÇÑ´Ù.
-> jishausr.sql ½ºÅ©¸³Æ®´Â OSE$HTTP$ADMIN user¸¦ »ý¼ºÇÑ´Ù.
ÀÌ ¼¼ °³ÀÇ ½ºÅ©¸³Æ®´Â Oracle Servlet Engine(OSE)À» installÇϱâ À§ÇÑ
init_jis.sql ½ºÅ©¸³Æ®¿¡ ÀÇÇØ launchµÈ´Ù.
ÀÌ userµéÀÇ password¸¦ º¯°æÇÏ°Ô µÇ¸é ORB°¡ µ¿ÀÛÇÏÁö ¾Ê°Ô µÈ´Ù.
F) MDSYS, ORDSYS, CTXSYS, ORDPLUGINS userµéÀº Oracle intermedia¸¦
supportÇϱâ À§ÇØ »ý¼ºµÈ´Ù. ORDSYS userÀÇ default password´Â ORDSYSÀÌ°í,
ORDPLUGINS userÀÇ default password´Â ORDPLUGINSÀÌ´Ù.
ÀÌ userµéÀÇ password¸¦ º¯°æÇÏ·Á¸é installationÀÌ ¿Ï°áµÇ¾úÀ» ¶§ º¯°æÇؾß
ÇÑ´Ù.
G) REPADMIN user : replication administrator ¿ëÀ¸·Î µû·Î user¸¦ µÎ¾î¾ß ÇÑ´Ù.
Master groupÀ» º¸È£Çϱâ À§Çؼ´Â snapshot administrator°¡ °ü¸®ÇÏ´Â ºÎºÐ°ú
º°µµ·Î °ü¸®Çϱâ À§ÇØ ÇÊ¿äÇÏ´Ù.
ÀÌ user´Â replicated environment¸¦ ±¸¼ºÇÏ°í, ¸ðµç replicated schema¿Í
groupµéÀ» °ü¸®ÇÏ´Â ÀÛ¾÷µéÀ» ¼öÇàÇÑ´Ù.
H) Oracle 9i Sample schema Áß¿¡´Â »õ·Î¿î schema°¡ Àִµ¥, demonstration
¸ñÀûÀ¸·Î ÁÖ·Î »ç¿ëµÈ´Ù°í º¸¸é µÈ´Ù.
--> HR : Human Resources schema.
companyÀÇ employees¿Í facilities¿¡ ´ëÇÑ Human Resources division
information
--> OE : Order Entry schema requires "Oracle Spatial" option.
´Ù¾çÇÑ channelµéÀ» ÅëÇÑ company productsÀÇ sales¿Í product
inventories¿¡ ´ëÇÑ information
--> PM : Product Media schema requires "Oracle JVM" and "Oracle
Intermedia".
±× ȸ»ç¿¡ ÀÇÇØ ÆÇ¸ÅµÈ °¢ productÀÇ »ó¼¼ÇÑ Á¤º¸¿Í description.
--> SH : Sales History schema requires "Oracle OLAP Services" set up.
business decisionsÀ» ÀÌ·ç±â À§ÇÑ business statistics.
--> QS : Queued Shipping schema.
°¢ customer¿¡ ´ëÇÑ productÀÇ shippingÀ» °ü¸®.
--> QS_ES (Eastern Shipping)
--> QS_WS (Western Shipping)
--> QS_OS (Overseas Shipping)
--> QS_CB (Customer Billing)
--> QS_CS (Customer Service)
--> QS_ADM (Administration)
--> QS_CBADM (Customer Billing Administration)
¸¸¾à, installÇÏ´Â µ¿¾È user account°¡ lockµÇ¾î ÀÖ°í, password°¡ expireµÇ¾ú´Ù¸é
lockÀ» ´ÙÀ½°ú °°ÀÌ Ç®¾îÁÖ°í, »õ·Î¿î password¸¦ user account¿¡°Ô ÇÒ´çÇØÁØ´Ù.
Example
-------
none
Reference Documents
-------------------
<Note:160861.1>
|
|
|
|
|
|