|
M*****r
发帖数: 1536 | 2 能不能先定义一下“强大”？
A 比 B 强大是什么意思？ |
|
d****e
发帖数: 2856 | 3 强大在于一个敲敲键盘、记得一大堆指令，另一个用鼠标点点点？ |
|
|
|
|
|
|
c*********e
发帖数: 16335 | 9 sqlplus啊，不过username,password还是要问学校。是的，即使username,password对
，有时也会连不上。多连几次就好了。 |
|
|
c*********e
发帖数: 16335 | 11 sqlplus啊，不过username,password还是要问学校。是的，即使username,password对
，有时也会连不上。多连几次就好了。 |
|
m****d
发帖数: 372 | 12 listener启动的时候TNS_ADMIN设置不同于当前的TNS_ADMIN？
db_a server上：
sqlplus user/pwd@db_a
select * from db_link? 有问题吗？
如果没问题，db_a是不是设置了shared_server? |
|
a****b
发帖数: 489 | 13 在linux虚拟机上安装Oracle12c成功，并且启动了Listener， 已经可以在该Linux上使
用sqlplus。但是，虚拟机的宿主机（windows7）在安装SQL Developer以后，却还是无
法使之与Linux下的oracle建立连接。另外，我也在Win7上装了Oracle Client。。。还
是不行。问题可能会出现在哪里呢。另外，从宿主机（w7）ping虚拟机（Linux）只能
用ping虚拟机的ip address，而不是虚拟机名。
哪位朋友能给指点一下吗 |
|
|
c*****d
发帖数: 6045 | 15 在hosts文件里加上host/ip
然后一步一步测试
ping ip
ping host
tnsping tnsname
sqlplus user/password@tnsname |
|
c*****d
发帖数: 6045 | 16 如果是数据库管理，用sqlplus就行
如果是数据库编程，sql developer or toad |
|
a****b
发帖数: 489 | 17 我也在用sql developer，可是看到书的格式是sqlplus的格式，觉得未免有点过分了，
谁知道里面有啥table啥column啊 |
|
s*******9
发帖数: 5 | 18 在虚拟机里装了个RAC，发现个问题：
环境是这样的：
oracle virtual box 4.3.14
redhat linux enterprise edition 5.10
oracle rac and oracle clusterware 10.2.0.5.0
crs_stat -t
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONL... 阅读全帖 |
|
p*a
发帖数: 592 | 19 你这个client_1和dbhome_1哪个是64bit的？你可以去相关目录运行.\sqlplus，看看能
不能连上你的oracle。
files(
x86 |
|
w******n
发帖数: 692 | 20 It doesn't look like a java problem. I guess you don't configure
Oracle client. Can you connect oracle database using sqlplus in
the machine? |
|
w*r
发帖数: 2421 | 21 right right.. .this is the basic testing method.. sqlplus will give you
a direct answer... |
|
t*******y
发帖数: 57 | 22 【 以下文字转载自 Database 讨论区 】
【 原文由 tribology 所发表 】
这几天真是见了鬼了
在Linux下单独写个standalone的java程序用JDBC访问oracle一点问题都没有
换写成servlet来通过JDBC访问oracle竟然只能做"select .."这样的sql访问
用什么insert/update/desc之流的sql命令通通给我出错,
说什么java.sql.SQLException: SQL string is not Query
ft,明明直接把那些sql命令放入sqlplus执行和放在standalone的java程序里面
执行一点问题都没有.google了半天没有啥结果.
这个到底啥原因有人知道么?难道用servlet调用jdbc数据库还有权限限制?
用perl写的cgi调用数据库也一点问题都没有呀. |
|
w******n
发帖数: 692 | 23 Maybe you could run the stored procedure through sqlplus. If failed and you
have the source code of the stored procedure, You may add some DBMS_OUTPUT
there to debug the stored procedure. |
|
v***e
发帖数: 2108 | 24 在oracle rdbms具体到核心层，SP和你在sqlplus run一个sql是
同一个infrastructure，
具体用多少db的cpu/memory/io,是根据具体你做的事情，不太清楚和
是sp还是不是sp有什么太大关系。
vendor
SP |
|
|
|
e***e
发帖数: 168 | 27 can this be done for screen?
My enviroment is use screen to open many buffers. Then, I use sqlplus
command line to connect Oracle. The problem is I insert a text frequently
when I type Sql query. So, can this be done in screen too?
I know screen has a copy mode, that allow you to use vi to copy.
ctrl+a , [ will enter this copy mode. and press Esc to exit this mode.
Then, press ctrl+a, ] will past what you have copied in vi mode.
But I do not know if I can use screen to buffer some text, and then |
|
w*m
发帖数: 1806 | 28 for example,
#/!bin/csh
sqlplus -silent id/password@oracel_instance <
"%s",$1;}' | echo(I want to set xx=..)
select id from table;
EOF
awk处理后的结果，如何赋值给一个变量呢？ |
|
S*A
发帖数: 7142 | 29 不会用 csh.
bash 里面大概是
varname=`sqlplus -silent id/password@oracel_instance <
printf("%s",$1;}'
"%s",$1;}' `
printf( |
|
l*******G
发帖数: 1191 | 30 use ` ` or $()
such as
varname=$(sqlplus -silent id/password@oracel_instance <
echo $varname |
|
c******n
发帖数: 4965 | 31 it always gives extremely long lines, even if there is no content inside,
tried tora, but it only gives my mysql provider type, no oracle, though I
installed oracle on my box. |
|
c******n
发帖数: 4965 | 32 did that, but then u will get ugly line wrapping
it took me a lot of time to compile tora on linux, but after start up it
does not function properly... damn
now installing TOAD on windows, and it says no oracle client |
|
c******n
发帖数: 4965 | 33 this is what doesn't work for me:
I do a
select * from mytable;
then there are many columns, so I need to do
set lin 200
so they do not wrap around
then when I do a describe mytable,
the result has only 2 columns, but now they are shown really far apart; what
's worse, if I set lin=20000 to disable any line wrapping, (I can do this
because I could spool the output to a file, and later read in vim, with
nowrap option), these 2 columns are displayed in a completely messed up way |
|
t*******y
发帖数: 57 | 34 【 以下文字转载自 Database 讨论区 】
【 原文由 tribology 所发表 】
这几天真是见了鬼了
在Linux下单独写个standalone的java程序用JDBC访问oracle一点问题都没有
换写成servlet来通过JDBC访问oracle竟然只能做"select .."这样的sql访问
用什么insert/update/desc之流的sql命令通通给我出错,
说什么java.sql.SQLException: SQL string is not Query
ft,明明直接把那些sql命令放入sqlplus执行和放在standalone的java程序里面
执行一点问题都没有.google了半天没有啥结果.
这个到底啥原因有人知道么?难道用servlet调用jdbc数据库还有权限限制?
用perl写的cgi调用数据库也一点问题都没有呀. |
|
|
x**g
发帖数: 40 | 36 every time when i enter oracle, i should set up the path
before i go to use sqlplus. such as $ORACLE_HOME, PATH, and
$ORACLE_SID, so is there any way that i can code a small
shell script to make it works, and idon't have to type them
everytime. I have tried a lot, but i don't know where to put
the shell script and also don't know how to write this shell
script efficiently. thank you very much. |
|
y**e
发帖数: 13 | 37 I installed oracle 9.2. I create two database: db1 with sid as db1, db2 with
sid as db2. Then I can do anything I want without problem.
But after I shut down computer and reboot again. Then I found I can't start my
oracle server anymore.
I use dbshut and dbstart command, there is nothing display.
I use ps -ef |grep smon, there is nothing display
I try to use sqlplus to connect, it give errors:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No |
|
i**********1
发帖数: 23 | 38 职位描述如下：
Job Description:
Provide level 2 Oracle Financial App tech support to client internal users
Qualification:
Good communication and problem solving skills
Good SQL, SQLPlus skills
Oracle Financial (E-Business Suite, ERP), either version 11 or 12 are both
ok
Good understanding on AP, AR, Procurement workflow processes
Good understanding of ERP concept
P2P business domain knowledge
3-5 year experience is enough
请感兴趣的朋友联系我
谢谢大家 |
|
i**********1
发帖数: 23 | 39 Job Description:
Provide level 2 Oracle Financial App tech support to client internal users
Qualification:
Good communication and problem solving skills
Good SQL, SQLPlus skills
Oracle Financial (E-Business Suite, ERP), either version 11 or 12 are both
ok
Good understanding on AP, AR, Procurement workflow processes
Good understanding of ERP concept
P2P business domain knowledge
3-5 year experience is enough
请发站内短信联系我。
谢谢。 |
|
i**********1
发帖数: 23 | 40 Job Description:
Provide level 2 Oracle Financial App tech support to client internal users
Qualification:
Good communication and problem solving skills
Good SQL, SQLPlus skills
Oracle Financial (E-Business Suite, ERP), either version 11 or 12 are both
ok
Good understanding on AP, AR, Procurement workflow processes
Good understanding of ERP concept
P2P business domain knowledge
3-5 year experience is enough
请发站内短信联系我。
谢谢。 |
|
