A total of two databases, I is the input password to connect directly with Navicat, testing library can connect, formal library anyway even,

Online that change listener. Ora not make, and I think this is a remote connection library, listener on the remote server to local these have do ah, is there a big some directions

CodePudding user response:

1, the monitor file listener. Ora posted to see
2, the client tnsping server IP
3, on the server LSNRCTL status view the listening state

CodePudding user response:

Hello, I have no legal power operation, and I think should be no problem, others can even
Remote library ip172.168.1.105 service name jbzx2 native listener. Ora before reform, useless I restore again, the connection with local related to this file? Because I have a connection before other remote repository, the machine does not require any configuration, only need to fill in the IP and the service name and account password, this has not, bosses can give answers to solve

CodePudding user response:

Has nothing to do with your native listener. Ora, take a look at your native tnsnames. Ora parsing name, whether there is a problem, such as the sid is wrong

CodePudding user response:

With Navicat connection, if we need to specify the oracle instance sid, if the database has two example how to distinguish between link which one?

CodePudding user response:

The native tnsnames. Ora I also changed, I think relationships are not with him, because in Navicat these configuration can be specified

CodePudding user response:

I'm thinking of you the problem of the machine, so even a plan to install Windows 7 virtual machine

CodePudding user response:

Service name is probably your tnsnames. Ora of that name, you try to use the sid

CodePudding user response:

I will service name to tnsnames. Ora also useless, the name of the above or even not on , and Navicat connection should not walk this file, IP were filled out,

CodePudding user response:

PLSQL I also tried, and even can't do it

CodePudding user response:

Try to use up sqlplus directly connected

Up sqlplus sip/* * * * * * @ 172.168.1.105/sid