Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÀ䱸·Ý »Ö¸´

·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
  Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔ­À´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔ­À´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ¶à¸öÊý¾Ý¿â£¬¹À¼ÆÖ»ÐèÒª¸´ÖÆÏÂÃæµÄXJJĿ¼¾ÍÐÐÁË£©¡£
4.¸´ÖÆora92ÏÂÃæµÄdatabaseĿ¼£¨ÃÜÂëÎļþ£©¡£
5.Æô¶¯Êý¾Ý¿â¡£
ÉÏÊö±¸·ÝÁËÊý¾Ý¿âËùÓÐÐÅÏ¢°üÀ¨Êý¾Ý Óû§ ÃÜÂë¡£¡£¡£
Èç¹ûÕë¶Ôij¸öÊý¾Ý¿â Ö±½Ó±¸·ÝoradataϸÃÊý¾Ý¿âÎļþ¼´¿É¡£
·½·¨¶þ£º£¨²»Ð轨¿â£¬ÉÔÂé·³µã£©
À䱸·ÝÊý¾Ý±ØÐëÊÇÊý¾Ý¿â²»ÔÚopen״̬ÏÂ,¶ÔÊý¾Ý¿â½øÓÃÊý¾Ý±¸·Ý¡£ ¾ßÌå²Ù×÷£º
(1)£º ¹Ø±ÕDB £º shutdown immediate£»
(2)£ºcopy oradataĿ¼ÏµÄËùÓÐÎļþ£¬ °üÀ¨Êý¾ÝÎļþ£¬ ¿ØÖÆÎļþ£¬redo£¬µÈ£¬»¹ÐèÒªcopy ÃÜÂëÎļþ ÔÚĿ¼ora92Ï µÄdatabase ÖеÄpwd Îļþ.È«²¿copyµ½Ò»¸ö°²È«Ä¿Â¼ÖС£ÔÚsql Ï¿ÉÒÔÖ±½Ó¼ÓÒ»¸ö host È»ºóʹÓÃdosÃüÁî¡£Èçhost copy .............
(3)£ºÈç¹ûÊDzÙ×÷ϵͳµÄÖØÐ°²×°£¬Ö»ÒªÊÇͬÑùϵͳ£¬Í¬ÑùÊý¾Ý¿â°æ±¾£¬ÊÇ¿ÉÒÔ×öÀ䱸»Ö¸´¡£Ò»ÏÂ̸µÄÊÇϵͳµÄÖØÐ°²×°ºóµÄ²½Öè¡£
(4)£ºÕý³£°²×°oracleÈí¼þ£¨Ö®Ç°ÔÚpubÉÏһλÐÖµÜ˵²»ÐèÒª°²×°oracle¾Í¿ÉÒԸ㶨£¬±íʾ»³ÒÉ£©£¬Ö»ÐèÒª°²×°Èí¼þ£¬¿ÉÒÔ²»Óý¨ÊµÀý£¬½¨ÊµÀýµÄʱ¼äÒ²±È½Ï³¤£¬Ò²Ã»ÓбØÒª¡£ Èí¼þ°²×°ºÃÒԺ󣬿ªÊ¼×¼±¸»Ö¸´¡£
(5)£ºÊý¾Ý¸²¸Ç¹ýÈ¥°üÀ¨pwdÎļþ£¬·ÅÔÚÔ­À´µÄĿ¼£¬Èç¹ûĿ¼ÓÐËù¸Ä±äÔòÐèÒªÁíÍ⽨Á¢¿ØÖÆÎļþ£¬ÐÞ¸Äpfile¡£
(6)£º½¨Á¢·þÎñ£ºÊ¹ÓÃoradim ÃüÁî cmdÏ oradim -new -sid erp ±íʾ½¨Á¢Ò»¸ö·þÎñ£¬sidΪerp¡£¹ØÓÚoradimµÄÃüÁîÁíÍâ¸ø³öרÃŽâÊÍ¡£
(7)£º½¨Á¢¼àÌý£º net configuration assintant À´½¨Á¢£¬»òÓýű¾½¨Á¢²¢ÇÒ¿ªÆô¡£
(8)£º´ò¿ªÊý¾Ý¿â£º ÓÃoemÒ²ÐУ¬cmdÏÂÒ²ÐС£
set oracle_sid=erp;
sqlplus "/as sysdba";
startup;
select * from v$instance;
ÖÁ´Ë£¬À䱸·Ý»Ö¸´³É¹¦¡£¼´Ê¹ÄãÏÖÔÚÓÃoem´ò¿ªÊý¾Ý¿âʱ·¢ÏÖÌáʾÕÒ²»µ½sid £¬µ«Êµ¼ÊÉÏÄãÒѾ­³É¹¦ÁË£¬´ËʱֻÐèÒªÖØÆôһϵÄÄãµÄ·þÎñÆ÷¾Í¿ÉÒÔÁË¡£


