We help IT Professionals succeed at work.

Solaris - How to check pseudo/md is offline? Informix DB

paulfoel
paulfoel asked
on
258 Views
Last Modified: 2018-02-07
Informix DB wont start up because it says chunk is offline. How do I tell what the device is pointing to?

Heres the ls-al:-

lrwxrwxrwx   1 root     root          29 Feb  6  2013 /dev/DB -> /devices/pseudo/md@0:0,10,raw

How do I tell if this device is offline or not?
Comment
Watch Question

Joseph GanSystem Admin
CERTIFIED EXPERT

Commented:
Please show following output here:
# metsatat -p
# echo | format
# df -h
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Metastat I think is the correct command to get the list of meta devices.
http://docs.oracle.com/cd/E19253-01/816-5166/metastat-1m/index.html
Metadb is another command that you see if one if the replica/failed and missing the data partition as the cause of the failure.

Make sure to look at the man pages to understand what it does before running commands.

Author

Commented:
d30 -m d31 d32 1
d31 1 1 /dev/dsk/c3t60060160A6602E005C4FCE51FA50E211d0s3
d32 1 1 /dev/dsk/c3t60060160EF602E008C0EDC31FA50E211d0s3
d20 -m d21 d22 1
d21 1 1 /dev/dsk/c3t60060160A6602E005C4FCE51FA50E211d0s1
d22 1 1 /dev/dsk/c3t60060160EF602E008C0EDC31FA50E211d0s1
d10 -m d11 d12 1
d11 1 1 /dev/dsk/c3t60060160A6602E005C4FCE51FA50E211d0s0
d12 1 1 /dev/dsk/c3t60060160EF602E008C0EDC31FA50E211d0s0

Searching for disks...done


AVAILABLE DISK SELECTIONS:
       0. c0d0 <SUN-DiskSlice-69GB cyl 16384 alt 2 hd 64 sec 139>
          /virtual-devices@100/channel-devices@200/disk@0
       1. c0d1 <SUN-DiskSlice-69GB cyl 16384 alt 2 hd 64 sec 139>
          /virtual-devices@100/channel-devices@200/disk@1
       2. c3t60060160A6602E005C4FCE51FA50E211d0 <DGC-VRAID-0531 cyl 51198 alt 2 hd 256 sec 32>  pt2_3B
          /scsi_vhci/ssd@g60060160a6602e005c4fce51fa50e211
       3. c3t60060160EF602E008C0EDC31FA50E211d0 <DGC-VRAID-0531 cyl 51198 alt 2 hd 256 sec 32>  pt2_3C
          /scsi_vhci/ssd@g60060160ef602e008c0edc31fa50e211
Specify disk (enter its number): Specify disk (enter its number):

Filesystem             size   used  avail capacity  Mounted on
rpool/ROOT/s10_sep11    68G    42G   6.4G    87%    /
/devices                 0K     0K     0K     0%    /devices
ctfs                     0K     0K     0K     0%    /system/contract
proc                     0K     0K     0K     0%    /proc
mnttab                   0K     0K     0K     0%    /etc/mnttab
swap                    17G   472K    17G     1%    /etc/svc/volatile
objfs                    0K     0K     0K     0%    /system/object
sharefs                  0K     0K     0K     0%    /etc/dfs/sharetab
/platform/sun4v/lib/libc_psr/libc_psr_hwcap3.so.1
                        49G    42G   6.4G    87%    /platform/sun4v/lib/libc_psr.so.1
/platform/sun4v/lib/sparcv9/libc_psr/libc_psr_hwcap3.so.1
                        49G    42G   6.4G    87%    /platform/sun4v/lib/sparcv9/libc_psr.so.1
fd                       0K     0K     0K     0%    /dev/fd
swap                    17G    17M    17G     1%    /tmp
swap                    17G    64K    17G     1%    /var/run
rpool/Lumension         68G    31K   6.4G     1%    /Lumension
data/data1             4.0G   108M   3.9G     3%    /data1
data/data2              20G    61K    20G     1%    /data2
data/db_dump            36G   314M    36G     1%    /db_dump
rpool/export            68G    23K   6.4G     1%    /export
rpool/export/home      8.0G   7.2G   780M    91%    /export/home
s9zone/zones            68G    27G    40G    41%    /export/home/s9-zone
rpool                   68G    97K   6.4G     1%    /rpool
s9zone                  68G    31K    40G     1%    /s9zone
rpool/oracle            68G   2.2G   6.4G    26%    /usr/app/oracle
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
is there a followup question in there?
Look at format/partition table of each drive.

Author

