测试sqlplus连接遇到错误 syntax error near unexpected token `('
来源:互联网 发布:深圳通充值软件 编辑:程序博客网 时间:2024/05/18 03:06
平时都是直接在sqlplus后面用TNS,后来看文档的时候,发现有好几种方法。于是就来试试“Full Connection Identifier“。 居然报错。
[oracle@ttt admin]$ sqlplus test@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.1.1.1)(PORT=1521) )(CONNECT_DATA=(SERVICE_NAME=test.aa.com) ) )
-bash: syntax error near unexpected token `('
[oracle@ttt admin]$
这个可是从文档上面拷贝下来改的,应该是对的啊。
后来在连接串两边加上”“, 就可以了。
sqlplus test@"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.1.1.1)(PORT=1521) )(CONNECT_DATA=(SERVICE_NAME=test.aa.com) ) )"
=== 后记:
如果是先用nolog进入sqlplus,然后使用则不用加上引号。
[oracle@TTT tmp]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 15 16:53:23 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect test@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.1.1.1)(PORT=1521) )(CONNECT_DATA=(SERVICE_NAME=test.aa.com) ) )
Enter password:
Connected.
SQL>
[oracle@TTT tmp]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 15 16:55:23 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect test/password@1.1.1.1:1521/test.aa.com
Connected.
SQL>
- 测试sqlplus连接遇到错误 syntax error near unexpected token `('
- 错误:syntax error near unexpected token `then'
- “syntax error near unexpected token `then'”错误
- -bash: syntax error near unexpected token `('--------错误
- syntax error near unexpected token `
- syntax error near unexpected token `('
- “syntax error near unexpected token `”
- syntax error near unexpected token `
- shell “syntax error near unexpected token '$'\r''” 错误解决方法
- linux--shell错误:syntax error near unexpected token ‘('
- shell中syntax error near unexpected token `fi'错误
- libtool: syntax error near unexpected token `]*'
- syntax error near unexpected token `('解决方法
- : syntax error near unexpected token `done'
- 脚本报syntax error near unexpected token `(',
- syntax error near unexpected token `elif'
- libtool: syntax error near unexpected token `]*
- syntax error near unexpected token `then'
- Qt for Android 配置详细
- [观点]给年轻程序员的几句话
- iphone开发重要基础知识------协议(Protocol)
- dispatchKeyEvent onKeyDown
- oracle 11g导出的dmp数据导入到oracle10g
- 测试sqlplus连接遇到错误 syntax error near unexpected token `('
- ubuntu 的挂起与休眠
- eCos FrameBuffer driver
- 嵌入式Linux入门学习规划(转)
- TCP 编程
- Java基础_I/O流
- 收藏几个blog和了解几个开源项目
- 数据结构_链表_稀疏多项式求值_C++实现
- WUBI安装UBUNTU,优化 swap 交换分区及调整swap大小