Where is sqlplus

The tnsnames. The Oracle driver allows you to retrieve basic connection information from a tnsnames. Start Oracle Universal Installer. Click Installed Products to display the Inventory dialog box on the Welcome screen.

Select an Oracle Database product from the list to check the installed contents. Will give you the path where Oracle installed and path will include version number. Is it a bug or a feature? If it does, go to environment variables and change this. Please make a copy of the path before and after the change, so that in case of issues you can revert the changes.

Make sure then entry for your new db is in both tnsnames. Then, you can use either home as a client for either DB. If you do not need two Oracle homes, delete one and make changes in environment variables and make sure that the clean up is done properly. To simplify the multiple copies of tnsnames. Set the environment variable to a directory path that will contain your tnsnames. Copy both files into this directory. The first thing Oracle and Toad do is look for this environment variable, if it exists, it will use the files if they exist in the directory pointed to by the environment variable.

Only previous database entries are present. I shall try as you have told to do and check if both databases connect each other. Thanks, I looked into the path which you told, I found path for database which existed before…and not which I created.. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? If you do not know your Oracle Database username and password, ask your Database Administrator.

Enter your Oracle Database username and password in the Log On dialog. Leave the Host String field blank to connect to the default database. Enter a connection identifier for the database you want to connect to in the Host String field.

You can connect to Oracle8 i , Oracle9 i and Oracle Database 10 g databases. Press Enter to go to the URL. Enter your Oracle Database username and password in the Username and Password fields. Enter an Oracle Database connection identifier in the Connection Identifier field to connect to a database other than the default.

If restricted database access has been configured, the Connection Identifier field is a dropdown list of available databases to select.