know ray

15 05, 2008

Ò»¸ö¹ØÓÚ·Ç¿ÕÔ¼Êøenable novalidateµÄ²âÊÔ

×÷Õß cyr1974 14:33 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (1) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

2 09, 2007

oracle 11gеĺǫ́½ø³Ì

×÷Õß cyr1974 14:43 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

VKTM - The virtual keeper of time provides wall-clock time and reference time for other sessions/processes.

ʱ¼ä²ÎÕÕ½ø³Ì£¬ÎªÆäËû½ø³ÌÌṩʱ¼ä²ÎÕÕ

FBAR - (sadly now renamed to FBDA partway through the beta) The flashback data archiver writes old row-versions of tables with 'flashback archive' enabled into flashback data archives on commit. Anyone remember Oracle v.5 BIFs?

flashback Êý¾Ý´æµµ½ø³Ì£¬¸ºÔðдÌá½»µÄ±ä»¯Êý¾Ýµ½¹éµµÎļþ¡£×¢Òâ²»Êǹ鵵ÈÕÖ¾

DIAG - The diagnosibility process (DIAG) runs oradebug commands and triggers diagnostic dumps as part of the new ADR (automatic diagnostic repository) feature, which is a replacement (and major enhancement) for the much-reviled RDA.

Õï¶Ï½ø³Ì£¬Ê¹ÓÃoradebugÃüÁîºÍ´¥·¢Æ÷À´·ÖÎö²úÉúµÄdumpÎļþ£¬È¡´úÊܵ½ÔðÂîµÄRDA

DIA0 - The "other" diagnosibility process detects hangs then triggers DIAG do take diagnostics.

¸¨ÖúÕï¶Ï½ø³Ì£¬¼ì²âÊý¾Ý¿â¹ÒÆ𣬴¥·¢diag½ø³Ì

SMCO/Wnnn - The space management coordinator and slaves perform space allocation and reclamation.

¿Õ¼ä¹ÜÀí½ø³Ì£¬Ö´ÐпռäµÄ·ÖÅäºÍ»ØÊÕ

18 05, 2007

ʹÓÃoracleÍⲿ±í¶ÁÈ¡ÎļþÊý¾Ý

×÷Õß cyr1974 16:18 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

1 ¡¢´´½¨Ä¿Â¼¼°ÊÚȨ

create directory exttab as 'F:oracleproduct10.2.0oradataexttab'

GRANT READ ON DIRECTORY exttab TO system;
GRANT WRITE ON DIRECTORY exttab TO system;

2¡¢×¼±¸Êý¾ÝÎļþµ½Ïà¹ØĿ¼

F:oracleproduct10.2.0oradataexttab>dir
Volume in drive F has no label.
Volume Serial Number is 5B8D-A9E4

Directory of F:oracleproduct10.2.0oradataexttab

2007-05-18 16:09 <DIR> .
2007-05-18 16:09 <DIR> ..
2007-05-18 15:17 221 1.dat
2007-05-18 14:49 300 1.dat.bak
2007-05-18 15:17 156 2.dat
2007-05-18 14:49 234 2.dat.bak
2007-05-18 15:32 591 EXTTEST2_2292_3356.log
2007-05-18 15:18 84 EXTTEST_2292_3356.bad
2007-05-18 15:18 2,860 EXTTEST_2292_3356.log
2007-05-18 15:12 84 EXTTEST_2292_3964.bad
2007-05-18 15:12 1,430 EXTTEST_2292_3964.log
2007-05-18 15:13 84 EXTTEST_2292_588.bad
2007-05-18 15:13 1,430 EXTTEST_2292_588.log
2007-05-18 16:09 244 EXTTXTM_2292_3356.bad
2007-05-18 16:11 1,536 EXTTXTM_2292_3356.log
2007-05-18 15:27 81 test2.txt
2007-05-18 16:05 121,756 txtm.txt
15 File(s) 131,091 bytes

3¡¢´´½¨Íⲿ±í

SQL> CREATE TABLE exttxtm
2 ( KEY_1 CHAR(31),
3 STAT CHAR(1),
4 TEXT CHAR(200),
5 TEXT_LENGTH CHAR(3),
6 TEXT_BOUND_LEN CHAR(3))
7 ORGANIZATION EXTERNAL
8 (TYPE ORACLE_LOADER
9 DEFAULT DIRECTORY exttab
10 ACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINE
11 FIELDS TERMINATED BY ',')
12 LOCATION('txtm.txt'));

Table created.
4¡¢Ð£ÑéÊý¾ÝÊÇ·ñ¿É¶Á

SQL> select * from exttxtm where rownum<2;

KEY_1 ST TEXT
TEXT_L TEXT_B
------------------------------ -- ----------------------------------------------
---- ------ ------
003BORACT010000000000008206000 0 NZD RESIDENTIAL INVESTMT LOAN
029 000
1

15 05, 2007

oracleÓû§±í¿Õ¼äÊý¾ÝÎļþË𻵻ò¶ªÊ§»Ö¸´ÊÂÀý

×÷Õß cyr1974 10:27 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

Ò»¸öÓ¡¶ÈͬÊÂÈøøËû×ö¸ö¼òµ¥µÄ»Ö¸´²âÊÔ£¬¾ßÌå²âÊÔ²½ÖèÈçÏ£º

