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

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