Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Add instance to oracle RAC database

-
I am having two nodes oracle RAC  , now I am adding 3rd instance to this database.
SQL> startup pfile='/archive/pfile-rman.ora' 
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes 
Fixed Size                  2114104 bytes 
Variable Size            1560284616 bytes 
Database Buffers         9160359936 bytes 
Redo Buffers               14659584 bytes 
ORA-01618: redo thread 3 is not enabled - cannot mount
SQL>
SQL> alter database add logfile thread 3 group 31 ('/archive/datafile/REDO301.LOG') size 1024M;
Database altered.
SQL> alter database add logfile thread 3 group 32 ('/archive/datafile/REDO302.LOG') size 1024M;
Database altered.
SQL>alter database add logfile thread 3 group 33 ('/archive/datafile/REDO303.LOG') size 1024M;
Database altered.
Enable the Thread now
SQL> alter database enable public thread 3;
Database altered.
SQL>
SQL> ALTER DATABASE mount;
Database altered.
SQL>
SQL> alter database open
; alter database open * ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> create undo tablespace UNDOTBS3 datafile '/archive/datafile/UNDOTBS3.dbf' size 2G autoextend on;
Tablespace created.
SQL>
Start the Instance again
SQL> startup pfile='/archive/pfile-rman.ora' 
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes 
Fixed Size                  2114104 bytes 
Variable Size            1560284616 bytes 
Database Buffers         9160359936 bytes 
Redo Buffers               14659584 bytes 
Database mounted. 
Database opened. 
SQL> select instance_name from gv$instance;
INSTANCE_NAME 
 orcl3 
orcl2 
orcl1

Comments

Post a Comment

Popular posts from this blog

7 Steps to configure BDR replication in postgresql

-
Image
 The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/postgresql/9.4/bin:"$PATH" ./c
Read more

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

-
Method 1 You can check the mode of the server using "pg_controldata". [pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/ Database cluster state: in archive recovery --> This is Standby Database Database cluster state: in production --> This is Production Database [Master] Method 2 You can use pg_is_in_recovery() which returns True if recovery is still in progress(so the server is running in standby mode or slave) postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) If Return    false   so the server is running in primary mode or master postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row)
Read more

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

-
In this post, I am sharing few important function for finding the size of database, table and index in PostgreSQL. Finding object size in postgresql database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in GB. The scripts have been formatted to work very easily with PUTTY SQL Editor. 1. Checking table size excluding table dependency: SELECT pg_size_pretty(pg_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 238 MB (1 row) 2. Checking table size including table dependency: SELECT pg_size_pretty(pg_total_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 268 MB (1 row) 3. Finding individual postgresql database size SELECT pg_size_pretty(pg_database_size('db_name')); 4. Finding individual table size for postgresql database -including dependency index: SELECT pg_size_pretty(pg_total_rel
Read more

ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info ->>'PRODUCTS' ->>'produc... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

-
postgres=# select * from sales; id | sales_info ----+---------------------------------------------------------------------------------- 1 | { "customer": "NIJAM", "PRODUCTS": {"product_name": "choclate","total_item": 6}} 2 | { "customer": "ABU", "PRODUCTS": {"product_name": "badam","total_item": 5}} 3 | { "customer": "UMAR", "PRODUCTS": {"product_name": "mobile","total_item": 1}} (3 rows) postgres=# SELECT sales_info ->>'customer' as customer_name,sales_info ->>'PRODUCTS' ->>'product_name' as name_of_product from sales where sales_info ->>'customer'='UMAR'; ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info -&
Read more

PostgreSQL 11 Source code Installation

-
I n this tutorial, we will show you how to   install PostgreSQL  by using source code   on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other platforms such as Mac OS X, Solaris, and Windows. Since version 8.0, PostgreSQL offers an installer for Windows systems that makes the installation process easier and faster. For development purpose, we will install PostgreSQL version 11.3  on Linux There are three steps to complete the PostgreSQL installation: Download the PostgreSQL source file . Configure the PostgreSQL  source code . Verify the postgres configuration . 1. First install required prerequisites such as gcc, readline-devel and zlib-devel using package manager as shown. # yum install gcc zlib-devel readline-devel [On RHEL/CentOS] # apt install gcc zlib1g-dev libreadline6-dev [On Debian/Ubuntu] # Zypper in gcc zlib1g-dev l
Read more