10g v1 for windows xp£º

Êý¾Ý¿â¹¤×÷Ôڹ鵵·½Ê½£º

Êý¾ÝÎļþ¶ªÊ§ºóͨ¹ýÖؽ¨À´»Ö¸´;

Òª»Ö¸´µÄÊý¾ÝÎļþ±Ø¶¨ÔÚÊý¾Ý¿â¹¤×÷Ôڹ鵵ÈÕÖÁÖ®ºó´´½¨

1 05, 2007

oralce 9i&10gÇл»undo tablespace ²½Öè

×÷Õß cyr1974 17:10 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

select * from v$tablespace

create undo tablespace undotbs01 datafile '/oradata/rdev/undotbs01.dbf' size 2000m autoextend on

/* Formatted on 2007/05/01 17:04 (Formatter Plus v4.8.8) */
SELECT a.usn, a.status, b.tablespace_name, b.segment_name
FROM v$rollstat a, dba_rollback_segs b
WHERE a.usn = b.segment_id

alter system set undo_tablespace=undotbs01 scope=both

SELECT a.usn, a.status, b.tablespace_name, b.segment_name
FROM v$rollstat a, dba_rollback_segs b
WHERE a.usn = b.segment_id

alter tablespace undotbs2 offline

alter tablespace undotbs2 online

alter tablespace undotbs2 offline

drop tablespace undotbs2 including contents

delete the datafile from os

19 04, 2007

unix ϼà¿ØoracleÈÕÖ¾½Å±¾

×÷Õß cyr1974 09:55 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | unix¹ÜÀí shell ±à³Ì

19 04, 2007

ipcs /ipcrm ÃüÁî ˵Ã÷

×÷Õß cyr1974 09:52 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | unix¹ÜÀí shell ±à³Ì

10 04, 2007

Ò»¸ö¼Ç¼¿Í»§¶Ësession ipµÄ´¥·¢Æ÷

×÷Õß cyr1974 09:47 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (1) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

CREATE OR REPLACE TRIGGER record_ip_logon_trigger
AFTER LOGON ON DATABASE
DECLARE
v_user_identifier VARCHAR2 (64);
BEGIN
SELECT SYS_CONTEXT ('USERENV', 'OS_USER')
|| ':'
|| SYS_CONTEXT ('USERENV', 'IP_ADDRESS')
INTO v_user_identifier
FROM DUAL;

DBMS_SESSION.set_identifier (v_user_identifier);
END;
/

ÕâÑùÔÚv$sessionÀï¿ÉÒÔÖ±½Ó¿´µ½session ipµØÖ·,ÒÔ±ãÎÒÃÇÔÚ×÷½øÒ»²½´¦Àí

29 03, 2007

linuxÏ Oracle×Ô¶¯Æô¶¯ÓëÍ£Ö¹

×÷Õß cyr1974 17:07 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

29 03, 2007

oracle ´¥·¢Æ÷³£ÓõÄSystem-Defined Event Attributes

×÷Õß cyr1974 11:19 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

ora_client_ip_address

VARCHAR2

DECLARE
  v_addr VARCHAR2(11);
  IF (ora_sysevent = 'LOGON') THEN
    v_addr := ora_client_ip_address;
  END IF;
END;

ora_database_name

VARCHAR2(50)

DECLARE
  v_db_name VARCHAR2(50);
BEGIN
  v_db_name := ora_database_name;
END;

ora_des_encrypted_password

VARCHAR2

IF (ora_dict_obj_type = 'USER') THEN  
  INSERT INTO event_table
    VALUES (ora_des_encrypted_password);
END IF;

ora_dict_obj_name

VARCHAR(30)

INSERT INTO event_table 
  VALUES ('Changed object is ' || 
           ora_dict_obj_name);

ora_dict_obj_name_list
(name_list OUT ora_name_list_t)

BINARY_INTEGER

IF (ora_sysevent='ASSOCIATE STATISTICS')
  THEN number_modified :=
       ora_dict_obj_name_list(name_list);
END IF;

ora_dict_obj_owner

VARCHAR(30)

INSERT INTO event_table 
  VALUES ('object owner is' || 
           ora_dict_obj_owner);

ora_dict_obj_owner_list
(owner_list OUT ora_name_list_t)

BINARY_INTEGER

IF (ora_sysevent='ASSOCIATE STATISTICS') 
  THEN number_of_modified_objects :=    
     ora_dict_obj_owner_list(owner_list);
END IF;

ora_dict_obj_type

VARCHAR(20)

INSERT INTO event_table 
  VALUES ('This object is a ' || 
           ora_dict_obj_type);

ora_grantee
(user_list OUT ora_name_list_t)

BINARY_INTEGER

IF (ora_sysevent = 'GRANT') THEN
  number_of_users=ora_grantee(user_list);
END IF;

ora_instance_num

NUMBER

IF (ora_instance_num = 1) THEN
  INSERT INTO event_table VALUES ('1');
END IF;

ora_is_alter_column
(column_name IN VARCHAR2)

BOOLEAN

