Skip to content

Archive for

May 22

2 Comments

How do you bring GUI from terminal on your pc host

If you are working database on putty terminal at your pc host, you are thinking  like to do configure new database use dbca or  any other graphical user method. you may jump into GUI  linux machine and do your work like vncviewer. Do you know you can able to do from your putty termianl. How? Just download Xmanager software and install on your pc host and set display on putty terminal. The display should be on your pc host ipaddress and also check both side Firewall is turn off.

Download Xmanager

Check Firewall turn off on both machine ( Linux and pc host ).

Install Xmanager  on your host

start Xmanager

now go to putty terminal and set display (ipaddres of pc host not linux machine).

[root@testser ~]# su – oracle
[oracle@testser ~]$ export DISPLAY=10.x.xx.xx:0.0
[oracle@testser ~]$ dbca

 

May 21

Couldn’t find device with uuid ‘6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0’ volume group unknown device

When i try to increase the size primary volume group , it show following error.

[root@testser dev]# pvscan

Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'.
PV /dev/sda2 VG VolGroup00 lvm2 [24.88 GB / 0 free]
PV unknown device VG VolGroup00 lvm2 [4.97 GB / 4.97 GB free]
PV /dev/sde1 lvm2 [4.99 GB]
Total: 3 [34.84 GB] / in use: 2 [29.84 GB] / in no VG: 1 [4.99 GB]

User --removemissing command to resolve this issues.

root@testser dev]# vgreduce --removemissing VolGroup00
Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'.
Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'.
Wrote out consistent volume group VolGroup00
[root@testser dev]# pvdisplay

May 21

dbms_space displaying information about space usage

Oracle Database provides data dictionary views and PL/SQL packages that allow you to display information about the space usage of schema objects.

DBMS_SPACE : refer here

Just a example :

SQL> VARIABLE total_blocks NUMBER
SQL> VARIABLE total_bytes NUMBER
SQL> VARIABLE unused_blocks NUMBER
SQL> VARIABLE unused_bytes NUMBER
SQL> VARIABLE lastextf NUMBER
SQL> VARIABLE last_extb NUMBER
SQL> VARIABLE lastusedblock NUMBER

SQL> exec DBMS_SPACE.UNUSED_SPACE('SCOTT', 'EMP', 'TABLE', :total_blocks,:total_ bytes,:unused_blocks,:unused_bytes, :lastextf,:last_extb, :lastusedblock);

PL/SQL procedure successfully completed.

SQL> print

TOTAL_BLOCKS
------------
8
TOTAL_BYTES
-----------
65536
UNUSED_BLOCKS
-------------
4
UNUSED_BYTES
------------
32768
LASTEXTF
----------
4
LAST_EXTB
----------
144
LASTUSEDBLOCK
-------------
4

SQL>

May 16

Easily connect mapped network using pushd command

I would like to share this information

If you want to connect map network using command prompt in windows , you can use pushd command.

C:\Users\mazar>pushd \\10.1.xx.xxx\export

Z:\>dir
Volume in drive Z has no label.
Volume Serial Number is 3CF7-C48C

Directory of Z:\

05/14/2012 02:55 PM <DIR> .
05/14/2012 02:55 PM <DIR> ..
01/23/2012 11:43 AM 866,799 itsupport-db_2012-01-23.sql
01/29/2012 04:15 PM 1,094,435 itsupport-db_2012-01-29.sql
01/31/2012 11:57 AM 1,144,597 itsupport-db_2012-01-31.sql
02/04/2012 04:18 PM 1,267,529 itsupport-db_2012-02-04.sql
02/05/2012 03:23 PM 1,305,221 itsupport-db_2012-02-05.sql

popd command use to disconnect mapped network.

Z:\>popd

C:\Users\mazar>

More Detail :

http://www.techrepublic.com/blog/window-on-windows/use-the-pushd-popd-commands-for-quick-network-drive-mapping-in-windows-7/6144

 

May 8

ASM : Multiplex redolog files

If you have two diskgroup, you want to multiplex redo in different diskgroup, you just add redo log desitnation
diskgroup.

sql>alter system set db_create_online_log_dest_1='+RED01' scope=spfile;

System altered.

sql>alter system set db_create_online_log_dest_2='+REDO2' scope=spfile;

System altered

