TOAD for Oracle

ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM

ORA-01653:
unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM.

Solution

Login as oracle or any SQL privilege user.

  1. Connect:
    Sqlplus / as sysdba
  2. truncate table :
    truncate table  SYS.AUD$;
  3. New DB connections should be possible.
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