IF (ora_sysevent = 'ALTER' AND
    ora_dict_obj_type = 'TABLE') THEN 
 alter_column := ora_is_alter_column('C');
END IF;

ora_is_creating_nested_table

BOOLEAN

IF (ora_sysevent = 'CREATE' and
    ora_dict_obj_type = 'TABLE' and
    ora_is_creating_nested_table) THEN 
  INSERT INTO event_table
    VALUES ('A nested table is created');
END IF;

ora_is_drop_column
(column_name IN VARCHAR2)

BOOLEAN

IF (ora_sysevent = 'ALTER' AND
    ora_dict_obj_type = 'TABLE') THEN  
 drop_column := ora_is_drop_column('C');
END IF;

ora_is_servererror

BOOLEAN

IF (ora_is_servererror(error_number)) THEN
 INSERT INTO event_table
   VALUES ('Server error!!');
END IF;

ora_login_user

VARCHAR2(30)

SELECT ora_login_user 
FROM dual;

ora_partition_pos

BINARY_INTEGER

-- Retrieve ora_sql_txt into
-- sql_text variable first.
v_n := ora_partition_pos;
v_new_stmt := SUBSTR(sql_text,1,v_n - 1)
         || ' ' || my_partition_clause
         || ' ' || SUBSTR(sql_text, v_n));

ora_privilege_list
(privilege_list
 OUT ora_name_list_t)

BINARY_INTEGER

IF (ora_sysevent = 'GRANT' OR
    ora_sysevent = 'REVOKE') THEN
  number_of_privileges :=
    ora_privilege_list(priv_list);
END IF;

ora_revokee
(user_list OUT ora_name_list_t)

BINARY_INTEGER

IF (ora_sysevent = 'REVOKE') THEN
number_of_users := ora_revokee(user_list);

ora_server_error

NUMBER

INSERT INTO event_table 
  VALUES ('top stack error ' || 
           ora_server_error(1));

ora_server_error_depth

BINARY_INTEGER

n := ora_server_error_depth;
-- This value is used with other functions -- such as ora_server_error

ora_server_error_msg
(position in binary_integer)

VARCHAR2

INSERT INTO event_table
  VALUES ('top stack error message' ||
           ora_server_error_msg(1));

ora_server_error_num_params
(position in binary_integer)

BINARY_INTEGER

n := ora_server_error_num_params(1);

ora_server_error_param
(position in binary_integer,
 param in binary_integer)

VARCHAR2

-- For example, the second %s in a 
-- message: "Expected %s, found %s"
param := ora_server_error_param(1,2);

ora_sql_txt
(sql_text out ora_name_list_t)

BINARY_INTEGER

sql_text ora_name_list_t;
v_stmt VARCHAR2(2000);
...
n := ora_sql_txt(sql_text);
FOR i IN 1..n LOOP
  v_stmt := v_stmt || sql_text(i);
END LOOP;
INSERT INTO event_table 
  VALUES ('text of triggering statement: ' 
           || v_stmt);

ora_sysevent

VARCHAR2(20)

INSERT INTO event_table
  VALUES (ora_sysevent);

ora_with_grant_option

BOOLEAN

IF (ora_sysevent = 'GRANT' and
    ora_with_grant_option = TRUE) THEN
  INSERT INTO event_table 
    VALUES ('with grant option');
END IF;

space_error_info
(error_number OUT NUMBER,
 error_type OUT VARCHAR2,
 object_owner OUT VARCHAR2,
 table_space_name OUT 
  VARCHAR2,
 object_name OUT VARCHAR2,
 sub_object_name OUT VARCHAR2)

BOOLEAN

IF (space_error_info(eno,typ,owner,ts,obj, 
                     subobj) = TRUE) THEN
  DBMS_OUTPUT.PUT_LINE('The object '|| obj 
               || ' owned by ' || owner ||
               ' has run out of space.');
END IF;

29 03, 2007

Á½¸ö¼òµ¥µÄ´¥·¢Æ÷ ¿ØÖÆÓû§drop»òalter any database object

×÷Õß cyr1974 11:13 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

oracleÊý¾Ý¿âÔÚÓµÓÐcreate sessionȨÏÞÏÂĬÈ϶ÔËù´´½¨µÄ¶ÔÏóÓÐdrop and alterȨÏÞ£¬ÕâЩȨÏÞÎÒÃDz»ÄÜrevoke£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÒÔÏ´¥·¢Æ÷À´¿ØÖÆÆÕͨÓû§ÕâЩȨÏÞ£¬À´Âú×㲿·Ö°²È«ÉϵÄÐèÒª

CREATE OR REPLACE TRIGGER trg_dropdeny
before drop on database
begin
if (ora_login_user!='SYS' and ora_login_user!='SYSTEM')
then
raise_application_error(
num=>-20000,
msg=>'You can not drop ' || ora_dict_obj_name() || ' ! please ask dba to finish version control.thank you1');
end if;
end;

CREATE OR REPLACE TRIGGER trg_alterdeny
before alter on database
begin
if (ora_login_user!='SYS' and ora_login_user!='SYSTEM')
then
raise_application_error(
num=>-20000,
msg=>'You can not drop ' || ora_dict_obj_name() || ' ! please ask dba to finish version control.thank you1');
end if;
end;

