Tuesday, July 15, 2014

ORA-00844: Parameter not taking MEMORY_TARGET into account ORA-00851: SGA_MAX_SIZE ****** cannot be set to more than MEMORY_TARGET ********. ORA-01078: failure in processing system parameters

SQL> startup ;
ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 2449473536 cannot be set to more than MEMORY_TARGET 855638016.
ORA-01078: failure in processing system parameters;



[oracle@rac1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 17:51:47 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn sys/admin@orcl as sysdba
Connected to an idle instance.

 SQL> create pfile='/u01/app/oracle/product/pfile.ora' from SPFILE='+DATA/orcl/spfileorcl.ora';

File created.

Note: switch to grid user and connect ASM instance (asmcmd) find the spfile location.

Go to pfile location and remove below lines;

*.sga_max_size=123456789
*.sga_target=0

save the file.

[oracle@rac1 product]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 18:26:55 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile='/u01/app/oracle/product/pfile.ora';
ORACLE instance started.

Total System Global Area  849530880 bytes
Fixed Size                  1348244 bytes
Variable Size             616566124 bytes
Database Buffers          226492416 bytes
Redo Buffers                5124096 bytes
Database mounted.
Database opened.

SQL> create spfile from pfile='/u01/app/oracle/product/pfile.ora';

File created.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


[oracle@rac1 product]$ srvctl start database -d ORCL
[oracle@rac1 product]$ srvctl status database -d ORCL
Instance orcl1 is running on node rac1
Instance orcl2 is running on node rac2
[oracle@rac1 product]$
[oracle@rac1 product]$


Thank you...

How to configure Oracle Enterprise Manager on two node cluster

[oracle@rac2 cfgtoollogs]$  emca -reconfig dbcontrol -cluster -EM_NODE rac2 -EM_NODE_LIST rac2

STARTED EMCA at Jul 15, 2014 3:04:51 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: orcl
Service name: orcl
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 15, 2014 3:04:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/em                                                                                        ca_2014_07_15_15_04_51.log.
Jul 15, 2014 3:05:03 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jul 15, 2014 3:05:05 PM oracle.sysman.emcp.EMAgentConfig performDbcReconfigurati                                                                                        on
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/rac2_orcl/sysman/confi                                                                                        g/emd.properties to remote nodes ...
Jul 15, 2014 3:05:05 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 15, 2014 3:06:21 PM oracle.sysman.emcp.EMDBPostConfig performDbcReconfigurat                                                                                        ion
INFO: Database Control started successfully
Jul 15, 2014 3:06:21 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMes                                                                                        sage
INFO:
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

orcl              rac1              rac1.localdomain
orcl              rac2              rac2.localdomain


Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 15, 2014 3:06:21 PM
[oracle@rac2 cfgtoollogs]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/rac2_orc                                                                                        l/sysman/log
[oracle@rac2 cfgtoollogs]$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.4
OMS Version       : 10.2.0.4.4
Protocol Version  : 10.2.0.4.4
Agent Home        : /u01/app/oracle/product/11.2.0/dbhome_1/rac2_orcl
Agent binaries    : /u01/app/oracle/product/11.2.0/dbhome_1
Agent Process ID  : 9325
Parent Process ID : 9303
Agent URL         : https://rac2.localdomain:3938/emd/main
Repository URL    : https://rac2.localdomain:1158/em/upload/
Started at        : 2014-07-15 15:05:07
Started by user   : oracle
Last Reload       : 2014-07-15 15:05:07
Last successful upload                       : 2014-07-15 15:10:36
Total Megabytes of XML files uploaded so far :    48.62
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    39.61%
Data channel upload directory                : /u01/app/oracle/product/11.2.0/db                                                                                        home_1/rac2_orcl/sysman/recv
Last successful heartbeat to OMS             : 2014-07-15 15:10:21
---------------------------------------------------------------
Agent is Running and Ready

Check the first node :

Node 1:

[oracle@rac1 emca]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac1.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/rac1_orcl/sysman/log

Node 2: 

[oracle@rac2 cfgtoollogs]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/rac2_orcl/sysman/log
[oracle@rac2 cfgtoollogs]$


This is indicates two Grid controls for two individual node with 2 instance.


Thank you...

Saturday, July 12, 2014

Metadata file does not match checksum Trying other mirror.

Error message

http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/repodata/filelists.xml.gz: [Errno -1] Metadata file does not match checksum
Trying other mirror.
public_ol6_latest/primary                                |  39 MB     01:48
http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/repodata/primary.xml.gz: [Errno -1] Metadata file does not match checksum
Trying other mirror.
Error: failure: repodata/primary.xml.gz from public_ol6_latest: [Errno 256] No more mirrors to try.


Solution :

I have seen the "Metadata file does not match checksum" error once too and was able to resolve it by:
1) Setting http_caching=none in /etc/yum.conf file
2) yum clean metadata
3) yum update

