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

¼±£¡£¡£¡ÏòoracleÖвåÈëÊý¾Ýʱ³öÏÖ´íÎó

ÎÊÌâÃèÊö£º
ÎÒÔÚoracleÖн¨Á¢ÁËÁ½ÕÅ±í£¬t_terminal ºÍt_layout ,¹ØÏµÊÇÒ»¶Ô¶à£¬ÎÒÏòÒ»µÄÕâ¶Ë£¨t_terminal£©²åÈëÊý¾ÝÕý³££¬µ«ÊÇÎÒÏò¶àµÄÕâ¶Ë£¨t_layout£©²åÈëÊý¾Ý insert into t_layout values(1,'²¼¾Ö1',1,'bujuyi',0);³öÏÖÏÂÃæµÄ´íÎó

ORA-04098: ´¥·¢Æ÷ 'BULLETIN.TU_T_LAYOUT' ÎÞЧÇÒδͨ¹ýÖØÐÂÈ·ÈÏ
ORA-06512: ÔÚ"BULLETIN.TI_T_LAYOUT", line 9
ORA-04088: ´¥·¢Æ÷ 'BULLETIN.TI_T_LAYOUT' Ö´Ðйý³ÌÖгö
Íû¸ßÊÖÖ¸µã£¬Ð¡µÜ½«²»Ê¤¸Ð¼¤£¡QQ573486619£¬ÓÊÏ䣺hdc_love1@163.com

´¥·¢Æ÷'BULLETIN.TU_T_LAYOUT'ÓÐÎÊÌâ°¡ 

ÖØÐÂÖ´ÐÐһϴ´½¨´¥·¢Æ÷µÄ´úÂëÊÔÊÔ

http://blog.csdn.net/wengyupeng/archive/2008/09/24/2968580.aspx

Ã÷ÏÔ´¥·¢Æ÷ÓÐÎÊÌâ
¼ì²é¼ì²é

´¥·¢Æ÷´úÂëÌùÇÐÉÏÀ´¿´¿´

ÎÒÊÇÒ»¸öoracleÐÂÊÖ£¬ÎÒÔÚsystem Óû§Ï´´½¨ÁËÁËÒ»¸öÓû§
create user XXX identified by XXX
default tablespace users
temporary tablespace temp
quota 10M on users;

ÊÜȨÏÞ grant resource, connect to XXX
½ÓÏÂÀ´¾ÍÊÇÔÚXXXÓû§Ï½¨Á¢±íÁË£¬ÎÒ¶Ô´¥·¢Æ÷²»ÊǺÜÁ˽⣬Íû¸ßÊÖÖ¸µãÖ¸µã£¬Ð¡µÜºÜ¼±°¡£¡

  Õâ¸ö¿Ï¶¨ÊÇÄã´¥·¢Æ÷µÄÎÊÌ⣬Äã¶Ô´¥·¢Æ÷²»ÊìϤ£¬Ôõôд³öÀ´µÄ°¡£¬£¬

Äã´¥·¢Æ÷ʵÏÖµÄÊÇ Ê²Ã´¹¦ÄÜ£¬Ìù³öÀ´¿´¿´

½¨Òé°Ñ´¥·¢Æ÷µÄ´úÂëÌù³öÀ´¡£
²»¿´¼û´úÂ룬û·¨¶¨Î»ÎÊÌâ¡£

ÎÒûÓÐдʲô´¥·¢Æ÷°¡£¬ÎÒÊÇÓÃERWin¹¤¾ßÁ¬½Óµ½oracleÊý¾Ý¿âÖУ¬°Ñ±í×Ô¶¯½¨Á¢ºÃµÄ£¬ÎÒÏÖÔÚ¾ÍÊÇÊÖ¶¯µÄ ²åÈëÊý¾Ý³öÏÖÏÂÃæ´íÎó£¬ÎÒ²»ÖªÊÇÔõô»ØÊ£¿
ORA-04098: ´¥·¢Æ÷


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