Ôö¶àoracle¹²ÏíÄÚ´æ´¢Æ÷
ÈçÆä·¢ÏÖoracle¹²ÏíÄÚ´æ²»×㣬ÕÐÖÂÊý¾Ý¿âû·¨Ò»°ãÊ©Óã¬Ø½Ðè½øÕ¹ÄÚ´æ´¢Æ÷²ÎÊýÅú¸Ä£¬·½·¨Èç´Î£º
Ò»¡¢µÇ½Êý¾Ý¿â,²é¿´Ä¿Ç°Êý¾Ý¿âÔËÓõÄÊÇpfileÈÔÊÇspfile£¬Õý³£Çé¿ö϶¼ÊÇÔËÓÃspfileÆð¶¯.
¶þ¡¢´´Ôìpfile Ê©ÓÃcreate pfile from spfileÏÂÁÁ¢£¬×¥ºÃ±¸·Ý¡£
Èý¡¢Í¸¹ýeditplusµÈÎı¾¹¤¾ß´ò¿ª×ÊÁÏ,ÕûºÏ¾ßÌåµÄ²ÎÊý.Èç¹ûÔÚsolarisÍ£¿ÉÒÔÖ±½ÓÓ¦ÓÃviÅú¸Ä£¬Åú¸ÄÊÂǰÌáÒéÏȱ¸·Ýpfile²ÎÊý×ÊÁÏ£¬Åú¸ÄÈç´Î²ÎÊý£¬ÈçÈôû¿ÉÔö¼Ó£¬²ÎÕÕÈç´Î£º
*.pga_aggregate_target=419430400
*.sga_target=1258291200
ËÄ¡¢Æäºó·âËøÊý¾Ý¿â£¬ÔËÓÃpfile À´Æð¶¯Êý¾Ý¿â¡£
Îå¡¢Æð¶¯Ë³Àûºó£¬Õ¹Ê¾Åú¸ÄµÄ²ÎÊýÊDz»ÊÇ׼ȷ£¬Ó¡Ö¤¿ÉÒÔ˳ÀûÆð²½ºó¡£
Áù¡¢·â±ÕÊý¾Ý¿â£¬Ó¦ÓÃpfile´´Ôìspfile£¬ÆäºóÒ»°ãÆð²½Êý¾Ý¿â¡£
±¾ÎÄÀ´Ô´£º
ÎÒµÄÒì³£Íø
Java Exception
Dotnet Exception
Oracle Exception
1695 - Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
1696 - ÔõÑùÔÚ·þÎñÀïÌí¼Ó OracleOraHome92TNSListener
1697 - ÓαêǶÌ×ʹÓÃ
1698 - HRESULT: -2146234299
1699 - ÈçºÎÔÚOracleÖн¨Á¢×÷Òµ
1700 - Visual Studio.NETÒѼì²âµ½Ö¸¶¨µÄWeb·þÎñÆ÷ÔËÐеIJ»ÊÇASP.NET 1.1°æ
1701 - org.hibernate.MappingException: Could not determine type for: java.lang.string
1702 - java.lang.IllegalStateException: getOutputStream() has already been called for this response
1703 - Error reading tld listeners java.lang.NullPointerException
1704 - An error has occurred.See error log for more details
1705 - javax.xml.parsers.FactoryConfigurationError: Provider org.apache.xerces.jaxp.DocumentBuilderFactoryImpl not found
1706 - java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
1707 - javax.naming.NameNotFoundException: Authentication not bound
1708 - org.eclipse.swt.SWTException: Invalid thread access
1709 - org.apache.japer.japerexception:exception in jsp
1710 - java.lang.ClassCastException: org.apache.naming.resources.FileDirContext
1711 - java.lang.IllegalStateException: Assertion failed. WindowsAPI is required to be called from AWT thread only
1712 - java.lang.NoClassDefFoundError: org hibernate cfg HbmBinder$SecondPass
1713 - org.hibernate.MappingException:
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1999ÄêµÄÊý¾Ý( ......
OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе½ ......
ODP.NET 11gÊÇOracle¹«²¼µÄ¹©.NET³ÌÐò·ÃÎÊOracleÊý¾Ý¿âµÄADO.NET×é¼þ£¬±È΢Èí×Ô´øµÄOracle×é¼þÐÔÄܺ㬸ü¿ÉÒÔ·ÃÎÊUDT(User Defined Type)²¿À࣬Procedure£¬REFÖ®Àà¸ß¼¶OracleÌØÕ÷¡£
¡¡¡¡.NET 1.1µÄ¿Í»§¶Ë¼±ÐèµÄ¹«²¼×ÊÁÏÈç´Î£º
¡¡¡¡¡ôOracle.DataAccess.dll (odt111odp.netinÒ».x)
¡¡¡¡¡ôOraOps11.dll £¨odt111in£© ......