It will work fine......

Thank you.......


Saturday, June 21, 2014

Database Recovery with RMAN backup (Disaster Recovery)

Database Recovery with RMAN backup (Disaster Recovery)
This are the steps for Database recovery when entire complete database crashed even though don’t have spfile and control file backup. I have one copy of Full RMAN backup. Using this backup I am going to be performing the recovery scenario.
Here in this case required to rebuild entire database server
Environment is  OEL 6.5 Oracle 11g with ASM standalone server.
RMAN Backup:
1)      Controlfile and SPFILE autobackup
2)      RMAN Full Backup files
3)      RMAN Archivelog files
Steps:
1)      Create new file system same as old server.
2)      Install same version of Oracle Software in the production server.(In this case 11.2.0.3 Enterprise Edition).
3)      Create the Instance.
4)      Create the relevant folder hierarchy under <ORACLE_BASE> directory.
5)      Restore the SPFILE from autobackup, and use the SPFILE to start the instance in NOMOUNT state.
6)      Restore the controlfile from autobackup, and MOUNT the database .
7)      Restore the Database from RMAN backup files .
8)      Recover the Database from RMAN backup files, and OPEN the database with RESETLOGS.



Database Disaster Recovery using only RMAN Backups
Note: After installation of same version of Oracle software below are the steps to be followed.

[oracle@linux dbs]$ set ORACLE_SID=ORCL
[oracle@linux dbs]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 20 19:04:55 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> set DBID=1372442605

executing command: SET DBID

RMAN> startup force nomount;

startup failed: ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora_2'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora_2
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora_2
ORA-15173: entry 'spfileorcl.ora_2' does not exist in directory 'orcl'
ORA-06512: at line 4

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area     158662656 bytes

Fixed Size                          2226456 bytes
Variable Size                104859368 bytes
Database Buffers          46137344 bytes
Redo Buffers                    5439488 bytes


RMAN>





















[oracle@linux dbs]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 20 19:11:56 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DUMMY (not mounted)

RMAN> set DBID=1372442605

executing command: SET DBID

RMAN> restore spfile to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initasm.ora' from "+DATA/ORCL/AUTOBACKUP/2014_06_20/s_850757433.294.850757669";

Starting restore at 20-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=172 device type=DISK

channel ORA_DISK_1: restoring spfile from AUTOBACKUP +DATA/ORCL/AUTOBACKUP/2014_06_20/s_850757433.294.850757669
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 20-JUN-14

RMAN> shutdown immediate;

Oracle instance shut down

RMAN>



(Or )

2nd Method :

I am using my pfile for temporarily to start the Instance  Based on my test server. Below is my pfile script

orcl.__db_cache_size=3305111552
orcl.__java_pool_size=50331648
orcl.__large_pool_size=16777216
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=22598909952
orcl.__sga_target=4294967296
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=855638016
orcl.__streams_pool_size=33554432
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+DATA/orcl/controlfile/current.261.845224563','+DATA/orcl/controlfile/current.260.845224563'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.open_cursors=300
*.pga_aggregate_target=22595764224
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4293918720
*.undo_tablespace='UNDOTBS1'

RMAN> startup force pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initasm.ora' nomount;

Oracle instance started

Total System Global Area    4275781632 bytes

Fixed Size                     2235208 bytes
Variable Size                956302520 bytes
Database Buffers            3305111552 bytes
Redo Buffers                  12132352 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 20-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=135 device type=DISK

