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
Author: Fatih Acar
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…
Configure Windows Firewall to Allow Pings
Configure Windows Firewall to Allow Pings Open Windows Firewall. Right click Inbound Rules and New Rule. Select Predefined and select File and Printer Sharing (Echo Request – ICMPv4-In). Next and Finish. Your system can respond ping requests.
Virtual IP Creation with Linux Service in CentOS 7
You can create virtual IP address with linux service. I designed the linux service to create a virtual IP address when operating system is rebooted. My System Properties Ethernet Adaptor Name : ens14025 Virtual IP : 192.168.44.55 1. Create Bash Script To Create Virtual IP Address [root@test ~]# vi /opt/scripts/virtual_ip_up.sh #!/bin/bash ifconfig ens14025:1 192.168.44.55 netmask…
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$…
Oracle 12c R2 (12.2.0.1) Real Time Apply Data Guard Installation on Oracle Linux 7.3
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…
TNS-12547: TNS:lost contact and Linux Error: 32: Broken pipe While Connect Oracle 12c Data Guard
I installed Oracle 12c Data Guard, everything was okey. But, I got an error like below when I wanted to connect data guard database with Toad or SQL Developer. tnsping was okey. Error SQL Developer : Status : Failure -Test failed: IO Error: Got minus one from a read call Listener.log 10-OCT-2017 15:01:16 * (CONNECT_DATA=(CID=(PROGRAM=SQL…
PostgreSQL Hot Standby (Streaming Replication) Database Installation and Failover Operations
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…