oracle¼àÌý¼ÓÃÜ ¸ü°²È«
ºÜ¶àÈ˶¼ÖªµÀ£¬OracleµÄ¼àÌýÆ÷Ò»Ö±´æÔÚ×ÅÒ»¸ö°²È«Òþ»¼£¬¼ÙÈç²»ÉèÖð²È«´ëÊ©£¬ÄÇôÄܹ»·ÃÎʵÄÓû§¾Í¿ÉÒÔÔ¶³Ì¹Ø±Õ¼àÌýÆ÷¡£
Ïà¹ØʾÀý£º
D:\>lsnrctl stop eygle
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 28-11ÔÂ-2007 10:02:40
Copyright (c) 1991, 2006, Oracle. All rights reserved.
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.33.11)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=eygle)))
ÃüÁîÖ´Ðгɹ¦
´ó¼Ò¿ÉÒÔ·¢ÏÖ£¬´ËʱȱʡµÄ¼àÌýÆ÷µÄÈÕÖ¾»¹ÎÞ·¨¼Ç¼²Ù×÷µØÖ·£º
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.33.11)(PORT=1521)))
28-NOV-2007 09:59:20 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)
(ARGUMENTS=64)(SERVICE=eygle)(VERSION=169870080)) * stop * 0
ΪÁ˸üºÃµÄ±£Ö¤¼àÌýÆ÷µÄ°²È«£¬´ó¼Ò×îºÃΪ¼àÌýÉèÖÃÃÜÂ룺
[oracle@jumper log]$ lsnrctl
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 28-NOV-2007 10:18:17
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> change_password
Old password:
New password:
Reenter new password:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.33.11)(PORT=1521)))
Password changed for listener
The command completed successfully
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.33.11)(PORT=1521)))
Saved LISTENER configuration parameters.
Listener Parameter File /opt/oracle/product/9.2.0/network/admin/listener.ora
Old Parameter File /opt/oracle/product/9.2.0/network/admin/listener.bak
The command completed successfully
ÔÚÎÒÃÇÉèÖÃÃÜÂëºó£¬Ô¶³Ì²Ù×÷½«»áÒòȱʧÃÜÂë¶ø³öÏÖʧ°Ü£º
D:\>lsnrctl stop eygle
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 28-11ÔÂ-2007 10:22:57
Copyright (c) 1991, 2006, Oracle. All rights reserved.
ÕýÔÚÁ¬½
Ïà¹ØÎĵµ£º
ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......
Ò»¡¢java·ÃÎÊÖÐÎÄOracleÊý¾Ý¿âÉÏÁ¬½ÓµÄUS7ASCIIÊý¾Ý¿â
1¡¢¶Á·½·¨
public String convertLink_DB(String s) {
if(s != null){
try{
byte[] b = s.getBytes();
for(int i=0; i<b.length; i++){
b[i] ......
http://hi.baidu.com/firefly5002/blog/item/5b5719fcb5bd3e1d08244d11.html
Oracle 10G DataGuard
server A: 10.85.10.44 SID=mesdb
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows 2003
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£
ALTER DATABASE ......
select * from (
select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME
from COM_WHOLE_INFO cw2,SYS_OPERATOR so, SYS_PUBLICARGUMENT sp1, SYS_PUBLICARGUMEN ......
±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
(1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
(2)½âѹËõzip£¬Ï±߰üº¬Ò»¸ö ......