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

oracle 11g ORA 12514´íÎó£¬ÎҵĽâ¾ö°ì·¨

Ç°ÑÔ:ÍøÉÏÓкܶà½â¾ö°ì·¨£¬É¾listener.oraÒ²ºÃ£¬»¹ÊÇʲôҲºÃ£¬¶¼½â¾ö²»ÁËÎÒÕâ¸öÎÊÌ⣬ÒÀÈ»±¨12514´íÎó£¬ÒÔÏÂÊÇÎÒÖð¸ö³¢ÊÔºó³É¹¦µÄ¼àÌý×Ö·û´®¡£¡£
listener.oraÎļþ£º
# listener.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = cjtfs)   
      (ORACLE_HOME = d:\app\john\product\11.1.0\db_1)
      (PROGRAM = cjtfs)
    )
     (SID_DESC =
      (GLOBAL_DBNAME = cjtfs)
      (ORACLE_HOME = d:\app\john\product\11.1.0\db_1)
      (SID_NAME = cjtfs)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    )
  )
tnsnames.oraÎļþ£º
# tnsnames.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
CJTFS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cjtfs)   #ÒªºÍlistener.oraÀïÃæµÄcjtfsλÖõÄÃû×Ö±£³ÖÒ»ÖÂ
    )
  )
Èç¹û»¹½â¾ö²»ÁË£¬ÄǾÍÁôÑÔ£¬ÎÒÒ»°ã»á³£¿´blogµÄ¡£¡£¡£¡£´ó¼ÒÒ»Æð½â¾ö¡£¡£»¥Ïàѧϰ¡£


Ïà¹ØÎĵµ£º

Ïê½âOracleÓû§½âËøÃüÁîµÄÁ½ÔòʵÏÖ·½·¨

ÔÚ°²×°ÍêOracle
10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃ漸¸öÔ­Òò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨ ......

oracleÊý¾Ý¿âÎļþÔÚ´ÅÅÌÖеÄÒƶ¯

1¡¢¹Ø±ÕÊý¾Ý¿â >>shutdown immediate;
2¡¢¿½±´Îļþ£¨*.dbf)µ½Ä¿µÄÎļþ¼Ð;
3¡¢Æô¶¯Êý¾Ý¿â >>startup mount;
4¡¢¸ü¸Ä·¾¶
>>alter database rename file 'C:\oracle\oradata\global\USERS01.DBF' to 'D:\oracle\USERS01.DBF';
>>alter database rename file 'C:\oracle\oradata\global\UNDOTBS ......

linux redhat4+oracle10g

ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......

Oracle³£¼ûÎÊÌâÕï¶Ï


1       ORA-12571¡¢ORA-03113¡¢ORA-03114¡¢ORA-01041
ÌØÕ÷£º¿Í»§¶Ë£¨´úÀí»òÓ¦Ó÷þÎñÆ÷£©ÓÐʱ±¨ÕâÀà¶ÏÁ¬´íÎó
Ô­Òò£ºÈç¹ûż¶û³öÏÖÒ»´Î£¬Ôò¿ÉÄÜΪÍøÂçÔ­Òò»òÓû§Òì³£ÖÐÖ¹£¬Èç¹û¾­³£³öÏÖÔòΪ¿Í»§¶ËÓë·þÎñ¶ËµÄ×Ö·û¼¯²»Ò»Ö¡£
´ëÊ©£ºÈç¹ûż¶û³öÏÖ£¬¿ÉÔÚ·þÎñ¶ËµÄЭÒéÅäÖÃÎļþPROTOCOL.ORAÖÐÔö¼ÓÒ»ÐÐ
TC ......

oracle apache phpÂÒÂëÎÊÌâ

°ì·¨Ò»
select * from V$NLS_PARAMETERS
  $conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
 while ($dat = oci_fetch_row($cur)) {  
    print_r(iconv('gb2312', 'utf-8', $dat[0]));  //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