tnsnames.ora文件中配置及导入导出

来源：互联网发布：壁挂式新风系统知乎编辑：程序博客网时间：2024/05/16 10:31

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)
    )
)