SQL plus and pl/SQL cannot connect to the remote oracle database, ploracle

SQL plus and pl/SQL cannot connect to the remote oracle database, ploracle

After the oracle client is installed, SQL plus and pl/SQL may fail to connect to the remote oracle database, which may be due to the following reasons:

Unable to connect to SQL plus:

1 possible cause: the oracle database client has been installed before and has not been uninstalled. SQL plus uses the previous oracle client configuration, causing connection failure.

Solution: In system variables, delete information about the oracle client, such as path information.

 

When SQL plus can be connected, pl/SQL cannot be connected.

1 possible cause: the oracle database client has been installed before and has not been uninstalled. pl/SQL uses the previous oracle client configuration, causing connection failure.

Solution: 1. When logging on, click cancel (cancel) to automatically enter the interface. Follow the tools> preferences operation to go to the configuration page. Find Oracle> Connection, find oracle home on the right of the configuration page, and specify oracle home as the newly installed client.

2 possible cause: pl/SQL is installed in a strange path, such as "Program Files (x86 )"

Solution: uninstall, reinstall, and install it in a normal path.