If you take “Maximum of 148 enabled roles exceeded for user SYS. Not loading all the roles” error, ıt means of your SYS user’s roles are exceed 148. Solution You can connect with sys user and revoke unnessesary roles. This will resolve your problem.
Category: Databases
How to Use pg_rewind in PostgreSQL 12
pg_rewind is a PostgreSQL tool since 9.5 version. It provides synchronization between standby and old primary. Especially, pg_rewind provides advantage for big databases. You can sync databases without using pg_basebackup. pg_rewind scans the old primary database’s pgdata folder and identifies data blocks changed during the switch to standby database, then copies only changed blocks from…
PostgreSQL 12 Streaming Replication Installation and Failover Operations on CentOS 7
PostgreSQL has few feature for standby technology. I generally use streaming replication. This is very easy and confident. Streaming replication use a replication user for replication operations.Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping. The standby connects to the primary, which streams WAL records to the…
Oracle 19c R3 Active Data Guard Installation on Oracle Linux 7.7
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Oracle 19c R3 Real Application Clusters (RAC) Installation Steps on Oracle Linux 7.7
Oracle Real Application Clusters (RAC) provides high availability (HA) and scalability to the Oracle Database without requiring any application changes. Oracle RAC allows multiple instances running on different servers to access the same physical database stored on shared storage. Database spans multiple hardware systems and yet appears as a single unified database to the application….
ORA-01078 failure in processing system parameters LRM-00108 could not open parameter file Oracle RAC
Problem ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘//dbs/init.ora’ Solution cd $GRID_HOME/bin chmod 6751 oracle
Turkish Characters Order By Sort Problem in Oracle
Using order by in column that contains special Turkish characters like ç,ğ,ö,ş,ü can be problem. All special Turkish characters can be listed at the end of the list. You can resolve this problem with NLSSORT. select * from tablename order by NLSSORT(columnname,’NLS_SORT=TURKISH’)
Reset MySQL Root User Password in Centos 7
Stop MySQL Database systemctl stop mysqld.service Start MySQL as Safe Mode mysqld_safe –skip-grant-tables & Connect MySQL Database With Root User mysql -uroot Change Root Password use mysql; update user set password=PASSWORD(“newpassword”) where user=’root’; flush privileges; exit Restart MySQL Database systemctl stop mysqld.service systemctl start mysqld.service Connect MySQL Database With Root User With New Password mysql…
How to Using Dblink With DML Operations in PostgreSQL 9
Dblinks provide to connect another databases. Also you can do DML operations with using dblink. I will use dblink to connect two PostgreSQL databases on this post. Also I will tell how to use select, update and delete with dblink. Firstly, you have to create dblink entension with related user which is using dblink. Create…
Unified Auditing in Oracle 12c
Unified Auditing is new audit feature came with Oracle 12c version. You have to do enable Unified Auditing to use after install database. Unified Auditing come as disabled by default. In previous releases of Oracle Database, there were separate audit trails for individual components: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$…