toad unable to see 11gr2 database on database browser

Toad for Oracle & DevOps Toolkit
1

I am not able to pull up a 11gr2 database on the database browser on TOAD.
Is there any setting that I need to get it to work?

Thaanks.

2

Select e.inst_id, e.event,

e.time_waited / 100 time_waited, e.total_waits

From gv$system_event e

Where event Not In

(‘Null event’, ‘client message’, ‘smon timer’,

‘rdbms ipc message’, ‘pmon timer’, ‘WMON goes to sleep’,

‘virtual circuit status’, ‘dispatcher timer’, ‘SQL*Net message from client’,

‘parallel query dequeue wait’, ‘latch free’, ‘enqueue’,

‘write complete waits’, ‘free buffer waits’, ‘buffer busy waits’,

‘pipe gets’, ‘Null event’, ‘client message’,

‘smon timer’, ‘rdbms ipc message’, ‘pmon timer’,

‘WMON goes to sleep’, ‘virtual circuit status’, ‘dispatcher timer’,

‘SQL*Net message from client’, ‘parallel query dequeue wait’, ‘latch free’,

‘enqueue’, ‘write complete waits’, ‘free buffer waits’,

‘buffer busy waits’, ‘pipe gets’, ‘slave wait’,

‘PL/SQL lock timer’, ‘null event’, ‘Null event’,

‘rdbms ipc reply’, ‘Parallel Query Idle Wait - Slaves’, ‘KXFX: Execution Message Dequeue - Slave’,

‘slave wait’)

order by 1, 3 desc

  1. What do you see under Help>Toad Advisor? Anything listed there concerning unsupported Oracle versions?

  2. Are you using DBA views?

  3. While connected, can you successfully run this query?

3

Also, it occurred to me that you may not actually be connected to the 11gr2 that
you’re trying to browse. If not, are you sure the service appears in your
TNS?
image001.jpeg

4

Also, it occurred to me that you may not actually be connected to the 11gr2 that
you’re trying to browse. If not, are you sure the service appears in your
TNS?
image001.jpeg

5
  1. What do you see under Help>Toad Advisor? Anything listed there concerning unsupported Oracle versions?

I see untested oracle server version, relating to the 11gr2 database

  1. Are you using DBA views?

is this on toad?

  1. While connected, can you successfully run this query?

yes, comes back with lots of rows

Also, it occurred to me that you may not actually be connected to the 11gr2 that
you’re trying to browse. If not, are you sure the service appears in your TNS?

its using the tnsnames.ora file to connect to the 11gr2 database

6

Do you mean that the database browser does not show this database?

If so, you may need to add it. The easiest way, if you have not changed the
listing in the database, browser, is to click the first toolbar button, then
choose “New database browser file (reload from tnsnames)”

The other way to add it would be to click “New server”, then add the
server information. Then select the new server and click the “New
database” button, and select or make the connection to that database.

7

How to work with Toad with Oracle 11gR2 win-64 bit home premium edition…

  1. Install 11gR2 64-bit
  2. Install 11gR2 32-bit client
  3. Toad will show 11gR2 client under Installed Clients>Connect using: … like OraClient11g_home1
  4. If your DB anme is like orcl…then go to TNS option and enter Database as (localhost:1521/orcl) or (127.0.0.1:1521/orcl)

DB Instance will be getted connected with client Toad.

– regards,
Dhruv

8

You can save a step – skip step 1 J

9

Actually if you are trying to install Oracle locally and use toad to access it
then you cannot skip step 1. If the database is on another server then you can
skip step 1.

Assuming you are trying to create a local database and access it using toad then
you have two options:

10

Good call Bert! I misread the objective.