07 2015 档案

ORA-00119 ORA-00132 解决方案
摘要：修改过ora配置文件后, 连接上远程机器, 有一阵子没有再用本地, 今天启动发现报下面的错误windows报如下错误：ORA-00119: invalid specification for system parameterLOCAL_LISTENERORA-00132: syntax error ... 阅读全文

posted @ 2015-07-13 14:57 limho

ORA-12514（TNS:监听程序当前无法识别）解决方案
摘要：标红的是添加的代码SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = F:\app\linhu\product\11.2.0\dbhome_1) (... 阅读全文

posted @ 2015-07-13 14:51 limho

Oracle listener.ora和tnsname.ora配置
摘要：listener.ora配置SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = F:\app\linhu\product\11.2.0\dbhome_1) ... 阅读全文

posted @ 2015-07-13 14:48 limho

oracle表空间和用户的创建、修改、授权、查看等执行SQL
摘要：--创建表空间CREATE TABLESPACE hy_framework DATAFILE '/home/oracle/app/oradata/orcl/HY.dbf' --windows下的路径 H:\app\TigerLin\oradata\orcl\HY.dbfsize 500m AUTOE... 阅读全文

posted @ 2015-07-09 09:11 limho

导航