recovery area destination: +DATA
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP +data/ORCL/AUTOBACKUP/2014_06_20/s_850757433.294.850757669 found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140620
channel ORA_DISK_1: restoring control file from AUTOBACKUP +data/ORCL/AUTOBACKUP/2014_06_20/s_850757433.294.850757669
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=+DATA/orcl/controlfile/current.272.850764747
output file name=+DATA/orcl/controlfile/current.275.850764749
Finished restore at 20-JUN-14

RMAN>




















RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 20-JUN-14
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/orcl/datafile/system.270.850764909
channel ORA_DISK_1: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.273.850764909
channel ORA_DISK_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.261.850764909
channel ORA_DISK_1: restoring datafile 00004 to +DATA/orcl/datafile/users.277.850764911
channel ORA_DISK_1: restoring datafile 00005 to +DATA/orcl/datafile/example.281.850764909
channel ORA_DISK_1: reading from backup piece +DATA/orcl/backupset/2014_06_20/nnndf0_tag20140620t173119_0.295.850757481
channel ORA_DISK_1: piece handle=+DATA/orcl/backupset/2014_06_20/nnndf0_tag20140620t173119_0.295.850757481 tag=TAG20140620T173119
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:25
Finished restore at 20-JUN-14

RMAN> recover database;

Starting recover at 20-JUN-14
using channel ORA_DISK_1

starting media recovery

RMAN-08187: WARNING: media recovery until SCN 2293142 complete
Finished recover at 20-JUN-14

RMAN> alter database open resetlogs;

database opened

RMAN>























Exit RMAN prompt and check Database recovered properly or not.

Thank you for visiting my blog


Wednesday, May 7, 2014

Steps for media recovery:

Steps for media recovery:


Restore and recover the whole database

 RMAN> STARTUP FORCE MOUNT;
 RMAN> RESTORE DATABASE;
 RMAN> RECOVER DATABASE;
 RMAN> ALTER DATABASE OPEN;
 
Restore and recover a tablespace

 RMAN> SQL 'ALTER TABLESPACE AXPERT OFFLINE';
 RMAN> RESTORE TABLESPACE AXPERT;
 RMAN> RECOVER TABLESPACE AXPERT;
 RMAN> SQL 'ALTER TABLESPACE AXPERT ONLINE';

Restore and recover a datafile

 RMAN> SQL 'ALTER DATABASE DATAFILE 8 OFFLINE';
 RMAN> RESTORE DATAFILE 8;
 RMAN> RECOVER DATAFILE 8;
 RMAN> SQL 'ALTER DATABASE DATAFILE 8 ONLINE';



Steps to be Performed for tablespace recovery:


1. Mount the database
2. Make the data file offline
3. Restore the data file
4. Recover the data file
5. Make the data file online
6. Open the database

Thanks...

Tuesday, April 29, 2014

ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLER WITH MATCHING PROTOCOL STACK

Dear Friends,

Below are steps for ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLER WITH MATCHING PROTOCOL STACK error

ERROR : ORA-12516: TNS:listener could not find available handler with matching protocol stack

CAUSE :
 Its Reached maximum process.

SOLUTION : 

Check maximum value for processes and sessions

select name, value from v$parameter where name in (‘processes’,’sessions’);

Check current process and session and maximum limitation

select * from v$resource_limit;

Increase your process and session, for example to 800

alter system set processes=800 scope=spfile;
alter system set sessions=885 scope=spfile;

Restart the Database with below commands,

shutdown immediate;

and 

startup;

or 

startup force ;

all changes will effected permanently.



Thursday, April 24, 2014

How do I enable SQL *Plus Up and down arrow keys on Linux ?

How do I enable SQL *Plus Up and down arrow keys on Linux ? 


Below are the steps are involved under root user.

1) Download gqlplus-1.15.tar.gz from below link.

http://gqlplus.sourceforge.net/

