Ãâ°²×°Oracle¿Í»§¶ËÈí¼þ ʹÓÃpl/sqlÅäÖõǽ
ËäÈ»ÕâÊÇÎÒÕÒµ½×îÏêϸµÄÅäÖÃÃèÊö£¬µ«Êdz¢ÊÔ»¹ÊÇûÓгɹ¦¡£
1.ÏÂÔØOracle Client Package
.
´Ó
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
ÏÂÔØ
Instant
Client Package – Basic
°ü
(
±ê×¢
:All files
required to run OCI, OCCI, and JDBC-OCI applications)
ÕâÀïÏÂÔصÄÊÇ
Version 11.1.0.7
2.±¾µØ±£´æOracle Client
Package:
´´
½¨Îļþ¼Ð
,
±ÈÈç
oracle_client,
½«
ÏÂÔصÄÎļþ¼ÓѹËõµ½´ËÎļþ¼ÐÀï
.(
±ÊÕßĿ¼
:
D:\oracle_client\instantclient_10_2)
3.
ÔÚµ±Ç°Ä¿Â¼ÏÂ
,н¨Á¢Á½¸öÎļþ£¬sqlnet.oraºÍtnsnames.oraÈ»ºóÔÙ
ÊÖ¶¯ÅäÖÃ
sqlnet.ora
ºÍ
tnsnames.ora
±ÈÈçÕâÀïÊÇ
:
sqlnet.ora
ÎļþÄÚÈÝ
:
SQLNET.AUTHENTICATION_SERVICES=
(NTS)
NAMES.DIRECTORY_PATH=
(TNSNAMES, EZCONNECT)
tnsnames.ora
ÎļþÄÚÈÝ
(
бÌå±íʾÐèÒªÌæ»»µÄÄÚÈÝ
):
orcl
=
(DESCRIPTION =
(ADDRESS_LIST
=
(ADDRESS
= (PROTOCOL = TCP)(HOST = 192.168.1.103
)(PORT =
1521))
)
(CONNECT_DATA
=
(SERVICE_NAME
= orcl
)
)
)
4.
ÅäÖû·¾³±äÁ¿
±äÁ¿Ãû
:
TNS_ADMIN
±äÁ¿Öµ
:
D:\oracle_client\instantclient_10_2
·ñÔò³öÏÖ
:ORA-12154: TNS:could not resolve
the connect identifier specified´íÎó
Èç¹û֮ǰ
°²×°ÁË
Oracle
ÓÖжÔØ
,
»áÒÅÁô
NLS_LANG=NA
µÄ¼üÖµ
.
ÊäÈë
RegEdit
´ò¿ª×¢²á±í
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE.
ÔÚÓÒÃæÕÒµ½
NLS_LANG=NA
²¢É¾³ýµô
·ñÔò»á±¨
ORA-12705:
Cannot access NLS data files or invalid
´íÎó
.
5.
°²×°
pl/sqlÈí¼þ(¹ý³ÌÂÔ)
6.ÅäÖÃpl/sqlµÄOracleÁ¬½Ó²ÎÊý:
Ñ¡Ôñ
pl/sql
µÄ¹¤¾ß
/
Ê×Ñ¡Ïî
(too/
preference/
)
ÀïµÄÁ¬½Ó
,
ÔÚÓÒÃæÉèÖÃ
Oracle
Ö÷Ŀ¼Ãû
(
¼´°²×°Ä¿Â¼
)
ºÍ
OCI
¿â
.
Oracle
Ö÷Ŀ¼
Ãû
:
D:\oracle_client\instantclient_10_2
OCI
¿â
:
D:\oracle_client\instantclient_10_2\oci.dll
7.
怫
pl/sql
²âÊԳɹ¦
Ïà¹ØÎĵµ£º
½¨Á¢sshÐÅÈΣ¬racµÄ°²×°ÒªÓÃsshºÍscpÀ´¿½±´°²×°Îļþ¡£
ÔÚËùÓеĽڵãÉÏÔËÐУº
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
ÔÚrdb1½ÚµãÉÏÖ´ÐУº
ssh rdb1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rdb1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rdb2 ......
1. ½«Êý¾Ý¿âÍêÈ«µ¼³ö
Óû§Ãûsystem ÃÜÂësystem µ¼³öµ½OracleÓû§Ä¿Â¼ÏµÄtestdb20100522.dmpÎļþÖÐ
#exp system/system@testdb file=testdb20100522.dmp full=y
2. ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
#exp system/system@testdb file= testdb20100522.d ......
Exam Number/Code : 1Z0-053
Exam Name : Oracle Database 11g: Administration II
Questions and Answers : 167 Q&As
Update Time: 2010-05-15
1. You are not sure if Flashback Database is enabled. What database column and view can you query to
see if the flashback logs are being created in the ......
µ±±¾»ú°²×°ÁËORACLEÊý¾Ý¿âºó£¬ÔÙ°²×°ÔËÐÐOC4JµÄ»°£¬»·¾³±äÁ¿“ORACLE_HOME”ÓëORACLEÊý¾Ý¿âÓгåÍ»£¬¿ÉÒÔ°´ÕÕÈçÏ·½·¨½â¾ö´ËÎÊÌ⣺
·½·¨Ò»
µÚÒ»²½£ºÔÚ»·¾³±äÁ¿ÖÐн¨“OC4J_HOME”£¬Ö¸¶¨µ½ÄãµÄOC4J°²×°¸ùĿ¼£»
µÚ¶þ²½£º´ò¿ªOC4J°²×°µÄĿ¼£¬¼´../OC4J/bin/£¬ÀïÃæÓÐÒ»¸öoc4j.cmd£¬ÓÒ¼üµ¥»÷¸ÃÎļþ£¬Ñ ......
Áª½ÓÌõ¼þ¿ÉÔÚ from »ò WHERE ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ from ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE ºÍ HAVING ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ
1. ......