LinuxÉϵǼoracle±¨´íÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÔÚLinuxÉÏÏȵǼΪoracleÓû§ºó£¬ÔÙÖ´ÐÐsqlplus '/as sysdba'ʱ±¨´í£¬
SQL*Plus: Release 10.2.0.4.0 - Production on ÐÇÆÚÈý 4ÔÂ 21 16:29:38 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
È»ºóÎÒÔÚuser-name:ºóÃæÊäÈëÊý¾Ý¿âµÄÓû§ÃûºÍÃÜÂëºó¾Í¿ÉÒÔÕý³£½øÈëoracleÃüÁîÐÐÁË¡£
µ«ÎÒÔÚ±ðµÄLinuxÖ÷»úÉÏÈ´²¢Ã»ÓÐÕâ¸öÎÊÌ⣬ִÐÐÍêsqlplus '/as sysdba'¾Í¿ÉÒÔ½øÈëoracleÃüÁîÐÐÁË
ÇëÎÊÊÇʲôÔÒòÄØ
Äã˵µÄÊÇÕâÑùµÄ°É
SQL> CONN /AS SYSDBA
ÒÑÁ¬½Ó¡£
ERROR:
ORA-01031: insufficient privileges
export ORACLE_SID=ʵÀýÃû
sqlplus /nolog
conn / as sysdba
1¡¢Ò»¶¨ÒªÔ¶³Ìµ½Êý¾Ý¿âËùÔڵķþÎñÆ÷ÉÏ
2¡¢Ò»¶¨ÒªÉèÖÃORACLE_SID£¬Ö÷Òª»·¾³±äÁ¿ÃûºÍʵÀýÃû¶¼Òª´óд
Èç¹û»¹ÓÐÎÊÌâ¾ÍÕÒÎÒ
²»ÊÇ£¬¾ÍÊÇÎÒ˵µÄÄÇÖÖÇé¿ö
Äã˵µÄÕâÖÖÇé¿öÎÒÔÚÍøÉÏ¿´µ½¹ý£¬²»¹ý²»Ò»Ñù
ÎÒÊÇÔÚһ̨·þÎñÆ÷ÉÏ×öµÄ¶Ë¿Úת·¢Á¬µ½ÁËÊý¾Ý¿âÉÏ£¬²»ÖªµÀÊDz»ÊÇÕâ¸öÔÒòÄØ
ûÈ˻ᰡ£¿£¿
²»¶®£¬°ï¶¥
End_rbody_64885567//-->
¸Ã»Ø¸´ÓÚ2010-04-22 14:24:52±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......