Commented:
In response to comment by Joseph Gan.
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
The data there is fine, there is no indication that you a failure of storage specifically. You have oracle if not mistaken, when you look to see what the status of the DB server is does it indicate that the DB is in an error state? Been a long time, but I think informed was bought out by oracle.
The issue you are having is after there was an issue at your location I,e, power failure, etc. that led to the system being rebooted?

The link you posted is not an issue, raw means the space created pseudo/metadevices are not mounted which is the reason they are not listed by the df command which only lists mounted filesystems.
Oracle to avoid Operating System uses raw meaning it writes/reads directly ......
So you need to use sqlplus / as sysdba
And then look at why the db was not ... Either the listener did not start after ........
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Still on the premise that oracle is the db server
https://docs.oracle.com/cd/B28359_01/server.111/b28310/start001.htm#ADMIN11142

Provides reference on checking db status to resolve the issue to start the db informix.

Author

Commented:
Nope. Definitely Informix NOT Oracle DB.

Yes aware that raw devices are not mounted as filesystems.
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Well the reference you pointed to

lrwxrwxrwx   1 root     root          29 Feb  6  2013 /dev/DB -> /devices/pseudo/md@0:0,10,raw

What does the system do? What applications are running on the system. Do you have informix DB running under the oracle DB server or DB2 or it has its own.
what does /var/adm/messages /var/log/syslog /var/log/...... indicates the issue with the item you are having an issue with.

your D30, D20, D10 could be used by your rpool/data

i can not looking at the into the information determine why you are having an issue with informix......

you have an EMC SAN that allocates two LUNs and they are partitioned/and used as a RAID 1 metadevice....
Joseph GanSystem Admin
CERTIFIED EXPERT

Commented:
To answer your original question

"lrwxrwxrwx   1 root     root          29 Feb  6  2013 /dev/DB -> /devices/pseudo/md@0:0,10,raw"

the /dev/DB is pointing to a metadevice d10, d10 is a mirrored device consosts of two sub-mirror devices d11 and d12.

d11 is on the first slice "s0" of a RAID Disk "c3t60060160A6602E005C4FCE51FA50E211d0" (disk 2 in format command), and
d12 is on the first slice "s0" of another RAID Disk "c3t60060160EF602E008C0EDC31FA50E211d0" (disk 3 in the format command).

Looks the /dev/DB has not mounted, you can create a "newfs" to this metadevice d10, and try to mount it see what happen?
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
I would not run newfs or any other command on the file system until a full understanding of what is on the system and what the issue is. Newfs will create a new file system and if there is data there as an ocsf2 or asm, etc. running the suggested command will wipe whatever is there.
Joseph GanSystem Admin
CERTIFIED EXPERT

Commented:
Ok, if there was data in /dev/DB, you could simply do "mount /dev/md/dsk/d10 /mnt" as root.

Then cd to /mnt, you should see any data in it.
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
you can not mount what is designed to be accessed as a raw block level device. Suggesting someone mount it is ill advised.
the raw device could be part of the rpool and I do not those will be reflected as mounted, while the rpool will reflect the size.
Joseph GanSystem Admin
CERTIFIED EXPERT

Commented:
All meta-devices are raw devices, until they are re-formatted. From the question, it couldn't tell whether the /dev/DB is designed to be mounted on a raw deviec or not.
"df" command did not show which doesn't mean it must be a raw device, if a filesystem is broken, it won't show in "df" command either.
That's why I suggested do a "mount" command on d10, if d10 is a raw device, the mount command will fail anyway, it won't be "ill advised".
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
One should not suggest to an individual that is in a time constrained situation that they should run newfs on a volume nor attempt to mount said device
At times if the person has been at trying to figure out what is going on, could interpret the suggestion as non-destructive but the consequences are significant if the person actually followed the suggestion and ran newfs on the /dev/d10
zpool status # to see how and what makes up the rpool.

Author

Commented:
Its a raw informix DB chunk so I agree running newfs would be a bad idea.
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Check the db related logs to see why or what is preventing the db from coming up. Do not know informix dn:
1) possible reason the db was not cleanly shutdown previously which prevents its startup now.
2) the db us in an "unstable" state, repairing .....
3) a component in the process was uncleanly shutdown and us being prevented from working......

Etc.
Looking at the "informix db" service/related logs that would shed light on why the db does not cone up or what might be preventing access to the db if there are no errors and you can locally access the db data.

Author

Commented:
Already checked the logs.....
EE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
arnoldEE Topic Advisor, IT Consultant
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
the asker's information does not include what an issue preventing the db from being accessed. Db crashed, bad state, iunclean state, oracle related the listener event does not cone up,...
All suggestions dealing with trying to identify what is going on.. the asker seems to be looking for a comment such as do X, Y, Z when the situation short of something going on with Informix DB.....is unknown.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.