21 03, 2007

oracle rdaʹÓÃÑÝʾ

×÷Õß cyr1974 14:58 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

13 03, 2007

¹ØÓÚREDHAT CLUSTER FOR ORACLEµÄÎÊÌâ

×÷Õß cyr1974 09:09 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

12 03, 2007

ÓÐʱºò×÷oracleË«»úÈȱ¸£¬Ò»¸öʵÀý±¨²»ÄÜmount database in EXCLUSIVE MODE

×÷Õß cyr1974 11:28 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

ÓÐʱºò×÷Ë«»úÈȱ¸£¬Ò»¸öʵÀý±¨ÒÔÏ´íÎó

cannot mount database in EXCLUSIVE MODE

¿ÉÓÖ³öÏÖÁËÐÂÎÊÌ⣬µ±ÎÒÆô¶¯Êý¾Ý¿âʱ£¬³öÏÖcannot mount database in EXCLUSIVE MODE ÇëÎÊÕâÒªÔõô½â¾öѽ£¡

Solution:

ÄãÔÚʲô²Ù×÷ϵͳÏ£¿£¿Èç¹ûÊÇunix£¬É¾³ýµô$ORACLE_HOME/dbs/1kSIDÎļþ¾Í¿ÉÒÔÁË¡£

»òÕß°ÑÄܹ»Æô¶¯µÄÄǸöʵÀýµÄ¸ÃÎļþ¸´ÖƵ½²»ÄÜÆô¶¯ÊµÀýµÄÏàӦλÖü´¿É

12 03, 2007

redhat cluster http·þÎñÈȱ¸½Å±¾

×÷Õß cyr1974 09:57 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (2) | ÒýÓà (0) | unix¹ÜÀí shell ±à³Ì

#!/bin/bash
#
# Startup script for the Apache Web Server
#
# chkconfig: - 85 15
# description: Apache is a World Wide Web server. It is used to serve
# HTML files and CGI.
# processname: httpd
# pidfile: /var/run/httpd.pid
# config: /etc/httpd/conf/httpd.conf

# Source function library.
. /etc/rc.d/init.d/functions

if [ -f /etc/sysconfig/httpd ]; then
. /etc/sysconfig/httpd
fi

# This will prevent initlog from swallowing up a pass-phrase prompt if
# mod_ssl needs a pass-phrase from the user.
INITLOG_ARGS=""

# Set HTTPD=/usr/sbin/httpd.worker in /etc/sysconfig/httpd to use a server
# with the thread-based "worker" MPM; BE WARNED that some modules may not
# work correctly with a thread-based MPM; notably PHP will refuse to start.

# Path to the apachectl script, server binary, and short-form for messages.
apachectl=/usr/sbin/apachectl
httpd=${HTTPD-/usr/sbin/httpd}
prog=httpd
RETVAL=0

# check for 1.3 configuration
check13 () {
CONFFILE=/etc/httpd/conf/httpd.conf
GONE="(ServerType|BindAddress|Port|AddModule|ClearModuleList|"
GONE="${GONE}AgentLog|RefererLog|RefererIgnore|FancyIndexing|"
GONE="${GONE}AccessConfig|ResourceConfig)"
if grep -Eiq "^[[:space:]]*($GONE)" $CONFFILE; then
echo
echo 1>&2 " Apache 1.3 configuration directives found"
echo 1>&2 " please read /usr/share/doc/httpd-2.0.46/migration.html"
failure "Apache 1.3 config directives test"
echo
exit 1
fi
}

# The semantics of these two functions differ from the way apachectl does
# things -- attempting to start while running is a failure, and shutdown
# when not running is also a failure. So we just do it the way init scripts
# are expected to behave here.
start() {
echo -n $"Starting $prog: "
check13 || exit 1
daemon $httpd $OPTIONS
RETVAL=$?
echo
[ $RETVAL = 0 ] && touch /var/lock/subsys/httpd
return $RETVAL
}
stop() {
echo -n $"Stopping $prog: "
killproc $httpd
RETVAL=$?
echo
[ $RETVAL = 0 ] && rm -f /var/lock/subsys/httpd /var/run/httpd.pid
}
reload() {
echo -n $"Reloading $prog: "
check13 || exit 1
killproc $httpd -HUP
RETVAL=$?
echo
}

# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status $httpd
RETVAL=$?
;;
restart)
stop
start
;;
condrestart)
if [ -f /var/run/httpd.pid ] ; then
stop
start
fi
;;
reload)
reload
;;
graceful|help|configtest|fullstatus)
$apachectl $@
RETVAL=$?
;;
*)
echo $"Usage: $prog {start|stop|restart|condrestart|reload|status|fullstatus|graceful|help|configtest}"
exit 1
esac

exit $RETVAL

8 03, 2007

windows sqlplus °ïÖú°²×°¹ý³Ì

×÷Õß cyr1974 14:48 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:>set system_pass system/oracle
Environment variable system_pass not defined

C:>helpins
ORACLE_HOME environment variable is not set

C:>set oracle_home=E:oracleproduct10.2.0db_1

C:>helpins
Set SYSTEM_PASS in the environment, then restart help installation.
SYSTEM_PASS should be set to system/pw where pw is the password
of the SYSTEM schema.

