我的oracle 装在linux 上, 客户端装在windows XP 下, 我还在XP上装了toad, 可是toad能连上oracle, XP上的sqlplus却连不上, 报错: ora-12514:TNS:listener does not currently know of service requested in connect descriptor. 有可能是什么原因?

1. data guard中的ora-12514: TNS:listener does not currently know of service requested in connect descriptor 2.[code][oracle@node1 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by oracle configuration tools. LSNODE2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node2...

ora-12505, TNS:listener does not currently know of sid given in connect descriptor
The Connection descriptor used by the client was...

only create listener by netca is not sufficient, manually add block in listener.ora
ps.also check your tnsnames.ora corresponding rows
#new added:
sid_LIST_mysid1 =
  (sid_LIST =
    (sid_DESC =
   &nbs...

i just get into here as an english/chinese application tester any comments?

oracle 9.2.0.1.0 window xp - question 1 我在$oraCLE_HOME/database下同时有init${sid}.ora和spfile${sid}.ora, 为什么修改init${sid}.ora中的参数值不起作用. - question 2 因为spfile是二进制的, 无法直接修改(据说直接修改该文件会导致数据库无法启动) 我是不是可以用 create pfile='c:/mypfile.ora' from spfile; 之后修改mypfile.ora的值 create spfile from pfile='c:/mypfile.ora' 的方式来修改spfile?

   今天在服务器上刚装好数据库，发现oracle进程有六十几个ora_p*_sid的进程，查了个资料才知道原来如此----这是并行执行的进程,对应的初始化参数是：PARALLEL_MAX_SERVERS
这个PARALLEL_MAX_SEVERS参数设置并行执行可用的最大进程数量，
该参数的缺省值如下得出：
对于9i
1.如果PARALLEL_AUTOMATIC_TUNING=FALSE
PARALLEL_MAX_SERVERS=5
2.如果PARALLEL_AUTOMATIC_TUNING=TRUE
PARALLEL_MAX...

摘　要： Recent legislation, such as the Sarbanes-Oxley Act and the Health Insurance Portability and Accountability Act (HIPAA), is forcing companies to retain information at a much faster rate and in vastly greater amounts for much longer than ever before. In addition, that information must be more readily accessible, making tape less practical.

I want to define the macros in configuer.ac and Makefile.in, so that the system (using the generated configure sript) can detect, which C/C++ compiler (cc, gcc, icc etc.) according to system type (sun, linux, etc) to choose. Anybody has an idea? I just find the online gnu documentations are rather useless for beginners. Thanks from a beginner.

I want to define the macros in configuer.ac and Makefile.in, so that the system (using the generated configure sript) can detect, which C/C++ compiler (cc, gcc, icc etc.) according to system type (sun, linux, etc) to choose. Anybody has an idea? I just find the online gnu documentations are rather useless for beginners. Thanks from a beginner.

OS:RHEL4 oraCLE:10GR2 数据库启动后有一个这样的进程: oracle 10193 0.0 1.0 373568 10640 ? Ss Jan18 0:00 ora_psp0_ortest 不明白这个进程是什么作用!