Oracle 12c R2 Error Codes and Solution Suggestions from ORA-04930 to ORA-06145 ORA-04930: open sequence number failed or initial state is valid Cause: Either Shared Sequence Number OS component was not installed properly, or an MC hardware failure may have occurred or a previous instance was not shut down properly. Action: Verify that there are no background…
Day: August 23, 2016
Create Dblink From Oracle to PostgreSQL Database
Since fetching data from PostgreSQL database to Oracle database, you can create database link between two database systems. For that you can apply below operations. Test Systems PostgreSQL DB IP : 192.168.10.10 OS : Centos 7 x64 Service : postgresql.service Oracle DB IP : 192.168.10.20 OS : OEL 6 x64 PostgreSQL Side psql# create user…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-03700 to ORA-04000
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-03700 to ORA-04000 ORA-03700: More than one shardspace not allowed with system-managed sharding. Cause: An attempt to add a shardspace to the catalog was attempted when a shardspace already existed. Action: Only one shardspace is allowed per system-managed catalog. Use the existing shardspace or re-create the catalog with…