C:>set system_pass system/oracle
Environment variable system_pass not defined

C:>set system_pass=system/oracle

C:>helpins
Loading HELP data from helpus.sql

C:>sqlplus system/oracle

SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 3ÔÂ 8 14:14:26 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring En
e options

SQL> help

HELP
----

Accesses this command line help system. Enter HELP INDEX or ? INDEX
for a list of topics. In iSQL*Plus, click the Help button to display
iSQL*Plus online help.
You can view SQL*Plus resources at http://otn.oracle.com/tech/sql_plus/
and the Oracle Database Library at http://otn.oracle.com/documentation/

HELP|? [topic]

SQL> set _editor=D:boc databaseuedit32UltraEdit-32_lh_bUedit32.exe
SP2-0735: δ֪µÄ SET Ñ¡Ïͷ "_editor=D:..."
SQL> help set

SET
---

Sets a system variable to alter the SQL*Plus environment settings
for your current session. For example, to:
- set the display width for data
- customize HTML formatting
- enable or disable printing of column headings
- set the number of lines per page
In iSQL*Plus, you can also use the Preferences screen to set
system variables.

SET system_variable value

where system_variable and value represent one of the following clauses:

APPI[NFO]{OFF|ON|text} NUM[WIDTH] {10|n}
ARRAY[SIZE] {15|n} PAGES[IZE] {14|n}
AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n} PAU[SE] {OFF|ON|text}
AUTOP[RINT] {OFF|ON} RECSEP {WR[APPED]|EA[CH]|OFF}
AUTORECOVERY {OFF|ON} RECSEPCHAR {_|c}
AUTOT[RACE] {OFF|ON|TRACE[ONLY]} SERVEROUT[PUT] {ON|OFF}
[EXP[LAIN]] [STAT[ISTICS]] [SIZE {n | UNLIMITED}] [FOR[MAT
BLO[CKTERMINATOR] {.|c|ON|OFF} {WRA[PPED] |
CMDS[EP] {;|c|OFF|ON} WOR[D_WRAPPED] |
COLSEP {_|text} TRU[NCATED]}]
CON[CAT] {.|c|ON|OFF} *SHIFT[INOUT] {VIS[IBLE] |
COPYC[OMMIT] {0|n} INV[ISIBLE]}
COPYTYPECHECK {ON|OFF} *SHOW[MODE] {OFF|ON}
DEF[INE] {&|c|ON|OFF} *SQLBL[ANKLINES] {OFF|ON}
DESCRIBE [DEPTH {1|n|ALL}] SQLC[ASE] {MIX[ED] |
[LINENUM {OFF|ON}] [INDENT {OFF|ON}] LO[WER] | UP[PER]}
ECHO {OFF|ON} *SQLCO[NTINUE] {> | text}
*EDITF[ILE] file_name[.ext] *SQLN[UMBER] {ON|OFF}
EMB[EDDED] {OFF|ON} SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
ESC[APE] {|c|OFF|ON} *SQLPRE[FIX] {#|c}
FEED[BACK] {6|n|ON|OFF} *SQLP[ROMPT] {SQL>|text}
FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL} SQLT[ERMINATOR] {;|c|ON|OFF}
*FLU[SH] {ON|OFF} *SUF[FIX] {SQL|text}
HEA[DING] {ON|OFF} *TAB {ON|OFF}
HEADS[EP] {||c|ON|OFF} *TERM[OUT] {ON|OFF}
INSTANCE [instance_path|LOCAL] *TI[ME] {OFF|ON}
LIN[ESIZE] {80|n} ({150|n} iSQL*Plus) TIMI[NG] {OFF|ON}
LOBOF[FSET] {1|n} *TRIM[OUT] {ON|OFF}
LOGSOURCE [pathname] *TRIMS[POOL] {OFF|ON}
LONG {80|n} UND[ERLINE] {-|c|ON|OFF}
LONGC[HUNKSIZE] {80|n} VER[IFY] {ON|OFF}
MARK[UP] HTML [OFF|ON] WRA[P] {ON|OFF}
[HEAD text] [BODY text] [TABLE text] XQUERY {BASEURI text|
[ENTMAP {ON|OFF}] ORDERING{UNORDERED|
[SPOOL {OFF|ON}] ORDERED|DEFAULT}|
[PRE[FORMAT] {OFF|ON}] NODE{BYVALUE|BYREFERENCE|
NEWP[AGE] {1|n|NONE} DEFAULT}|
NULL text CONTEXT text}
NUMF[ORMAT] format

An asterisk (*) indicates the SET option is not supported in iSQL*Plus.

SQL> set editf=notepad
SQL> ed
SP2-0107: ÎÞÐë±£´æ¡£
SQL> edit
SP2-0107: ÎÞÐë±£´æ¡£
SQL> select x from dual;
select x from dual
*
µÚ 1 ÐгöÏÖ´íÎó:
ORA-06553: PLS-306: µ÷Óà 'OGC_X' ʱ²ÎÊý¸öÊý»òÀàÐÍ´íÎó

SQL> edit
ÒÑдÈë file =notepad.sql

1* select sysdate from dual
SQL> /

SYSDATE
--------------
08-3ÔÂ -07

SQL>

5 03, 2007

redhat 4.0 es cluster Ë«»úÈȱ¸oracle½Å±¾

×÷Õß cyr1974 09:59 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | oracleÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢

Ò»¡¢oracleÎļþ ÓÉredhat clusterÈí¼þµ÷ÓÃ

#!/bin/bash
#
# Cluster service script to start/stop oracle
#

cd /home/oracle

. /etc/rc.d/init.d/functions

case $1 in
start)
su - oracle -c "./dbstart"
;;
stop)
su - oracle -c "./dbshut"
;;
restart)
su - oracle -c "./dbshut"
su - oracle -c "./dbstart"
;;

