Logon to PL/SQL Version 7.1.4.1390

[Challenged]

We use PL/SQL on our production servers at work using oracle 9i. I have installed oracle 10i on my win XP PC locally and have created two independent homes for both installations.

Using plsql i can connect to the production dB's but cannot connect to the 10i database unless i connect using SQL+ to the 10i database. I have saved four images at the below url to show that the "switch" button does change the user/password combination, but it will not log me onto the local database

The error is as per the screenshot labled "030".

How can i "redirect" pl/sql to allow me to access the local 10i database as well as the production 9i database?

thx

 

[Marco Kalter]

The screenshots seem to be missing.

Is one of the homes configured to access all databases?

If so, go to Tools > Preferences > Oracle / Connection and select that home from the list.

If not, use the Oracle Net Configuration Assistant of one of the homes and define a local service name for each database.

 

[Challenged]

Sorry, try this URL
http:\\gareth.iamchallenged.com\

When i go to oracle / connection, the fields are blank, see screenshot 035, indicating Oracle home (empty is auto detect)

If i understand you correctly? - If i change the option to ora9_home or oradb10_home, my login screen will default to that home? And to establish a connection with a different home I would change this option and restart PL/SQL???

Or can i add my oracle 10i user to the personal preferences @ top where default = gvaughan to enable multiple logons?

Had a look at the Oracle Net Configuration Assistant, not sure what it means and how to configure it, sorry - could you perhaps exlain further?

thx

 

[Marco Kalter]

I would configure the local 10g home for PL/SQL Developer, and not switch to the 9i home.

Next, start the Oracle Net Configuration Assistant of the 10g home.

On the first page, select "Local Net Service Name configuration". This allows you to define a local name for each remote database you want to access from the 10g home.

On the next page, select "Add".

On the next page, enter the name of the remote database you want to access.

On the next page, select "TCP" as your protocol.

On the next page, enter the host name where the remote database resides. The port will probably be the default port. If not, contact your DBA for the port number.

On the next page perform the test.

Now this remote database is accessible from the 10g home in PL/SQL Developer and other Oracle tools.

Repeat these steps for each database you want to access.

 

[Challenged]

Thanks, i will give it a try