如何在Java中以"SYS“身份从SQL*Plus连接到Oracle
如何在Java中以"SYS“身份从SQL*Plus连接到Oracle
提问于 2014-04-10 12:17:37
我想在Java中以SYS的身份从SQL*Plus连接到Oracle。但是我连接不上。但我能够以名为SCOTT的用户身份进行连接。我的代码片段如下：
public static void test_script () {
String fileName = "@t.sql";
//t.sql contains "show user" command
String sqlPath = "D:\\";
String sqlCmd = "sqlplus";
// String arg1 = "scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname)(Port=PORT ID))(CONNECT_DATA=(SID=SID)))";
String arg1 = "sys as sysdba/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname)(Port=PORT ID))(CONNECT_DATA=(SID=SID)))";
//String arg1="/ as sysdba";
String arg2= fileName;
//String arg2="conn /as sysdba";
try {
String line;
ProcessBuilder pb = new ProcessBuilder(sqlCmd, arg1,arg2);
Map<String, String> env = pb.environment();
env.put("VAR1", arg1);
env.put("VAR2", arg2);
//env.put("VAR3", arg3);
pb.directory(new File(sqlPath));
pb.redirectErrorStream(true);
Process p = pb.start();
BufferedReader bri = new BufferedReader
(new InputStreamReader(p.getInputStream()));
BufferedReader bre = new BufferedReader
(new InputStreamReader(p.getErrorStream()));
while ((line = bri.readLine()) != null) {
System.out.println(line);
}
bri.close();
while ((line = bre.readLine()) != null) {
System.out.println(line);
}
bre.close();
System.out.println("\n\n\n");
System.out.println("Done.");
}
catch (Exception err) {
err.printStackTrace();
}
}
} 当我尝试运行这段代码时，我发现了这个错误：
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 10 11:08:59 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL*Plus: Release 11.2.0.1.0 Production
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.
Usage 1: sqlplus -H | -V
-H Displays the SQL*Plus version and the
usage help.
-V Displays the SQL*Plus version.
Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]
.....。和其余的SQL*Plus‘使用’信息。
我是否提供了错误的arg1参数，或者是否有通过Java在Oracle中以SYS身份连接的任何其他方法。
回答 4
Stack Overflow用户
发布于 2014-04-10 15:35:40
您将所有连接信息作为单个值传递；等同于从命令行传递以下内容：
sqlplus "sys as sysdba/tiger@<connect_string>"这将得到与打印SQL*Plus登录帮助相同的响应。你也把你的密码放在了错误的地方，但它不会走那么远。在命令行中，这是可行的：
sqlplus "sys/tiger" "as" "sysdba@<connect_string>"因此，您需要向ProcessBuilder传递5个参数，如下所示：
String sqlCmd = "sqlplus";
String arg1 = "sys/tiger";
String arg2 = "as";
String arg3 = "sysdba@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname)(Port=PORT ID))(CONNECT_DATA=(SID=SID)))";
String arg4 = fileName;
...
ProcessBuilder pb = new ProcessBuilder(sqlCmd, arg1, arg2, arg3, arg4);仅当您的环境配置为允许以sysdba身份进行远程连接时，这才会起作用。以sys身份执行任何操作应该是非常罕见的，并且拥有一个您想要以sys身份运行的脚本似乎足够不寻常，以至于Java包装器看起来像是大材小用--并且使您看起来像是以sys身份例行公事地连接，这不是一个好主意--但这可能只是一个学习练习。
Stack Overflow用户
发布于 2014-04-11 17:58:23
我通过点击并尝试找到了答案，它是连接字符串。
如果要以sysdba/sysoper身份连接，则连接字符串应如下所示：
public static void test_script () {
String fileName = "@t.sql";
String sqlPath = "D:\\";
String sqlCmd = "sqlplus";
// IP_address,portid and sid are variables to be entered and t.sql is the file to be read .It contains show user command
String arg3 = "sys/oracle123@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=IP_address)(Port=portid))(CONNECT_DATA=(SID=sid))) as sysdba";
String arg4= fileName;
try {
String line;
ProcessBuilder pb = new ProcessBuilder(sqlCmd,arg3,arg4);
Map<String, String> env = pb.environment();
env.put("VAR3", arg3);
env.put("VAR4", arg4);
pb.directory(new File(sqlPath));
pb.redirectErrorStream(true);
Process p = pb.start();
BufferedReader bri = new BufferedReader(new InputStreamReader(p.getInputStream()));
BufferedReader bre = new BufferedReader(new InputStreamReader(p.getErrorStream()));
while ((line = bri.readLine()) != null) {
System.out.println(line);
}
bri.close();
while ((line = bre.readLine()) != null) {
System.out.println(line);
}
bre.close();
System.out.println("\n\n\n");
System.out.println("Done.");
} catch (Exception err) {
err.printStackTrace();
}
} Stack Overflow用户
发布于 2014-04-10 13:12:30
我认为你的arg1应该如下所示：
String arg1 = "scott as sysdba/<syspwd>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname)(Port=PORT ID))(CONNECT_DATA=(SID=SID)))";页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/22978542
复制相关文章
相似问题