status)
status oracle(»òÕß ÓÃ×Ô¼ºÐ´µÄ״̬¼ì²â½Å±¾Ò²ÐУ©
;;
esac

dbstart£º

#!/bin/bash
#su - oracle<< EOF
#. ~/.profile
sqlplus /nolog<<EOF
conn / as sysdba
startup
!lsnrctl start
exit
EOF
exit 0

dbshut:

#!/bin/bash
#su - oracle <<EOF
sqlplus /nolog<<EOF
connect / as sysdba
!lsnrctl stop
shutdown immediate
quit

EOF
exit 0

1 02, 2007

¾­µäÔÞÃÀ30¾ä(תÔØ£©

×÷Õß cyr1974 14:00 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | ºÃÎĹ²Ïí

1. you look great today.£¨Äã½ñÌì¿´ÉÏÈ¥ºÜ°ô¡££©¡¾Ã¿Ì춼¿ÉÒÔÓã¡¡¿
2. you did a good job. £¨Äã¸ÉµÃ·Ç³£ºÃ¡££©¡¾¹ú¼Ê×îͨÓõıíÑ¡¿
3. we're so proud of you.£¨ÎÒÃÇÊ®·ÖΪÄã½¾°Á¡££©¡¾×î¸ß¼¶µÄ±íÑ¡¿
4. i'm very pleased with your work.£¨ÎÒ¶ÔÄãµÄ¹¤×÷·Ç³£ÂúÒâ¡££©¡¾Õýʽ¡¢Õæ³ÏµÄÔÞÑ¡¿
5. this is really a nice place.£¨ÕâÕæÊǸöºÃµØ·½£¡£©¡¾Ëæ¿Ú¾Í˵¡¢µ«Ð§¹ûºÜºÃµÄ±íÑ¡¿
6. you're looking sharp!£¨Äã¿´ÉÏÈ¥Õ澫Éñ/Õæ°ô/ÕæƯÁÁ¡££©¡¾ÓëÖÚ²»Í¬µÄ±íÑ¡¿
7. you always know the right thing to say. =

1 02, 2007

һƪÄÐÈ˱ؿ´µÄÐÛÎÄ£¨×ªÔØ£©

×÷Õß cyr1974 13:58 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (1) | ÒýÓà (0) | ºÃÎĹ²Ïí

1 02, 2007

11¸öЦ»°ÈÃÄãÁìÎòÈËÉúµÄÕæÚÐ

×÷Õß cyr1974 13:54 | ¾²Ì¬Á´½ÓÍøÖ· | ×îлظ´ (0) | ÒýÓà (0) | ÈËÉú¸ÐÎò

ת×Ôchinaunix

1¡¢¸¸×Ó¶þÈË¿´µ½Ò»Á¾Ê®·ÖºÀ»ªµÄ½ø¿Ú½Î³µ¡£¶ù×Ó²»Ð¼µØ¶ÔËûµÄ¸¸Ç×˵£º¡°×øÕâÖÖ³µµÄÈË£¬¶Ç×ÓÀïÒ»¶¨Ã»ÓÐѧÎÊ£¡¡±¸¸Ç×ÔòÇáÃ赭дµØ»Ø´ð£º¡°ËµÕâÖÖ»°µÄÈË£¬¿Ú´üÀïÒ»¶¨Ã»ÓÐÇ®£¡¡± ¡¡
¡ª¡ªÄã¶ÔÊÂÇéµÄ¿´·¨£¬ÊDz»ÊÇÒ²·´Ó³³öÄãÄÚÐÄÕæÕýµÄ̬¶È£¿ ¡¡
2¡¢Íí·¹ºó£¬Ä¸Ç׺ÍÅ®¶ùÒ»¿é¶ùÏ´ÍëÅÌ£¬¸¸Ç׺Ͷù×ÓÔÚ¿ÍÌü¿´µçÊÓ¡£Í»È»£¬³ø·¿Àï´«À´´òÆÆÅÌ×ÓµÄÏìÉù£¬È»ºóһƬ³Á¼Å¡£¶ù×ÓÍû×ÅËû¸¸Ç×£¬ËµµÀ£º¡°Ò»¶¨ÊÇÂèÂè´òÆƵġ£¡±¡°ÄãÔõô֪µÀ£¿¡±¡°ËýûÓÐÂîÈË¡£¡± ¡¡
¡ª¡ªÎÒÃÇÏ°¹ßÒÔ²»Í¬µÄ±ê×¼À´¿´ÈË¿´¼º£¬ÒÔÖÂÍùÍùÊÇÔðÈËÒÔÑÏ£¬´ý¼ºÒÔ¿í¡£ ¡¡
3¡¢ÓÐÁ½¸ǫ̈Íå¹Û¹âÍŵ½**ÒÁ¶¹°ëµºÂÃÓΣ¬Â·¿öºÜ»µ£¬µ½´¦¶¼ÊÇ¿Ó¶´¡£Ò»Î»µ¼ÓÎÁ¬Éù˵·Ãæ¼òÖ±ÏñÂé×ÓÒ»Ñù¡£¶øÁíÒ»¸öµ¼ÓÎÈ´Ê«ÒⰻȻµØ¶ÔÓοÍ˵£º¡°ÎÒÃÇÏÖÔÚ×ßµÄÕýÊǺպÕÓÐÃûµÄÒÁ¶¹ÃÔÈ˾ÆÎÑ´óµÀ¡£¡± ¡¡
¡ª¡ªËäÊÇͬÑùµÄÇé¿ö£¬È»¶ø²»Í¬µÄÒâÄ¾Í»á²úÉú²»Í¬µÄ̬¶È¡£Ë¼ÏëÊǺεÈÆæÃîµÄÊ£¬ÈçºÎÈ¥Ï룬¾ö¶¨È¨ÔÚÄã¡£ ¡¡
4¡¢Í¬ÑùÊÇСѧÈýÄ꼶µÄѧÉú£¬ËûÃǽ«À´µÄ־ԸͬÊǵ±Ð¡³ó¡£ÖйúÀÏʦ³â֮Ϊ£º¡°ÐØÎÞ´óÖ¾£¬Èæ×Ó²»¿É½ÌÒ²£¡¡±Íâ¹úÀÏʦÔò»á˵£º¡°Ô¸Äã°Ñ»¶Ð¦´ø¸øÈ«ÊÀ½ç£¡¡± ¡¡
¡ª¡ªÉíΪ³¤±²µÄÎÒÃÇ£¬²»µ«ÒªÇó¶àÓÚ¹ÄÀø£¬¸üÒÔÏÁÕ­½ç¶¨Á˳ɹ¦µÄ¶¨Òå¡£ ÁùÔÂÁªÃË¡¡
5¡¢ÆÞ×ÓÕýÔÚ³ø·¿³´²Ë¡£ÕÉ·òÔÚËýÅÔ±ßÒ»Ö±ßë߶²»Í££º¡°ÂýЩ¡¢Ð¡ÐÄ£¡»ðÌ«´óÁË¡£¸Ï¿ì°ÑÓã·­¹ýÀ´¡¢ÓÍ·ÅÌ«¶àÁË£¡¡±ÆÞ×ÓÍÑ¿Ú¶ø³ö£º¡°ÎÒ¶®µÃÔõÑù³´²Ë¡£¡±ÕÉ·òƽ¾²µØ´ðµÀ£º¡°ÎÒÖ»ÊÇÒªÈÃÄãÖªµÀ£¬ÎÒÔÚ¿ª³µÊ±£¬ÄãÔÚÅÔ±ßà©à©²»ÐÝ£¬ÎҵĸоõÈçºÎ¡­¡­¡± ¡¡
¡ª¡ªÑ§»áÌåÁÂËûÈ˲¢²»À§ÄÑ£¬Ö»ÒªÄãÔ¸ÒâÈÏÕæµØÕ¾ÔÚ¶Ô·½µÄ½Ç¶ÈºÍÁ¢³¡¿´ÎÊÌâ¡£ ¡¡
6¡¢Ò»Á¾ÔØÂú³Ë¿ÍµÄ¹«¹²Æû³µÑØ×ÅÏÂÆ·¿ìËÙÇ°½ø×Å£¬ÓÐÒ»¸öÈËÔÚºóÃæ½ô½ô×·¸Ï×ÅÕâÁ¾³µ×Ó¡£Ò»¸ö³Ë¿Í´Ó³µ´°ÖÐÉì³öÍ·À´¶Ô×·³µ×ÓµÄÈË˵£º¡°ÀÏÐÖ£¡ËãÀ²£¬Äã×·²»Éϵģ¡¡±¡°ÎÒ±ØÐë×·ÉÏËü£¬¡±ÕâÈËÆø´­ÓõÓõµØ˵£º¡°ÎÒÊÇÕâÁ¾³µµÄ˾»ú£¡¡± ¡¡
¡ª¡ªÓÐЩÈ˱ØÐë·Ç³£ÈÏÕæŬÁ¦£¬ÒòΪ²»ÕâÑùµÄ»°£¬ºó¹û¾ÍÊ®·Ö±¯²ÒÁË£¡È»¶øÒ²ÕýÒòΪ±ØÐëÈ«Á¦ÒÔ¸°£¬Ç±Ôڵı¾ÄܺͲ»ÎªÈËÖªµÄÌØÖÊÖÕ½«³ä·ÖÕ¹ÏÖ³öÀ´¡£ ¡¡
7¡¢¼×£º¡°Ð°áÀ´µÄÁھӺÿɶñ£¬×òÌìÍíÉÏÈý¸ü°ëÒ¹ÅÜÀ´ÃÍ°´ÎÒ¼ÒµÄÃÅÁå¡£¡±ÒÒ£º¡°µÄÈ·¿É¶ñ£¡ÄãÓÐûÓÐÂíÉϱ¨¾¯£¿¡±¼×£º¡°Ã»ÓС£ÎÒµ±ËûÃÇÊÇ·è×Ó£¬¼ÌÐø´µÎÒµÄСÀ®°È¡£¡± ¡¡
¡ª¡ªÊ³ö±ØÓÐÒò£¬Èç¹ûÄÜÏÈ¿´µ½×Ô¼ºµÄ²»ÊÇ£¬´ð°¸¾Í»á²»Ò»Ñù¡£ ¡¡
8¡¢ÕÅÈýÔÚɽ¼äС·¿ª³µ£¬Õýµ±ËûÓÆÔÕµØÐÀÉÍÃÀÀö·ç¾°Ê±£¬Í»È»Ó­Ã濪À´µÄ»õ³µË¾»úÒ¡Ï´°»§´óº°Ò»Éù£º¡°Öí£¡¡±ÕÅÈýÔ½ÏëÔ½Æø£¬Ò²Ò¡Ï³µ´°´óÂ¡°Äã²ÅÊÇÖí£¡¡±¸ÕÂîÍ꣬Ëû±ãӭͷײÉÏһȺ¹ýÂí·µÄÖí¡£ ¡¡
¡ª¡ª²»Òª´íÎóµØÚ¹ÊͱðÈ˵ĺÃÒ⣬ÄÇÖ»»áÈÃ×Ô¼º³Ô¿÷£¬²¢ÇÒʹ±ðÈËÊÜÈè¡£ ¡¡Ð¡Äк¢ÎÊ°Ö°Ö£º¡°ÊDz»ÊÇ×ö¸¸Ç×µÄ×ܱÈ×ö¶ù×ÓµÄÖªµÀµÃ¶à£¿¡±°Ö°Ö»Ø´ð£º¡°µ±È»À²£¡¡±¡°µçµÆÊÇË­·¢Ã÷µÄ£¿¡±¡°°®µÏÉú¡£¡±¡°ÄÇ°®µÏÉúµÄ°Ö°ÖÔõôûÓз¢Ã÷µçµÆ£¿¡± ¡¡
¡ª¡ªÈ¨ÍþÍùÍùÖ»ÊÇÒ»¸ö¾­²»Æð¿¼ÑéµÄ¿Õ¿Ç×Ó£¬ÓÈÆäÔÚÏÖ½ñÕâ¸ö¶àÔª¿ª·ÅµÄʱ´ú¡£ ¡¡
10¡¢Ð¡Ã÷Ï´Ôèʱ²»Ð¡ÐÄÍÌÏÂһС¿é·ÊÔí£¬ËûµÄÂèÂè»Å»ÅÕÅÕŵشòµç»°¸ø¼ÒÍ¥Ò½ÉúÇóÖú¡£Ò½Éú˵£º¡°ÎÒÏÖÔÚ»¹Óм¸¸ö²¡ÈËÔÚ£¬¿ÉÄÜÒª°ëСʱºó²ÅÄܸϹýÈ¥¡£¡±Ð¡Ã÷ÂèÂè˵£º¡°ÔÚÄãÀ´Ö®Ç°£¬ÎÒ¸Ã×öʲô£¿¡±Ò½Éú˵£º¡°¸øСÃ÷ºÈÒ»±­°×¿ªË®£¬È»ºóÓÃÁ¦ÌøÒ»Ìø£¬Äã¾Í¿ÉÒÔÈÃСÃ÷ÓÃ×ì°Í´µÅÝÅÝÏûĥʱ¼äÁË¡£¡± ¡¡
¡ª¡ªÊÂÇé¼ÈÈ»ÒѾ­·¢ÉúÁË£¬ºÎ²»Ì¹È»×ÔÔÚµØÃæ¶Ô¡£µ£ÐIJ»Èç¿íÐÄ£¬Çî½ôÕŲ»ÈçÇÐÄ¡£ ¡¡
11¡¢Ò»°Ñ¼áʵµÄ´óËø¹ÒÔÚ´óÃÅÉÏ£¬Ò»¸ùÌú¸Ë·ÑÁ˾ÅÅ£¶þ»¢Ö®Á¦£¬»¹ÊÇÎÞ·¨½«ËüÇË¿ª¡£Ô¿³×À´ÁË£¬ËûÊÝСµÄÉí×Ó×ê½øËø¿×£¬Ö»ÇáÇáһת£¬´óËø¾Í¡°Å¾¡±µØÒ»Éù´ò¿ªÁË¡£ ¡¡
¡ª¡ªÃ¿¸öÈ˵ÄÐÄ£¬¶¼ÏñÉÏÁËËøµÄ´óÃÅ£¬ÈÎÄãÔÙ´ÖµÄÌú°ôÒ²Ç˲»¿ª¡£Î©Óйػ³£¬²ÅÄÜ°Ñ×Ô¼º±ä³ÉÒ»°ÑϸÄåµÄÔ¿³×£¬½øÈë±ðÈ˵ÄÐÄÖС£