[root@production ~]# tar -xvf gqlplus-1.15.tar.gz ---  It will create gqlplus-1.15 folder
'
'
'
'
gqlplus-1.15/readline/support/mkdirs
gqlplus-1.15/readline/rltty.h
gqlplus-1.15/readline/tilde.c
gqlplus-1.15/readline/display.c
gqlplus-1.15/readline/rlshell.h
gqlplus-1.15/readline/nls.c
gqlplus-1.15/readline/rlmbutil.h
gqlplus-1.15/readline/aclocal.m4
gqlplus-1.15/readline/compat.c
gqlplus-1.15/readline/complete.c
gqlplus-1.15/readline/USAGE
gqlplus-1.15/readline/rlwinsize.h
gqlplus-1.15/readline/keymaps.c
gqlplus-1.15/readline/vi_keymap.c
gqlplus-1.15/readline/MANIFEST
gqlplus-1.15/readline/rlconf.h
gqlplus-1.15/readline/chardefs.h
gqlplus-1.15/readline/xmalloc.h
gqlplus-1.15/readline/search.c
gqlplus-1.15/readline/posixjmp.h
gqlplus-1.15/readline/input.c
gqlplus-1.15/readline/Makefile.in
gqlplus-1.15/readline/shell.c
gqlplus-1.15/readline/configure.in
gqlplus-1.15/readline/readline.c
gqlplus-1.15/readline/funmap.c
gqlplus-1.15/readline/histsearch.c
gqlplus-1.15/readline/rlprivate.h
gqlplus-1.15/readline/util.c
gqlplus-1.15/readline/README
gqlplus-1.15/readline/terminal.c
gqlplus-1.15/readline/history.c
gqlplus-1.15/readline/configure
gqlplus-1.15/readline/rlstdc.h
gqlplus-1.15/readline/CHANGELOG
gqlplus-1.15/readline/callback.c
gqlplus-1.15/readline/tilde.h
gqlplus-1.15/readline/rldefs.h
gqlplus-1.15/readline/rltty.c
gqlplus-1.15/readline/doc/
gqlplus-1.15/readline/doc/history.0
gqlplus-1.15/readline/doc/readline.html
gqlplus-1.15/readline/doc/rluserman.texinfo
gqlplus-1.15/readline/doc/rluserman.html
gqlplus-1.15/readline/doc/history.dvi
gqlplus-1.15/readline/doc/readline.ps
gqlplus-1.15/readline/doc/readline.dvi
gqlplus-1.15/readline/doc/hsuser.texinfo
gqlplus-1.15/readline/doc/texi2html
gqlplus-1.15/readline/doc/rluserman.info
gqlplus-1.15/readline/doc/rltech.texinfo
gqlplus-1.15/readline/doc/history_3.ps
gqlplus-1.15/readline/doc/readline_3.ps
gqlplus-1.15/readline/doc/rluserman.ps
gqlplus-1.15/readline/doc/manvers.texinfo
gqlplus-1.15/readline/doc/texi2dvi
gqlplus-1.15/readline/doc/history.html
gqlplus-1.15/readline/doc/Makefile.in
gqlplus-1.15/readline/doc/rluser.texinfo
gqlplus-1.15/readline/doc/readline.3
gqlplus-1.15/readline/doc/history.3
gqlplus-1.15/readline/doc/readline.0
gqlplus-1.15/readline/doc/readline.info
gqlplus-1.15/readline/doc/texinfo.tex
gqlplus-1.15/readline/doc/rlman.texinfo
gqlplus-1.15/readline/doc/history.info
gqlplus-1.15/readline/doc/hist.texinfo
gqlplus-1.15/readline/doc/history.ps
gqlplus-1.15/readline/doc/hstech.texinfo
gqlplus-1.15/readline/doc/rluserman.dvi
gqlplus-1.15/readline/histfile.c
gqlplus-1.15/readline/misc.c
gqlplus-1.15/readline/examples/
gqlplus-1.15/readline/examples/manexamp.c
gqlplus-1.15/readline/examples/rlcat.c
gqlplus-1.15/readline/examples/excallback.c
gqlplus-1.15/readline/examples/readlinebuf.h
gqlplus-1.15/readline/examples/rlversion.c
gqlplus-1.15/readline/examples/Makefile.in
gqlplus-1.15/readline/examples/rlfe.c
gqlplus-1.15/readline/examples/fileman.c
gqlplus-1.15/readline/examples/rl.c
gqlplus-1.15/readline/examples/Inputrc
gqlplus-1.15/readline/examples/histexamp.c
gqlplus-1.15/readline/examples/rltest.c
gqlplus-1.15/readline/parens.c
gqlplus-1.15/readline/COPYING
gqlplus-1.15/readline/savestring.c
gqlplus-1.15/readline/rltypedefs.h
gqlplus-1.15/readline/config.h.in
gqlplus-1.15/readline/kill.c
gqlplus-1.15/readline/shlib/
gqlplus-1.15/readline/shlib/Makefile.in
gqlplus-1.15/readline/ansi_stdlib.h
gqlplus-1.15/readline/isearch.c
gqlplus-1.15/readline/mbutil.c
gqlplus-1.15/readline/histexpand.c
gqlplus-1.15/readline/tcap.h
gqlplus-1.15/readline/xmalloc.c
gqlplus-1.15/readline/text.c
gqlplus-1.15/readline/bind.c
gqlplus-1.15/readline/vi_mode.c
gqlplus-1.15/Makefile.am
gqlplus-1.15/missing
gqlplus-1.15/ChangeLog


