Featured post

Restircted session due to sync filed with ora-65177

Application is unable to connect the database due to restricted session. sql> show pdbs; SQL> show con_name CON_NAME -----------------...

  • user permissions script for each of the databases
      Use the following script for this purpose for each database.  REF :This script is also present in the link https://www.sqlservercentral.co...
  • listener service register
    alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = demo.localdomain)(PORT = 1531))'; alter system set local_listene...
  • user ddl
    set head off REM set long 150 set linesize 150 set longchunksize 150 set pages 0 set long 99999999 set feedback off set echo off ...