Ïà¹ØÎĵµ£º

ÓÃradiusºÍoracle×öÈÏÖ¤¼Æ·Ñϵͳ


Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
   
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊ ......

JDBC´æÈ¡ORACLE´óÐÍÊý¾Ý¶ÔÏóLOB¼¸ÖÖÇé¿öµÄʾ·¶Àà

      import Java.io.*;
¡¡¡¡import java.util.*;
¡¡¡¡import java.sql.*;
¡¡¡¡public class LobPros
¡¡¡¡{
¡¡¡¡/**
¡¡¡¡* OracleÇý¶¯³ÌÐò
¡¡¡¡*/
¡¡¡¡private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
¡¡¡¡/**
¡¡¡¡* ORACLEÁ¬½ÓÓÃURL
¡¡¡¡*/
¡¡¡¡p ......

oracle ·ÖÇø²ð·Ö ²»ÄܲåÈëÊý¾Ý 01502 Ë÷ÒýʧЧ

Êý¾Ý±íday_energyµ±Ç°ÎªÔ·ÖÇø±í£¬·ÖÇøÐÅÏ¢ÈçÏ£ºDE_200912,DE_201001,DE_201002.....,Ô·ÖÇø±í³öÏÖËٶȲéѯÂý£¬Òò´Ëͨ¹ý½¨Á¢ÈÕ·ÖÇø±í½øÐиÄÉÆ¡£
²ð·ÖÔ·ÖÇø±íµÄÓï¾äΪ£º
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
·ÖÎö£º
alter table ±íà ......

Oracle Finalizes Acquisition of Sun


We are pleased to announce that Oracle has completed its acquisition of Sun Microsystems and Sun is now a wholly owned subsidiary of Oracle. With this news, we want to reiterate our commitment to deliver complete, open and integrated systems that help our customers improve the performance, reliabi ......

oracle´¥·¢Æ÷

´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ËüÔÚ²åÈ룬ɾ³ý»òÐÞ¸ÄÌØ¶¨±íÖеÄÊý¾Ýʱ´¥·¢Ö´ÐУ¬Ëü±ÈÊý¾Ý¿â±¾Éí±ê×¼µÄ¹¦ÄÜÓиü¾«Ï¸ºÍ¸ü¸´ÔÓµÄÊý¾Ý¿ØÖÆÄÜÁ¦¡£Êý¾Ý¿â´¥·¢Æ÷ÓÐÒÔϵÄ×÷Óãº
¡¡¡¡* °²È«ÐÔ¡£¿ÉÒÔ»ùÓÚÊý¾Ý¿âµÄֵʹÓû§¾ßÓвÙ×÷Êý¾Ý¿âµÄijÖÖȨÀû¡£
¡¡¡¡# ¿ÉÒÔ»ùÓÚʱ¼äÏÞÖÆÓû§µÄ²Ù×÷£¬ÀýÈç²»ÔÊÐíϰàºóºÍ½Ú¼ÙÈÕÐÞ¸ÄÊý¾Ý¿âÊý¾Ý¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