oracle提供了强大的管理工具sqlplus给dba使用，如何提供用户名、密码、ip、端口和服务名来访问数据库，以下是几种写法测试，完整的写法应该是要带上引号的，避免有些特殊字符的影响而连不上数据库。
写法一：sqlplus 用户名/密码@访问ip:端口/监听服务名
[oracle@racdb2 ~]$ sqlplus system/manager@192.168.65.135:1521/racdb SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 20 15:07:12 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options写法二：sqlplus "用户名/密码@'访问ip:端口/监听服务名'"
[oracle@racdb2 ~]$ sqlplus "system/manager@'192.168.65.135:1521/racdb'" SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 20 15:07:20 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options写法三：sqlplus "用户名@'访问ip:端口/监听服务名'"
[oracle@racdb2 ~]$ sqlplus "system@'192.168.65.135:1521/racdb'" SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 20 15:07:26 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
