RE: Solaris 10 using RAW disk space - IDS 11.50.FC
Larry couldn't get IDS 11.50.FC5 on Solaris 10 to use raw disk slices when adding chunks to a new dbspace, despite links in /dev/rdsk being owned by informix. Replies suggested checking that the slice doesn't start at block 0 (VTOC conflict), using a larger offset (recommendations ranged from 2 blocks to 1024K/4096K), verifying 0660 informix:informix permissions on the final link, and testing size with dd. The real cause turned out to be that the sysadmin had not finished configuring some of the virtual disks; once fixed, it worked. A follow-up HDR question (secondary stuck in Fast Recovery, "Cannot connect to primary") drew advice to check sqlhosts hostname/port and test with dbaccess, but no resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I am running 11.50.FC5WE in a Solaris 10 environment. I initially had trouble initializing my instance using the raw space, but after some work and after switching to a different slice I was able to initialize the instance. Now I am trying to add raw chunks to a new dbspace and am running into the same problem that I was having initializing. Everything appears to be set up correctly, but the database apparently cant access the slices that I have linked to. Has anyone else run into this type of situation on solaris? The SA claims that the space is set up correctly and should be accessible, but I don't know how else to check and see if it is in fact correct. The SA created a link to the actual slices in /dev/rdsk. I have changed the group and ownership of the slices to informix. I have created links to the links in /dev/dbspace_prod where I store dbspace links. For example: /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 -> /devices/scsi.......,raw So I have a link to a link to a raw slice. This has worked on other systems that we have. Any insight would be greatly appreciated. Larry
Hi , just a stupid question, considering you use slice 0. I hope your slice does not start on block 0 ??? (conflict with VTOC !!) Jacques -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Thursday, April 29, 2010 3:24 PM To: ids@iiug.org Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929] I am running 11.50.FC5WE in a Solaris 10 environment. I initially had trouble initializing my instance using the raw space, but after some work and after switching to a different slice I was able to initialize the instance. Now I am trying to add raw chunks to a new dbspace and am running into the same problem that I was having initializing. Everything appears to be set up correctly, but the database apparently cant access the slices that I have linked to. Has anyone else run into this type of situation on solaris? The SA claims that the space is set up correctly and should be accessible, but I don't know how else to check and see if it is in fact correct. The SA created a link to the actual slices in /dev/rdsk. I have changed the group and ownership of the slices to informix. I have created links to the links in /dev/dbspace_prod where I store dbspace links. For example: /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 -> /devices/scsi.......,raw So I have a link to a link to a raw slice. This has worked on other systems that we have. Any insight would be greatly appreciated. Larry ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
I have an offset of 200. > To: ids@iiug.org > From: jacques.lapeire@ts.fujitsu.com > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19930] > Date: Thu, 29 Apr 2010 09:48:47 -0400 > > Hi , > > just a stupid question, considering you use slice 0. > > I hope your slice does not start on block 0 ??? (conflict with VTOC !!) > > Jacques > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY > SORENSEN > Sent: Thursday, April 29, 2010 3:24 PM > To: ids@iiug.org > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929] > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially had trouble > initializing my instance using the raw space, but after some work and after > switching to a different slice I was able to initialize the instance. Now I am > trying to add raw chunks to a new dbspace and am running into the same problem > that I was having initializing. > > Everything appears to be set up correctly, but the database apparently cant > access the slices that I have linked to. Has anyone else run into this type of > situation on solaris? The SA claims that the space is set up correctly and > should be accessible, but I don't know how else to check and see if it is in > fact correct. > > The SA created a link to the actual slices in /dev/rdsk. > > I have changed the group and ownership of the slices to informix. > > I have created links to the links in /dev/dbspace_prod where I store dbspace > links. > > For example: > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 -> > /devices/scsi.......,raw > > So I have a link to a link to a raw slice. This has worked on other systems > that we have. > > Any insight would be greatly appreciated. > > Larry > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
On solaris using Solaris disk partitions, I would use an offset of at least 1024K and I've seen recommendations to use 4096. Talk to your Sun support line to verify the minimum. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 29, 2010 at 9:57 AM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > I have an offset of 200. > > > To: ids@iiug.org > > From: jacques.lapeire@ts.fujitsu.com > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19930] > > Date: Thu, 29 Apr 2010 09:48:47 -0400 > > > > Hi , > > > > just a stupid question, considering you use slice 0. > > > > I hope your slice does not start on block 0 ??? (conflict with VTOC !!) > > > > Jacques > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > > SORENSEN > > Sent: Thursday, April 29, 2010 3:24 PM > > To: ids@iiug.org > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929] > > > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially had > trouble > > initializing my instance using the raw space, but after some work and > after > > switching to a different slice I was able to initialize the instance. Now > I > am > > trying to add raw chunks to a new dbspace and am running into the same > problem > > that I was having initializing. > > > > Everything appears to be set up correctly, but the database apparently > cant > > access the slices that I have linked to. Has anyone else run into this > type > of > > situation on solaris? The SA claims that the space is set up correctly > and > > should be accessible, but I don't know how else to check and see if it is > in > > fact correct. > > > > The SA created a link to the actual slices in /dev/rdsk. > > > > I have changed the group and ownership of the slices to informix. > > > > I have created links to the links in /dev/dbspace_prod where I store > dbspace > > links. > > > > For example: > > > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 -> > > /devices/scsi.......,raw > > > > So I have a link to a link to a raw slice. This has worked on other > systems > > that we have. > > > > Any insight would be greatly appreciated. > > > > Larry > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00504502ca54ceaa31048562d0a3
Check permissions on the last physical link. Should be informix:informix 0660. Make sure that the partition is big enough to hold the chunk size by doing a dd: dd if=/dev/zero of=/dev/chunks/chunk1 bs=2K skip=<chunksize in pages - 1> count=1 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 29, 2010 at 9:48 AM, Lapeire, Jacques < jacques.lapeire@ts.fujitsu.com> wrote: > Hi , > > just a stupid question, considering you use slice 0. > > I hope your slice does not start on block 0 ??? (conflict with VTOC !!) > > Jacques > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > SORENSEN > Sent: Thursday, April 29, 2010 3:24 PM > To: ids@iiug.org > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929] > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially had > trouble > initializing my instance using the raw space, but after some work and after > switching to a different slice I was able to initialize the instance. Now I > am > trying to add raw chunks to a new dbspace and am running into the same > problem > that I was having initializing. > > Everything appears to be set up correctly, but the database apparently cant > access the slices that I have linked to. Has anyone else run into this type > of > situation on solaris? The SA claims that the space is set up correctly and > should be accessible, but I don't know how else to check and see if it is > in > fact correct. > > The SA created a link to the actual slices in /dev/rdsk. > > I have changed the group and ownership of the slices to informix. > > I have created links to the links in /dev/dbspace_prod where I store > dbspace > links. > > For example: > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 -> > /devices/scsi.......,raw > > So I have a link to a link to a raw slice. This has worked on other systems > that we have. > > Any insight would be greatly appreciated. > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00504502ad51a454e3048562ddd7
I've seen recommendations of 2 blocks - that is what I tend to use -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Thursday, April 29, 2010 11:43 AM To: ids@iiug.org Subject: Re: Solaris 10 using RAW disk space - IDS 11.5.... [19933] On solaris using Solaris disk partitions, I would use an offset of at least 1024K and I've seen recommendations to use 4096. Talk to your Sun support line to verify the minimum. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 29, 2010 at 9:57 AM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > I have an offset of 200. > > > To: ids@iiug.org > > From: jacques.lapeire@ts.fujitsu.com > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19930] > > Date: Thu, 29 Apr 2010 09:48:47 -0400 > > > > Hi , > > > > just a stupid question, considering you use slice 0. > > > > I hope your slice does not start on block 0 ??? (conflict with VTOC !!) > > > > Jacques > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > > SORENSEN > > Sent: Thursday, April 29, 2010 3:24 PM > > To: ids@iiug.org > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929] > > > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially had > trouble > > initializing my instance using the raw space, but after some work and > after > > switching to a different slice I was able to initialize the instance. Now > I > am > > trying to add raw chunks to a new dbspace and am running into the same > problem > > that I was having initializing. > > > > Everything appears to be set up correctly, but the database apparently > cant > > access the slices that I have linked to. Has anyone else run into this > type > of > > situation on solaris? The SA claims that the space is set up correctly > and > > should be accessible, but I don't know how else to check and see if it is > in > > fact correct. > > > > The SA created a link to the actual slices in /dev/rdsk. > > > > I have changed the group and ownership of the slices to informix. > > > > I have created links to the links in /dev/dbspace_prod where I store > dbspace > > links. > > > > For example: > > > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 -> > > /devices/scsi.......,raw > > > > So I have a link to a link to a raw slice. This has worked on other > systems > > that we have. > > > > Any insight would be greatly appreciated. > > > > Larry > > > > > > > > **************************************************************************** *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > **************************************************************************** *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00504502ca54ceaa31048562d0a3 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 100429-0, 04/29/2010 Tested on: 4/29/2010 11:51:23 AM avast! - copyright (c) 1988-2010 ALWIL Software.
Well, The SA had failed to complete the setup on a couple of the virtual
disks. Once that was taken care of, the load of the database started.
Next problem
Now that that is working I started setting up HDR. I edited sqlhosts files,
/etc/services, hosts.equiv, .rhosts
Primary
onmode -d primary {secondary}
ontape -s -L 0 -t STDIO -F | rsh {secondary} /tmp/ontape_HDR_restore.ksh
The archive began on the primary and the secondary started the physical
restore. Once complete, I ran the following on the secondary:
onmode -d secondary {primary}
The secondary changed to Fast Recovery (Sec) and stayed. The following is a
snipit of the secondary online.log:
00:11:16 Physical Restore of rootdbs, physdbs, llogdbs, datadbs1 Completed.
00:11:16 Checkpoint Completed: duration was 0 seconds.
00:11:16 Fri Apr 30 - loguniq 4244, logpos 0x18a9018, timestamp: 0xb55275ee
Interval: 157452
00:11:16 Maximum server connections 0
00:11:16 DR: Reservation of the last logical log for log backup turned off
00:11:16 DR: new type = secondary, primary server name = elrond
00:11:16 DR: Trying to connect to primary server = elrond
00:11:16 DR: Cannot connect to primary server
00:11:16 DR: Turned off on secondary server
Any suggestions on what to look at to get the servers connected and
functioning properly would be greatly appreciated.
Larry
> To: ids@iiug.org
> From: paul@oninit.com
> Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19935]
> Date: Thu, 29 Apr 2010 12:51:29 -0400
>
> I've seen recommendations of 2 blocks - that is what I tend to use
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Thursday, April 29, 2010 11:43 AM
> To: ids@iiug.org
> Subject: Re: Solaris 10 using RAW disk space - IDS 11.5.... [19933]
>
> On solaris using Solaris disk partitions, I would use an offset of at least
> 1024K and I've seen recommendations to use 4096. Talk to your Sun support
> line to verify the minimum.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Thu, Apr 29, 2010 at 9:57 AM, LARRY SORENSEN <lsorensen25@msn.com> wrote:
>
> > I have an offset of 200.
> >
> > > To: ids@iiug.org
> > > From: jacques.lapeire@ts.fujitsu.com
> > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19930]
> > > Date: Thu, 29 Apr 2010 09:48:47 -0400
> > >
> > > Hi ,
> > >
> > > just a stupid question, considering you use slice 0.
> > >
> > > I hope your slice does not start on block 0 ??? (conflict with VTOC !!)
> > >
> > > Jacques
> > >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > LARRY
> > > SORENSEN
> > > Sent: Thursday, April 29, 2010 3:24 PM
> > > To: ids@iiug.org
> > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929]
> > >
> > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially had
> > trouble
> > > initializing my instance using the raw space, but after some work and
> > after
> > > switching to a different slice I was able to initialize the instance.
> Now
> > I
> > am
> > > trying to add raw chunks to a new dbspace and am running into the same
> > problem
> > > that I was having initializing.
> > >
> > > Everything appears to be set up correctly, but the database apparently
> > cant
> > > access the slices that I have linked to. Has anyone else run into this
> > type
> > of
> > > situation on solaris? The SA claims that the space is set up correctly
> > and
> > > should be accessible, but I don't know how else to check and see if it
> is
> > in
> > > fact correct.
> > >
> > > The SA created a link to the actual slices in /dev/rdsk.
> > >
> > > I have changed the group and ownership of the slices to informix.
> > >
> > > I have created links to the links in /dev/dbspace_prod where I store
> > dbspace
> > > links.
> > >
> > > For example:
> > >
> > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 ->
> > > /devices/scsi.......,raw
> > >
> > > So I have a link to a link to a raw slice. This has worked on other
> > systems
> > > that we have.
> > >
> > > Any insight would be greatly appreciated.
> > >
> > > Larry
> > >
> > >
> > >
> >
> >
> ****************************************************************************
> ***
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> >
> >
> ****************************************************************************
> ***
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00504502ca54ceaa31048562d0a3
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> _____
>
> avast! Antivirus <http://www.avast.com>; : Outbound message clean.
>
> Virus Database (VPS): 100429-0, 04/29/2010
> Tested on: 4/29/2010 11:51:23 AM
> avast! - copyright (c) 1988-2010 ALWIL Software.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Well, The SA had failed to complete the setup on a couple of the virtual
disks. Once that was taken care of, the load of the database started.
Next problem
Now that that is working I started setting up HDR. I edited sqlhosts files,
/etc/services, hosts.equiv, .rhosts
Primary
onmode -d primary {secondary}
ontape -s -L 0 -t STDIO -F | rsh {secondary} /tmp/ontape_HDR_restore.ksh
The archive began on the primary and the secondary started the physical
restore. Once complete, I ran the following on the secondary:
onmode -d secondary {primary}
The secondary changed to Fast Recovery (Sec) and stayed. The following is a
snipit of the secondary online.log:
00:11:16 Physical Restore of rootdbs, physdbs, llogdbs, datadbs1 Completed.
00:11:16 Checkpoint Completed: duration was 0 seconds.
00:11:16 Fri Apr 30 - loguniq 4244, logpos 0x18a9018, timestamp: 0xb55275ee
Interval: 157452
00:11:16 Maximum server connections 0
00:11:16 DR: Reservation of the last logical log for log backup turned off
00:11:16 DR: new type = secondary, primary server name = elrond
00:11:16 DR: Trying to connect to primary server = elrond
00:11:16 DR: Cannot connect to primary server
00:11:16 DR: Turned off on secondary server
Any suggestions on what to look at to get the servers connected and
functioning properly would be greatly appreciated.
Larry
>
> > To: ids@iiug.org
> > From: paul@oninit.com
> > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19935]
> > Date: Thu, 29 Apr 2010 12:51:29 -0400
> >
> > I've seen recommendations of 2 blocks - that is what I tend to use
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> > Kagel
> > Sent: Thursday, April 29, 2010 11:43 AM
> > To: ids@iiug.org
> > Subject: Re: Solaris 10 using RAW disk space - IDS 11.5.... [19933]
> >
> > On solaris using Solaris disk partitions, I would use an offset of at least
> > 1024K and I've seen recommendations to use 4096. Talk to your Sun support
> > line to verify the minimum.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > IIUG Board of Directors (art@iiug.org)
> >
> > See you at the 2010 IIUG Informix Conference
> > April 25-28, 2010
> > Overland Park (Kansas City), KS
> > www.iiug.org/conf
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
and
> > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> > organization with which I am associated either explicitly, implicitly, or
by
> > inference. Neither do those opinions reflect those of other individuals
> > affiliated with any entity with which I am affiliated nor those of the
> > entities themselves.
> >
> > On Thu, Apr 29, 2010 at 9:57 AM, LARRY SORENSEN <lsorensen25@msn.com>
wrote:
> >
> > > I have an offset of 200.
> > >
> > > > To: ids@iiug.org
> > > > From: jacques.lapeire@ts.fujitsu.com
> > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19930]
> > > > Date: Thu, 29 Apr 2010 09:48:47 -0400
> > > >
> > > > Hi ,
> > > >
> > > > just a stupid question, considering you use slice 0.
> > > >
> > > > I hope your slice does not start on block 0 ??? (conflict with VTOC !!)
> > > >
> > > > Jacques
> > > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > LARRY
> > > > SORENSEN
> > > > Sent: Thursday, April 29, 2010 3:24 PM
> > > > To: ids@iiug.org
> > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19929]
> > > >
> > > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially had
> > > trouble
> > > > initializing my instance using the raw space, but after some work and
> > > after
> > > > switching to a different slice I was able to initialize the instance.
> > Now
> > > I
> > > am
> > > > trying to add raw chunks to a new dbspace and am running into the same
> > > problem
> > > > that I was having initializing.
> > > >
> > > > Everything appears to be set up correctly, but the database apparently
> > > cant
> > > > access the slices that I have linked to. Has anyone else run into this
> > > type
> > > of
> > > > situation on solaris? The SA claims that the space is set up correctly
> > > and
> > > > should be accessible, but I don't know how else to check and see if it
> > is
> > > in
> > > > fact correct.
> > > >
> > > > The SA created a link to the actual slices in /dev/rdsk.
> > > >
> > > > I have changed the group and ownership of the slices to informix.
> > > >
> > > > I have created links to the links in /dev/dbspace_prod where I store
> > > dbspace
> > > > links.
> > > >
> > > > For example:
> > > >
> > > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 ->
> > > > /devices/scsi.......,raw
> > > >
> > > > So I have a link to a link to a raw slice. This has worked on other
> > > systems
> > > > that we have.
> > > >
> > > > Any insight would be greatly appreciated.
> > > >
> > > > Larry
> > > >
> > > >
> > > >
> > >
> > >
> >
****************************************************************************
> > ***
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > > >
> > >
> > >
> >
****************************************************************************
> > ***
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
****************************************************************************
> > ***
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --00504502ca54ceaa31048562d0a3
> >
> >
****************************************************************************
> > ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > _____
> >
> > avast! Antivirus <http://www.avast.com>; : Outbound message clean.
> >
> > Virus Database (VPS): 100429-0, 04/29/2010
> > Tested on: 4/29/2010 11:51:23 AM
> > avast! - copyright (c) 1988-2010 ALWIL Software.
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
On secondary server host, check the sqlhosts and ensure that you have
correct hostname and port# of the primary server.
Try connecting to primary server (from secondary server host) using
dbaccess.
- Nilesh -
ids-bounces@iiug.org wrote on 04/30/2010 11:52:16 AM:
> From:
>
> "LARRY SORENSEN" <lsorensen25@msn.com>:
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 04/30/2010 11:53 AM
>
> Subject:
>
> RE: HDR -Solaris 10 using RAW disk space - IDS.... [19952]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Well, The SA had failed to complete the setup on a couple of the virtual
> disks. Once that was taken care of, the load of the database started.
>
> Next problem
>
> Now that that is working I started setting up HDR. I edited sqlhosts
files,
> /etc/services, hosts.equiv, .rhosts
>
> Primary
>
> onmode -d primary {secondary}>
> ontape -s -L 0 -t STDIO -F | rsh {secondary} /tmp/ontape_HDR_restore.ksh>
> The archive began on the primary and the secondary started the physical
> restore. Once complete, I ran the following on the secondary:
>
> onmode -d secondary {primary}>
> The secondary changed to Fast Recovery (Sec) and stayed. The following is
a
> snipit of the secondary online.log:
>
> 00:11:16 Physical Restore of rootdbs, physdbs, llogdbs, datadbs1
Completed.
> 00:11:16 Checkpoint Completed: duration was 0 seconds.
> 00:11:16 Fri Apr 30 - loguniq 4244, logpos 0x18a9018, timestamp:
0xb55275ee
> Interval: 157452
>
> 00:11:16 Maximum server connections 0
> 00:11:16 DR: Reservation of the last logical log for log backup turned
off
> 00:11:16 DR: new type = secondary, primary server name = elrond
> 00:11:16 DR: Trying to connect to primary server = elrond
> 00:11:16 DR: Cannot connect to primary server
> 00:11:16 DR: Turned off on secondary server
>
> Any suggestions on what to look at to get the servers connected and
> functioning properly would be greatly appreciated.
>
> Larry
> >
> > > To: ids@iiug.org
> > > From: paul@oninit.com
> > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19935]
> > > Date: Thu, 29 Apr 2010 12:51:29 -0400
> > >
> > > I've seen recommendations of 2 blocks - that is what I tend to use
> > >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art
> > > Kagel
> > > Sent: Thursday, April 29, 2010 11:43 AM
> > > To: ids@iiug.org
> > > Subject: Re: Solaris 10 using RAW disk space - IDS 11.5.... [19933]
> > >
> > > On solaris using Solaris disk partitions, I would use an offset of at
> least
> > > 1024K and I've seen recommendations to use 4096. Talk to your Sun
support
> > > line to verify the minimum.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.com)
> > > IIUG Board of Directors (art@iiug.org)
> > >
> > > See you at the 2010 IIUG Informix Conference
> > > April 25-28, 2010
> > > Overland Park (Kansas City), KS
> > > www.iiug.org/conf
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
opinions
> and
> > > do not reflect on my employer, Advanced DataTools, the IIUG, norany
other
> > > organization with which I am associated either explicitly,
implicitly, or
> by
> > > inference. Neither do those opinions reflect those of other
individuals
> > > affiliated with any entity with which I am affiliated nor those of
the
> > > entities themselves.
> > >
> > > On Thu, Apr 29, 2010 at 9:57 AM, LARRY SORENSEN <lsorensen25@msn.com>
> wrote:
> > >
> > > > I have an offset of 200.
> > > >
> > > > > To: ids@iiug.org
> > > > > From: jacques.lapeire@ts.fujitsu.com
> > > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5....
[19930]
> > > > > Date: Thu, 29 Apr 2010 09:48:47 -0400
> > > > >
> > > > > Hi ,
> > > > >
> > > > > just a stupid question, considering you use slice 0.
> > > > >
> > > > > I hope your slice does not start on block 0 ??? (conflict with
VTOC
> !!)
> > > > >
> > > > > Jacques
> > > > >
> > > > > -----Original Message-----
> > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
Behalf Of
> > > > LARRY
> > > > > SORENSEN
> > > > > Sent: Thursday, April 29, 2010 3:24 PM
> > > > > To: ids@iiug.org
> > > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5....
[19929]
> > > > >
> > > > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially
had
> > > > trouble
> > > > > initializing my instance using the raw space, but after somework
and
> > > > after
> > > > > switching to a different slice I was able to initialize the
instance.
> > > Now
> > > > I
> > > > am
> > > > > trying to add raw chunks to a new dbspace and am running
> into the same
> > > > problem
> > > > > that I was having initializing.
> > > > >
> > > > > Everything appears to be set up correctly, but the database
> apparently
> > > > cant
> > > > > access the slices that I have linked to. Has anyone else runinto
this
> > > > type
> > > > of
> > > > > situation on solaris? The SA claims that the space is set
upcorrectly
> > > > and
> > > > > should be accessible, but I don't know how else to check andsee
if it
> > > is
> > > > in
> > > > > fact correct.
> > > > >
> > > > > The SA created a link to the actual slices in /dev/rdsk.
> > > > >
> > > > > I have changed the group and ownership of the slices to informix.
> > > > >
> > > > > I have created links to the links in /dev/dbspace_prod where I
store
> > > > dbspace
> > > > > links.
> > > > >
> > > > > For example:
> > > > >
> > > > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 ->
> > > > > /devices/scsi.......,raw
> > > > >
> > > > > So I have a link to a link to a raw slice. This has worked on
other
> > > > systems
> > > > > that we have.
> > > > >
> > > > > Any insight would be greatly appreciated.
> > > > >
> > > > > Larry
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
>
****************************************************************************
> > > ***
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
>
****************************************************************************
> > > ***
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
>
****************************************************************************
> > > ***
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --00504502ca54ceaa31048562d0a3
> > >
> > >
>
****************************************************************************
> > > ***
> > > Forum Note: Use "Reply
Thanks for the info; however; the sqlhosts file are equivalent and I have
tried dbaccess to connect to the other server from each with success.
Can you think of anything else?
> To: ids@iiug.org
> From: nilesho@us.ibm.com
> Subject: RE: HDR -Solaris 10 using RAW disk space - IDS.... [19954]
> Date: Fri, 30 Apr 2010 14:21:35 -0400
>
> On secondary server host, check the sqlhosts and ensure that you have
> correct hostname and port# of the primary server.
> Try connecting to primary server (from secondary server host) using
> dbaccess.
>
> - Nilesh -
>
> ids-bounces@iiug.org wrote on 04/30/2010 11:52:16 AM:
>
> > From:
> >
> > "LARRY SORENSEN" <lsorensen25@msn.com>:
> >
> > To:
> >
> > ids@iiug.org
> >
> > Date:
> >
> > 04/30/2010 11:53 AM
> >
> > Subject:
> >
> > RE: HDR -Solaris 10 using RAW disk space - IDS.... [19952]
> >
> > Sent by:
> >
> > ids-bounces@iiug.org
> >
> > Well, The SA had failed to complete the setup on a couple of the virtual
> > disks. Once that was taken care of, the load of the database started.
> >
> > Next problem
> >
> > Now that that is working I started setting up HDR. I edited sqlhosts
> files,
> > /etc/services, hosts.equiv, .rhosts
> >
> > Primary
> >
> > onmode -d primary {secondary}> >
> > ontape -s -L 0 -t STDIO -F | rsh {secondary} /tmp/ontape_HDR_restore.ksh> >
> > The archive began on the primary and the secondary started the physical
> > restore. Once complete, I ran the following on the secondary:
> >
> > onmode -d secondary {primary}> >
> > The secondary changed to Fast Recovery (Sec) and stayed. The following is
> a
> > snipit of the secondary online.log:
> >
> > 00:11:16 Physical Restore of rootdbs, physdbs, llogdbs, datadbs1
> Completed.
> > 00:11:16 Checkpoint Completed: duration was 0 seconds.
> > 00:11:16 Fri Apr 30 - loguniq 4244, logpos 0x18a9018, timestamp:
> 0xb55275ee
> > Interval: 157452
> >
> > 00:11:16 Maximum server connections 0
> > 00:11:16 DR: Reservation of the last logical log for log backup turned
> off
> > 00:11:16 DR: new type = secondary, primary server name = elrond
> > 00:11:16 DR: Trying to connect to primary server = elrond
> > 00:11:16 DR: Cannot connect to primary server
> > 00:11:16 DR: Turned off on secondary server
> >
> > Any suggestions on what to look at to get the servers connected and
> > functioning properly would be greatly appreciated.
> >
> > Larry
> > >
> > > > To: ids@iiug.org
> > > > From: paul@oninit.com
> > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5.... [19935]
> > > > Date: Thu, 29 Apr 2010 12:51:29 -0400
> > > >
> > > > I've seen recommendations of 2 blocks - that is what I tend to use
> > > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > > > Kagel
> > > > Sent: Thursday, April 29, 2010 11:43 AM
> > > > To: ids@iiug.org
> > > > Subject: Re: Solaris 10 using RAW disk space - IDS 11.5.... [19933]
> > > >
> > > > On solaris using Solaris disk partitions, I would use an offset of at
>
> > least
> > > > 1024K and I've seen recommendations to use 4096. Talk to your Sun
> support
> > > > line to verify the minimum.
> > > >
> > > > Art
> > > >
> > > > Art S. Kagel
> > > > Advanced DataTools (www.advancedatatools.com)
> > > > IIUG Board of Directors (art@iiug.org)
> > > >
> > > > See you at the 2010 IIUG Informix Conference
> > > > April 25-28, 2010
> > > > Overland Park (Kansas City), KS
> > > > www.iiug.org/conf
> > > >
> > > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > and
> > > > do not reflect on my employer, Advanced DataTools, the IIUG, norany
> other
> > > > organization with which I am associated either explicitly,
> implicitly, or
> > by
> > > > inference. Neither do those opinions reflect those of other
> individuals
> > > > affiliated with any entity with which I am affiliated nor those of
> the
> > > > entities themselves.
> > > >
> > > > On Thu, Apr 29, 2010 at 9:57 AM, LARRY SORENSEN <lsorensen25@msn.com>
>
> > wrote:
> > > >
> > > > > I have an offset of 200.
> > > > >
> > > > > > To: ids@iiug.org
> > > > > > From: jacques.lapeire@ts.fujitsu.com
> > > > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5....
> [19930]
> > > > > > Date: Thu, 29 Apr 2010 09:48:47 -0400
> > > > > >
> > > > > > Hi ,
> > > > > >
> > > > > > just a stupid question, considering you use slice 0.
> > > > > >
> > > > > > I hope your slice does not start on block 0 ??? (conflict with
> VTOC
> > !!)
> > > > > >
> > > > > > Jacques
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of
> > > > > LARRY
> > > > > > SORENSEN
> > > > > > Sent: Thursday, April 29, 2010 3:24 PM
> > > > > > To: ids@iiug.org
> > > > > > Subject: RE: Solaris 10 using RAW disk space - IDS 11.5....
> [19929]
> > > > > >
> > > > > > I am running 11.50.FC5WE in a Solaris 10 environment. I initially
> had
> > > > > trouble
> > > > > > initializing my instance using the raw space, but after somework
> and
> > > > > after
> > > > > > switching to a different slice I was able to initialize the
> instance.
> > > > Now
> > > > > I
> > > > > am
> > > > > > trying to add raw chunks to a new dbspace and am running
> > into the same
> > > > > problem
> > > > > > that I was having initializing.
> > > > > >
> > > > > > Everything appears to be set up correctly, but the database
> > apparently
> > > > > cant
> > > > > > access the slices that I have linked to. Has anyone else runinto
> this
> > > > > type
> > > > > of
> > > > > > situation on solaris? The SA claims that the space is set
> upcorrectly
> > > > > and
> > > > > > should be accessible, but I don't know how else to check andsee
> if it
> > > > is
> > > > > in
> > > > > > fact correct.
> > > > > >
> > > > > > The SA created a link to the actual slices in /dev/rdsk.
> > > > > >
> > > > > > I have changed the group and ownership of the slices to informix.
>
> > > > > >
> > > > > > I have created links to the links in /dev/dbspace_prod where I
> store
> > > > > dbspace
> > > > > > links.
> > > > > >
> > > > > > For example:
> > > > > >
> > > > > > /dev/dbspace_prod/data01dbs.prod -> /dev/rdsk/c2t5d0s0 ->
> > > > > > /devices/scsi.......,raw
> > > > > >
> > > > > > So I have a link to a link to a raw slice. This has worked on
> other
> > > > > systems
> > > > > > that we have.
> > > > > >
> > > > > > Any insight would be greatly appreciated.
> > > > > >
> > > > > > Larry
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> >
> ****************************************************************************
>
> > > > ***
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
>