[root@production ~]# cd gqlplus-1.15

[root@production gqlplus-1.15]# ls

ChangeLog     depcomp     LICENSE      missing        README
configure     gqlplus.c   Makefile.am  mkinstalldirs
configure.ac  install-sh  Makefile.in  readline

[root@production gqlplus-1.15]# ./configure

checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for ranlib... ranlib
checking for tgetnum in -lncurses... yes
checking for tputs in -lreadline... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: executing depfiles commands

[root@production gqlplus-1.15]# make

CDPATH="${ZSH_VERSION+.}:" && cd . && /bin/sh /u02/DATAPUMP/gqlplus-1.15/missing                                                                                         --run aclocal-1.11
 cd . && /bin/sh /u02/DATAPUMP/gqlplus-1.15/missing --run automake-1.11 --foreig                                                                                        n
CDPATH="${ZSH_VERSION+.}:" && cd . && /bin/sh /u02/DATAPUMP/gqlplus-1.15/missing                                                                                         --run autoconf
/bin/sh ./config.status --recheck
running CONFIG_SHELL=/bin/sh /bin/sh ./configure --no-create --no-recursion
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for a BSD-compatible install... /usr/bin/install -c
checking for ranlib... ranlib
checking for tgetnum in -lncurses... yes
checking for tputs in -lreadline... yes
configure: creating ./config.status
 /bin/sh ./config.status
config.status: creating Makefile
config.status: executing depfiles commands
gcc -DPACKAGE_NAME=\"gqlplus\" -DPACKAGE_TARNAME=\"gqlplus\" -DPACKAGE_VERSION=\                                                                                        "1.14\" -DPACKAGE_STRING=\"gqlplus\ 1.14\" -DPACKAGE_BUGREPORT=\"\" -DPACKAGE=\"                                                                                        gqlplus\" -DVERSION=\"1.14\" -DHAVE_LIBNCURSES=1 -DHAVE_LIBREADLINE=1 -I. -I.                                                                                            -g -O2 -MT gqlplus.o -MD -MP -MF .deps/gqlplus.Tpo -c -o gqlplus.o gqlplus.c
gqlplus.c:413:1: warning: "VERSION" redefined
<command-line>: warning: this is the location of the previous definition
gqlplus.c: In function âget_sql_promptâ:
gqlplus.c:2479: warning: assignment from incompatible pointer type
mv -f .deps/gqlplus.Tpo .deps/gqlplus.Po
gcc  -g -O2   -o gqlplus gqlplus.o  -lreadline -lncurses

[root@production gqlplus-1.15]# make install

make[1]: Entering directory `/u02/DATAPUMP/gqlplus-1.15'
test -z "/usr/local/bin" || /bin/mkdir -p "/usr/local/bin"
  /usr/bin/install -c gqlplus '/usr/local/bin'
make[1]: Nothing to be done for `install-data-am'.
make[1]: Leaving directory `/u02/DATAPUMP/gqlplus-1.15'

[root@production gqlplus-1.15]# su - oracle

[oracle@production ~]$ gqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 24 23:04:43 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options


Thank you.......