SQL> create pfile='/u01/initcrmprod.ora' from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@siebeldb ~]$ vi /u01/initcrmprod.ora
[oracle@siebeldb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 28 18:12:42 2012

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

Connected to an idle instance.

SQL> create spfile from pfile='/u01/initcrmprod.ora';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 6747725824 bytes
Fixed Size 2213976 bytes
Variable Size 3623880616 bytes
Database Buffers 3087007744 bytes
Redo Buffers 34623488 bytes
Database mounted.
Database opened.

SQL> select l.group# , l.bytes , l.status , lf.member from v$logfile lf , v$log l where lf.group# = l.group#;

GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
3 52428800 INACTIVE
+DATA/crmprod/onlinelog/group_3.263.781072923

3 52428800 INACTIVE
+FRA/crmprod/onlinelog/group_3.259.781072923

2 52428800 INACTIVE
+DATA/crmprod/onlinelog/group_2.262.781072911
GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
2 52428800 INACTIVE
+FRA/crmprod/onlinelog/group_2.258.781072913

1 52428800 CURRENT
+DATA/crmprod/onlinelog/group_1.261.781072891

1 52428800 CURRENT
+FRA/crmprod/onlinelog/group_1.257.781072891
6 rows selected.

QL> show parameter db_create_online_log_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1 string +REDO1
db_create_online_log_dest_2 string +REDO2
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database add logfile group 3 size 52428800;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database add logfile group 2 size 52428800;

Database altered.

SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01623: log 1 is current log for instance crmprod (thread 1) - cannot drop
ORA-00312: online log 1 thread 1:
'+DATA/crmprod/onlinelog/group_1.261.781072891'
ORA-00312: online log 1 thread 1:
'+FRA/crmprod/onlinelog/group_1.257.781072891'

SQL> alter system switch logfile;

System altered.

SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance crmprod (thread 1)
ORA-00312: online log 1 thread 1:
'+DATA/crmprod/onlinelog/group_1.261.781072891'
ORA-00312: online log 1 thread 1:
'+FRA/crmprod/onlinelog/group_1.257.781072891'

SQL> alter system switch logfile;

System altered.

SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance crmprod (thread 1)
ORA-00312: online log 1 thread 1:
'+DATA/crmprod/onlinelog/group_1.261.781072891'
ORA-00312: online log 1 thread 1:
'+FRA/crmprod/onlinelog/group_1.257.781072891'
SQL> select l.group# , l.bytes , l.status , lf.member from v$logfile lf , v$log l where lf.group# = l.group#;

GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
3 52428800 CURRENT
+REDO1/crmprod/onlinelog/group_3.256.781812953

3 52428800 CURRENT
+REDO2/crmprod/onlinelog/group_3.256.781812953

2 52428800 ACTIVE
+REDO1/crmprod/onlinelog/group_2.257.781812977
GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
2 52428800 ACTIVE
+REDO2/crmprod/onlinelog/group_2.257.781812977

1 52428800 ACTIVE
+DATA/crmprod/onlinelog/group_1.261.781072891

1 52428800 ACTIVE
+FRA/crmprod/onlinelog/group_1.257.781072891
6 rows selected.

SQL> alter system checkpoint global;

System altered.

SQL> select l.group# , l.bytes , l.status , lf.member from v$logfile lf , v$log l where lf.group# = l.group#;

GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
3 52428800 CURRENT
+REDO1/crmprod/onlinelog/group_3.256.781812953

3 52428800 CURRENT
+REDO2/crmprod/onlinelog/group_3.256.781812953

2 52428800 INACTIVE
+REDO1/crmprod/onlinelog/group_2.257.781812977
GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
2 52428800 INACTIVE
+REDO2/crmprod/onlinelog/group_2.257.781812977

1 52428800 INACTIVE
+DATA/crmprod/onlinelog/group_1.261.781072891

1 52428800 INACTIVE
+FRA/crmprod/onlinelog/group_1.257.781072891
6 rows selected.

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1 size 52428800;

Database altered.

SQL> select l.group# , l.bytes , l.status , lf.member from v$logfile lf , v$log l where lf.group# = l.group#;

GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
3 52428800 CURRENT
+REDO1/crmprod/onlinelog/group_3.256.781812953

3 52428800 CURRENT
+REDO2/crmprod/onlinelog/group_3.256.781812953

2 52428800 INACTIVE
+REDO1/crmprod/onlinelog/group_2.257.781812977
GROUP# BYTES STATUS
---------- ---------- ----------------
MEMBER
--------------------------------------------------------------------------------
2 52428800 INACTIVE
+REDO2/crmprod/onlinelog/group_2.257.781812977

1 52428800 UNUSED
+REDO1/crmprod/onlinelog/group_1.258.781813125

1 52428800 UNUSED
+REDO2/crmprod/onlinelog/group_1.258.781813125
6 rows selected.

SQL>