Posts

ORA-28511: lost RPC connection to heterogeneous remote agent - silly mistake that can frustrate you.

  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, Role and Privilege management in Oracle 12c

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...

Beginning performance tuning by Arup Nandha

Image
A nice video by Arup Nandha on Performance tuning. I found it very informative, sharing the link here. I hope it will benefit you too.

Oracle database download

Download Oracle database software. You can download Oracle database software from the link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ·          You will need an OTN account to download this software. (It’s a free signup) ·          You can create an account with the link https://login.oracle.com/mysso/signon.jsp ·          You can use this software free for personal educational purpose. ·          You can only download current release (which is 12c) and the previous release (which is 11g) ·          If you require older version you will need Oracle Support account (which is paid account). Note : You can download various other software from Oracle free for educational purpose.

Dynamic registration in Oracle

·       *    In a server if there is a listener running, then an Oracle database can dynamically register it in the listener to provide its service. ·        *  This dynamic registration is automatic if the listener is running in the Oracle default listening port 1521 ·        *   Incase if you want to allow dynamic database registration only to certain databases in the server. You need to run the listener in non-default port. (For example: 1522 or 1530 etc) ·        *   To allow dynamic registration of database services in the listener with non-default port we need to modify few parameters in database level. No changes needed in listener.ora file. Below are the parameters o    In case if the listener and database are in same server change the parameter LOCAL_LISTENER For example: Alter system set local_listener=”orclnew” scope=both; Where listener2 should be r...

Switching to Archivelog mode – Oracle 11g

Archivelog mode is a must for a production database as it ensures high recoverability of the database and provides greater flexibility to backup. Its very simple to turn on archiveing of Redo logs in your database. First step is check the log mode of the database. There are two ways to check this. First way is to query the column LOG_MODE from v$database. sys@ORCL> select log_mode from v$database; LOG_MODE ------------ NOARCHIVELOG sys@ORCL> sys@ORCL> Second way is to use the command ARCHIVE LOG LIST sys@ORCL> archive log list Database log mode              No Archive Mode Automatic archival             Disabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     51 Current log sequence        ...

ORA-01092 & ORA-30040

Image
      ORA-01092 & ORA-30040 ·          Mount the database. ·          Create a pfile from spfile to a desired location. For example CREATE PFILE = ‘f:\temp\test\initorcl.ora’ from spfile; ·          Edit the pfile and give an online tablespace *.undo_tablespace='UNDOTBS3' already existing. ·          Start the database with this new Pfile, for example STARTUP PFILE=’F:\TEMP\TEST\initorcl.ora’ ·          Create spfile from the new pfile settings loaded using the command “CREATE SPFILE FROM PFILE;” ·          Bounce the database.