ÐÞ¸ÄOracleÓû§ÃÜÂëµÄС¾÷ÇÏ
ÓÐʱºòÎÒÃÇ¿ÉÄܲ»ÖªµÀÒ»¸öÓû§µÄÃÜÂ룬µ«ÊÇÓÖÐèÒªÒÔÕâ¸öÓû§×öһЩ²Ù×÷£¬ÓÖ²»ÄÜÈ¥Ð޸ĵôÕâ¸öÓû§µÄÃÜÂ룬Õâ¸öʱºò£¬¾Í¿ÉÒÔÀûÓÃһЩСÇÏÃÅ£¬À´Íê³É²Ù×÷¡£
¾ßÌå²Ù×÷¹ý³ÌÈçÏ£º
SQL*Plus: Release 9.2.0.5.0 - Production on ÐÇÆÚÈÕ 11ÔÂ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/oracle as sysdba
ÒÑÁ¬½Ó¡£
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS 8A8F025737A9097A
SYSTEM 2D594E86F93B17A1
DBSNMP E066D214D5421CCC
TOAD A1BA01CF0DD82695
OUTLN 4A3BA55E08595C81
WMSYS 7C9BA362F8314299
ÒÑÑ¡Ôñ6ÐС£
SQL> connect system/oracle
ÒÑÁ¬½Ó¡£
SQL> connect sys/oracle as sysdba
ÒÑÁ¬½Ó¡£
ÐÞ¸ÄÓû§systemÃÜÂëΪmanager
SQL> alter user system identified by manager;
Óû§ÒѸü¸Ä¡£
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS 8A8F025737A9097A
SYSTEM D4DF7931AB130E37
DBSNMP E066D214D5421CCC
TOAD A1BA01CF0DD82695
OUTLN 4A3BA55E08595C81
WMSYS 7C9BA362F8314299
ÒÑÑ¡Ôñ6ÐС£
SQL> connect system/manager
ÒÑÁ¬½Ó¡£
È»ºó´Ëʱ¿ÉÒÔ×öÏëÒª×öµÄÈκβÙ×÷ÁË
SQL> connect sys/oracle as sysdba
ÒÑÁ¬½Ó¡£
ÐÞ¸ÄÓû§systemÃÜÂëΪÒÔÇ°µÄÖµ
SQL> alter user system identified by values '2D594E86F93B17A1';
Óû§ÒѸü¸Ä¡£
SQL> connect system/oracle
ÒÑÁ¬½Ó¡£
SQL> connect sys/oracle as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect system/manager
ERROR:
ORA-01017: invalid username/password; logon denied
¾¯¸
Ïà¹ØÎĵµ£º
ѧÉúÔÚѧϰjdbcµÄʱºò£¬»áÎʵ½Ôõôµ÷Óô洢¹ý³Ì£¬ÏÖÔÚ½«javaµ÷ÓÃoracle´æ´¢¹ý³ÌµÄʾÀý×ܽáÈçÏ¡££¨¹ØÓÚµ÷ÓÃsqlserverµÄ´æ´¢¹ý³Ì½«ÔÚÏ´νøÐÐС½áÇë¹Ø×¢£©
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
• create or replace procedure adddept(deptno number,dname varc ......
Æô¶¯“OracleDBConsole”ʱ£££³öÏÖ“Agent process exited abnormally during initialization.”
ÔÚÔËÐÐ"emctl start dbconsole "¡¡·¢ÏÖÊÇÕÒ²»µ½Ö¸¶¨Îļþ,ÔÚÍøÉÏÕÒÁËÒ»ÏÂÔÒò, ¸ü¸ÄµÄÖ¸¶¨Îļþ¼ÐµÄÃû³Æ£¬µ«»¹ÊDz»ÄÜÆô¶¯·þÎñ£¬½á¹ûÈÏÕæ¿´ÁËһϣ¬ÊÇCTRL+C,CTRL+V È»ºó²ÅÆô¶¯³É¹¦£¬ËùÒÔÌض¨Ð´ÏÂÀ´£¬¼Ç ......
×î½ü×ܽáÁËÒ»ÏÂoracleÖ÷¼üµÄÉèÖ÷½·¨£¬Ìùµ½Õâ±£´æһϰɡ£ ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÉèÖÃÖ÷¼ü£¬Ò»ÖÖÊÇ×ÔÔö³¤Ö÷¼ü£¬ÁíÒ»ÖÖ¾ÍÊÇÉú³ÉΨһÐòÁС£ Ò»¡¢×ÔÔö³¤Ö÷¼ü --Ê×ÏȽ¨Ò»¸ö±íTEST
create tableTEST (
NID int PRIMARY KEY,
test1 varchar2(20),
test2 varchar2(20),
test3 ......