[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference smurf::ase

Title:ase
Moderator:SMURF::GROSSO
Created:Thu Jul 29 1993
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2114
Total number of notes:7347

1963.0. "suggestion for OPS startup required" by TRN02::ALMONDO (Quid ut UNIX ?) Thu Mar 20 1997 09:30

Hi all,

I have a question about OPS startup on a TCR environment.

We have installed a TCR environment with the following services:

 serv1 :  DRD service containing most of the database data files plus the
	  control, system and temp area. the relocation policy is balance.

 serv2 :  DRD service containing the redolog for istance 1 and the data files
          that are mostly (or only) accessed by istance 1, relocation policy
          is preferred on member  host1.

 serv3 :  DRD service containing the redolog for istance 2 and the data files
          that are mostly accessed by istance 2, relocation policy is preferred
          member on host2.

 dbserv1: Disk service, containing the file system used for the archive files
          of istance 1, this service has an IP alias associated with the name
          and the relocation policy is preferred on member host1.

 dbserv2: Disk service, containing the file system used for the archive files
          of istance 2, this service has an IP alias associated with the name
          and the relocation policy is preferred on member host2.

 We are planning to startup and shutdown the oracle istance into the start
 and stop action script of the dbase1 and dbase2 services. The clients
 uses the IP alias dbase1 and dbase2 to connect the istance.

 Our problem is how we can be shure that all the drd service are up and
 running before try to start the OPS istance on the note.

 Is there any comments, suggestion or example of how to startup OPS on 
 the TCR members?

 Regards,
 Mario Almondo


    
T.RTitleUserPersonal
Name
DateLines
1963.1Use 'file'UNIX command to DRD devicesAMCUCS::KKDASLet's Train The TrainersMon Mar 24 1997 16:307
If you execute 'file' UNIX command to all relevant DRD devices from Oracle
account, it will detect availability of all devices (A DRD device may not be
available or accessible by Oracle due to one of the following reason: DRD
service is down, underlying disk is not physically accessible, or DRD device is
not owned by Oracle).

/KK/
1963.2USCTR1::ASCHERDave AscherMon Mar 24 1997 17:4114
    I have no idea why this should be necessary but at another
    customer site I implemented a script in /sbin/rc3.d that basically
    did 'asemgr -d' to check for any 'unassigned' services. It
    ALWAYS finds some (I don't understand why) and it simply issues
    a 'asemgr -x servicename; asemgr -s servicename' for each service
    that was 'unassigned'. When it is all done it invokes the oracle
    startup stuff. 
    
    It is not at all elegant but it seems to have made them happy
    for now.
    
    d
    
1963.3start/stop scripts up & runningTRN02::ALMONDOQuid ut UNIX ?Thu Mar 27 1997 06:2019
    
    Thanks for the hints,
    
    The solution in .2 is similar to what i have done, the only
    difference is that in the start script, if any of the required
    service is not available, the script (running in batch mode)
    sleeps sometime and then reloop to check the services, the stop
    script, checks for the start script sill running and if it is there
    then means that the db never started and so it just kill the start
    action.
    
    Mario.
    
    PS: i had some problem of unassigned drd services due to network
        problems between the cluster members. note that this happen
        if (by mistake) durimg the setup of ASE on the TCR the
        hostname are specified as members instead of the memory
         channel ip network names.
    
1963.4USCTR1::ASCHERDave AscherThu Mar 27 1997 12:5619
re:             <<< Note 1963.3 by TRN02::ALMONDO "Quid ut UNIX ?" >>>
                      -< start/stop scripts up & running >-
    
    PS: i had some problem of unassigned drd services due to network
        problems between the cluster members. note that this happen
        if (by mistake) durimg the setup of ASE on the TCR the
        hostname are specified as members instead of the memory
         channel ip network names.
    

    Hmmmm... in your case was it always the same drd services 
    came up unassigned? in this case it was random... How do you
    fix this problem? do you have to re-install TCR? or can you
    modify the members (add mc_host names ? replace host names
    with mc_host names?)
    
    ciao,
    
    d