oracle修改原始账号密码如何配置数据库Oracle

如何配置数据库Oracle

 

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora 

# Generated by Oracle configuration tools. 

  www.2cto.com  

ORACLE90 = 

  (DESCRIPTION = 

    (ADDRESS_LIST = 

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.90)(PORT = 1522)) 

    ) 

    (CONNECT_DATA = 

      (SERVICE_NAME = oracle) 

    ) 

  ) 

 

ORACLE79 = 

  (DESCRIPTION = 

    (ADDRESS_LIST = 

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.79)(PORT = 1521)) 

    ) 

    (CONNECT_DATA = 

      (SERVICE_NAME = orcl) 

    ) 

  ) 

&nbsporacle账号;

//该文件的默认路径为C:\Oracle\ora90\network\ADMIN\tnsnames.ora。 

注意：要先装Oracle客户端，然后在上面这个路径中配置上数据库路径。 

然后再安装pl/sql,就可以连接数据库了。