Oracle¹ÜÀíÓëά»¤.Êý¾Ý¿âµÇ¼µÄÉíÖ¤ÑéÖ¤
Oracle¹ÜÀíÓëά»¤.Êý¾Ý¿âµÇ¼µÄÉíÖ¤ÑéÖ¤
²Ýľ¹Ï
20080505
Ò»¡¢Ð´ÔÚÇ°Ãæ
Ôø¾²¢²»ÖªµÀconn / as sysdbaΪºÎÎÔÚunixϸãÁË°ëÌì·½Öª£¬»¹ÐèÒª¼ÓÉÏ"ºÅ£¬Oracle 10gÀï
ÖÕÓÚÒ²¿¼Âǵ½ÁËÕâ¸öÎÊÌ⣬²»ÔÙÊܵ½" as sysdba "µÄÏÞÖÆ¡£
ÈçÏÂËùʾ£º
[oracle@liwei admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 15:55:18 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
[oracle@liwei admin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 15:55:24 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
¶þ¡¢OracleµÇ¼ÈÏÖ¤·½Ê½
¡¶Oracle¹ÜÀíÓëά»¤.ÊÖ¹¤´´½¨Êý¾Ý¿âÒÔ¼°½Å±¾¡·Ò»ÎÄÖÐÌáµ½ÈçÏÂÒ»¸ö´íÎó£º
[oracle@liwei oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 14:51:59 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Õâ¸ö±ãÊǵǼÈÏÖ¤·½Ê½µÄÎÊÌâÁË¡£
OracleµÇ¼ÈÏÖ¤ÓÐÁ½ÖÖ·½Ê½£º»ùÓÚ²Ù×÷ϵͳµÄµÇ¼ÈÏÖ¤ºÍ»ùÓÚOracleÃÜÂëÎļþµÄµÇ¼ÈÏÖ¤¡£
¾ßÌ巽ʽ¼Ç¼ÔÚ·þÎñ¶Ë$ORACLE_HOME/network/admin/sqlnet.oraÎļþÖУ¬²»¹ýWindowsÓë
Unix/Linux¾ßÌåÉèÖÃÊDz»Í¬µÄ¡£
<Windows>
sqlnet.oraÎļþΪ¿Õʱ²ÉÓÃOracleÃÜÂëÎļþÑéÖ¤
SQLNET.AUTHENTICATION_SERVICES= (NTS) »ùÓÚ²Ù×÷ϵͳÑéÖ¤£»
SQLNET.AUTHENTICATION_SERVICES= (NONE) »ùÓÚOracleÃÜÂëÎļþÑéÖ¤
SQLNET.AUTHENTICATION_SERVICES= (NONE,NTS) ¶þÕß²¢´æ£¬×¢ÒâÊÇ°ë½Ç£¬·ñÔò²»Ê¶±ð
sqlnet.oraʾÀýÒ»£º
# This file is actually generated by netca. But if customers choose to
# install "Sof
Ïà¹ØÎĵµ£º
ÏîÄ¿¾ÀíÈÃ×öÀúÊ·Êý¾Ý±¸·Ý£¬Éæ¼°µ½ÈçºÎ½«ÒµÎñ±íÖеļǼµ¼³öµ½ÀúÊ·±íÖУ¬×Ô¼º×ʼÏëÄѵÀÊǸú×Ô¶¯¶ÔÕ˺Í×Ô¶¯ÉÏ´«³ÌÐòÒ»Ñùд¸ö³ÌÐòÈ»ºó½«³ÌÐò·ÅÔÚϵͳµÄÈÎÎñ¼Æ»®ÀﶨʱÔËÐУ¿»¹ÊÇÎÊÎÊÏîÄ¿¾Àí°É£¬ÎÊÏîÄ¿¾Àí£¬Äǵ¼³ö¼Ç¼Ôõô×ö¡£ÏîÄ¿¾Àí˵£¬Êý¾Ý¿âÀïÓ¦¸ÃÓÐÕâ¸ö¹¦ÄÜ°É¡£»ÐÈ»´óÎò£¬ÒþÔ¼¼ÇµÃÖ ......
×÷ΪÊý¾Ý¼¯³ÉµÄMOSS×é¼þBDC£¬ÔÚMOSS2007°æ±¾Öл¹Óкܶ಻³ÉÊìµÄµØ·½£¬ËäÈ»¿ÉÒÔ´æÈ¡ÆäËûÊý¾Ý¿âÖеÄÊý¾Ý£¬µ«ÅäÖÃȷʵºÜ¸´ÔÓ£¬È±Ê¡µÄ¹¤¾ßÒ²ºÜÈõ£¬ÕâÊÇÔÚÒ»¸öÏîÄ¿ÖÐÓõ½µÄÁ¬½ÓORACLEÊý¾Ý¿âÅäÖÃÎļþ£¬¼Í¼ÔÚ´ÎÒÔ±ãºóÓá£
<?xml version="1.0"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xm ......
Ò»¡¢²ÎÊýÉèÖÃ
--1¡¢ÉèÖÃA£º
db_block_size = 8192
db_domain = ''
db_file_multiblock_read_count = 16
db_name = bidata
db_recovery_file_dest = /export/home/app/oracle/oracle/product/10.2.0/db_1/flash_recovery_area
db_recovery_file_dest_size = 10737418240
dispatchers = '(PROTOCOL=TCP) (SERVICE=b ......