Oracle sqlplus远程连接数据库
sqlplus username/password@yunSID_192.168.1.5
tomcat目录名不能有空格
创建用户:create user 用户名 IDENTIFIED BY 密码
增加权限:GRANT DBA,CONNECT,RESOURCE TO 用户名字
到出数据库:exp username/password@orcl1 orcl1在tnsnames.ora文件中配置
导入数据库:imp username/password@orcl file="d:/bak.dmp"
tnsnames.ora文件的几种配置方法
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl1)
)
)
ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl2)
)
)
ORCL3=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL3)
)
)