3 Replies Latest reply: Aug 1, 2014 7:45 AM by EdStevens RSS

    HOW TO CONNECT FROM CLIENT MACHINE TO REMOTE MACHINE(SERVER DATABASE MACHINE)

    2684285

      Hi friends.

      I need your valuable help,

      I am using oracle 11g database.

      I have two system.One is client machine and installed oracle 11G client software.

      and from this machine user can connect remote server database(This is old remote system, this is just for Information).

       

      And i have created one new database called RMANP in new remote server machine (this is the machine, in which i need to connect from client machine)

      ex

      CLIENT MACHINE DETAIL IS:

      system66

      ip address is 192.162.21.66

       

      REMOTE SEVER MACHINE DETAILS IS:

      system56

      ip address is 192.162.21.56.

       

      and i add entry on client machine tnsname.ora file like following,

      RMANP=

      (DESCRIPTION=

         (ADDRESS=

           (PROTOCOL=TCP)

           (HOST=192.168.21.56)

           (PORT=1521)

         )

         (CONNECT_DATA=

           (SERVICE_NAME=rmanp)

         )

      )

       

      But when i try to connect to remote server from client machine in sqlplus, i am getting an error, Like following,

      SQL> CONN SYS/SYSPW AS SYSDBA;

      ERROR:

      ORA-12560: TNS:protocol adapter error

        • 1. Re: HOW TO CONNECT FROM CLIENT MACHINE TO REMOTE MACHINE(SERVER DATABASE MACHINE)
          EdStevens

          2684285 wrote:

           

          Hi friends.

          I need your valuable help,

          I am using oracle 11g database.

          I have two system.One is client machine and installed oracle 11G client software.

          and from this machine user can connect remote server database(This is old remote system, this is just for Information).

           

          And i have created one new database called RMANP in new remote server machine (this is the machine, in which i need to connect from client machine)

          ex

          CLIENT MACHINE DETAIL IS:

          system66

          ip address is 192.162.21.66

           

          REMOTE SEVER MACHINE DETAILS IS:

          system56

          ip address is 192.162.21.56.

           

          and i add entry on client machine tnsname.ora file like following,

          RMANP=

          (DESCRIPTION=

             (ADDRESS=

               (PROTOCOL=TCP)

               (HOST=192.168.21.56)

               (PORT=1521)

             )

             (CONNECT_DATA=

               (SERVICE_NAME=rmanp)

             )

          )

           

          But when i try to connect to remote server from client machine in sqlplus, i am getting an error, Like following,

          SQL> CONN SYS/SYSPW AS SYSDBA;

          ERROR:

          ORA-12560: TNS:protocol adapter error

          There is nothing in your connect string to tell sqlplus which database you want to connect to.  Therefore it assumes (by default) that you want to connect to a *local* database whose name is identified by the value of the environment variable ORACLE_SID.  And there is no such database, so he gets the reported error trying to establish a connection to a non-existent local service.

           

          You need to specify your target database, thusly:

           

          SQL>  conn sys/syspw@rmanp as sysdba

           

          BTW, connecting to a remote database as sysdba is considered by most DBAs to be a big secruity breach.  If you really need sysdba privileges (rare) you should be logged on to the database server machine with proper OS credentials, and work from there.

           

          Also, TYPING IN ALL CAPS IS PERCEIVED AS SHOUTING.

          • 2. Re: HOW TO CONNECT FROM CLIENT MACHINE TO REMOTE MACHINE(SERVER DATABASE MACHINE)
            2684285

            HI.

            I followed the step in which u said, still i am same problem that is

             

            SQL> CONN SYS/SYSPW AS SYSDBA;

            ERROR:

            ORA-12560: TNS:protocol adapter error

             

            can u help me or any one have  Idea..

            • 3. Re: Re: HOW TO CONNECT FROM CLIENT MACHINE TO REMOTE MACHINE(SERVER DATABASE MACHINE)
              EdStevens

              2684285 wrote:

               

              HI.

              I followed the step in which u said, still i am same problem that is

               

              SQL> CONN SYS/SYSPW AS SYSDBA;

              ERROR:

              ORA-12560: TNS:protocol adapter error

               

              can u help me or any one have  Idea..

               

              No, you did not follow what I said.

              WHat I said was

               

              SQL>  conn sys/syspw@rmanp as sysdba

               

              And I went into great detail to explain why you needed the "@rmanp"


              Your latest example ignores that.