Oracle

Toad – SQLNET Editor & TNS Names Editor are Disabled

hello, After successfully Installed the toad, while trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Not able to connect the due to TNS Editor and SQLNET editors are disabled.

Solution : Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as  Oracle Home\NETWORK\ADMIN.

Capture

toad

 

Br. Erman

Advertisements
Standard
TOAD for Oracle

No valid Oracle clients found. You need at least one 32-bit client properly configured.

Problem :

4

Description:

This error occurs when we try to connect an Oracle database, through a Client like Toad for Oracle etc.. The error clearly says an 32-bit Oracle client need to be installed properly inorder to access the database.

Solution: Download and install Client from given link.
Link :  http://www.oracle.com/technetwork/topics/winsoft-085727.html

  • you should install the client version. Unzip the files to your Oracle installation folder. e.g: C:/oracle or C:/oraclehome. So the client installation is completed.

Path location : C:\Program Files\instantclient_12_2

1

  • Computer ->  Settings -> Advenced -> Covariable ->  Path -> Edit.

2

Connect to Toad,

3

Problem is solved.

 

Standard
TOAD for Oracle

TOAD Grand Error on Oracle Database

I recently received the following error while trying to connect to a database.

Error Message :

"Access to the following views required:
V$SESSION, V$PROCESS, V$SESS_IO, V$SESSION_WAIT, V$SESSION_EVENT, V$ACCESS, V$SESSSTAT, V$STATNAME, V$OPEN_CURSOR, V$SQL, V$LOCK, V$SESSION_LONGOPS, SYS.V_$TRANSACTION, SYS.V_$ROLLNAME, V$SQLTEXT_WITH_NEWLINES"

Solution :

  1. Open a Linux  terminal and enter the SQL*Plus command:
sqlplus /as sysdba 
SQL> Grant select any dictionary, select any table, select_catalog_role to db_user;

Grant succeeded.

SQL> grant execute on sys.dbms_workload_repository to db_user;

Grant succeeded.

That’s all.

Standard