Friday, August 4, 2017

ORA-00371: not enough shared pool memory, should be atleast 1034490288 bytes

I am trying to setup dataguard for one of our database and while starting the DG instance in nomount mode I am getting an ORA-00371 error

SQL> startup nomount pfile='inittst_aux.ora';
ORA-00371: not enough shared pool memory, should be atleast 1034490288 bytes
SQL>
SQL> !cat inittst_aux.ora
db_name=dev1tstp
SQL> 

This is a bug in Oracle 11.2 and as a workaround what I have done is added a parameter sga_target to ensure that instance has enough memory to start with

[oracle@comp01 (dev1tstd1) dbs]$ cat inittst_aux.ora
db_name=dev1tstp
sga_target=2560M
[oracle@comp01 (dev1tstd1) dbs]$ 

After setting up the parameter the instance started alright.

[oracle@comp01 (dev1tstd1) dbs]$ sqlplus "/ as sysdba"
 set pages 10000 lines 270 long 10000
SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 3 09:48:14 2017
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> SQL>
SQL>
SQL> startup nomount pfile='inittst_aux.ora';
ORACLE instance started.
Total System Global Area 2672361472 bytes
Fixed Size                  2231352 bytes
Variable Size             654312392 bytes
Database Buffers         1979711488 bytes
Redo Buffers               36106240 bytes
SQL> 


Tuesday, August 1, 2017

How to install xclock on raspberry pi

Sometimes we need x session to raspberry pi and for that we need to have X apps installed on raspberry pi.

I am getting the error that xclock is not installed

pi1@rasp:~/temp$ xclock
-bash: xclock: command not found
pi1@rasp:~/temp$

So I tried installing the xclock and received the message that I should install x11-apps

pi1@rasp:~/temp$ sudo apt-get install xclock
Reading package lists... Done
Building dependency tree      
Reading state information... Done
Package xclock is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  x11-apps
E: Package 'xclock' has no installation candidate
pi1@rasp:~/temp$ 


Well that is the solution, so I went on installing x11-aps


pi1@rasp:~/temp$ sudo apt-get install x11-apps
Reading package lists... Done
Building dependency tree    
.
.
.
Processing triggers for libc-bin (2.19-18+deb8u10) ...
Processing triggers for systemd (215-17+deb8u7) ...
pi1@rasp:~/temp$ 


After the installation I just made sure that my DISPLAY variable is set to correct value and xauth is set as well.

pi1@rasp:~/temp$ echo $DISPLAY
localhost:10.0
pi1@rasp:~/temp$
pi1@rasp:~/temp$
pi1@rasp:~/temp$ xauth list | grep -i '10.'
raspberrypi/unix:10  MIT-MAGIC-COOKIE-1  527dd72ade8c37eed6066df0ea8d33bf
pi1@rasp:~/temp$ 


I am also running xming with default settings on client, after running the xclock on terminal I got

pi1@rasp:~/temp$ xclock
Warning: Missing charsets in String to FontSet conversion