Blogs on Oracle DBA / Temenos T24 - Deepak Kumar

  ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using I recently configured a Heterogenous connectivity from our Oracle dev database to a MSSQL dev database. I used a custom name for the gateway sid name. I have installed Oracle 19c gateways for Microsoft SQL Server in the Oracle DB server. I have followed the Oracle Gateways 19c documentation and cross verified with the Oracle support notes.  Every things at the configuration level seems to be fine but the test failed with above error. I enabled the dg4msql debug and got "NCR-1003 Read error", searching this error on Oracle support or on the internet yielded nothing. I have sieved through a lot of Oracle support notes but nothing helped. I have tried to redo everything from scratch and thus arrived at the solution for the issue. I used a SID name that was 10 char long. I have used a smaller name and the issue is solved. The error was very s...

User creation, Roles and privileges in 12c. User creation and role & privilege management changes slightly on Oracle 12c. Now we have two types of user and roles & privileges such as Local and Common. * Local User * Common User * Local roles and privileges * Common roles and privileges. Below are some points about this topic. A CDB can contain only common User. By default any user created in a CBD is a common user. Let’s create a Common User. <pre class ="brush: csharp" SQL> l 1* select username,user_id,account_status,profile,common,oracle_maintained from dba_users where oracle_maintained='N' SQL> / USERNAME    USER_ID ACCOUNT_STATUS    PROFILE COM O --------------- ---------- -------------------- ---------- --- - C##TESTUSER1    105 OPEN DEFAULT YES N C##CDB_USER    102 OPEN DEFAULT YES N C##TEST1    104 OPEN DEFAULT YES N SQL> </pre> - A common user is...