2. 技术人生
    3. sqlplus连接远程oracle

    sqlplus连接远程oracle

    技术2022-05-20  37

    1.首先安装oracle9i 的客户端

     

    2.配置tnsnames.ora

     

    TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 196.168.1.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

     

    3.开始--->运行--->cmd(命令：sqlplus /nolog)

     

    4.conn user/pwd@TEST(TEST是tnsnames.ora配置的) 或直接登录sqlplus user/pwd@TEST

     

    5.接下来会提示连接成功或失败

      

    专利

    最新回复(0)