Re: request for srvctl output

  • From: Freek D'Hooge <freek.dhooge@xxxxxxxxx>
  • To: Steve Harville <steve.harville@xxxxxxxxx>
  • Date: Wed, 05 Feb 2014 18:33:28 +0100

Steve,

Thanks for the output.

For the rac one node, could you send me the output of: srvctl status
database -d mhngld

In the output for the single instance, there are actually 4 instances
listed.
Is that correct?


kind regards,

-- 
Freek D'Hooge
Exitas NV
Senior Oracle DBA
email: freek.dhooge@xxxxxxxxx
tel +32(03) 443 12 38
http://www.exitas.be 

On wo, 2014-02-05 at 09:56 -0500, Steve Harville wrote:
> RAC one-node:
> [oracle@edt1db01 ~]$ srvctl config database -d mhngld
> Database unique name: MHNGLD
> Database name: MHNGLD
> Oracle home: /u01/app/oracle/product/11.2.0.3/dbhome_6
> Oracle user: oracle
> Spfile: +DATA_EDT1/MHNGLD/spfileMHNGLD.ora
> Domain: FINISHLINE.COM
> Start options: open
> Stop options: immediate
> Database role: PRIMARY
> Management policy: AUTOMATIC
> Server pools: MHNGLD
> Database instances:
> Disk Groups: DATA_EDT1,RECO_EDT1
> Mount point paths:
> Services: MHNGLD_DBA
> Type: RACOneNode
> Online relocation timeout: 30
> Instance name prefix: MHNGLD
> Candidate servers: edt2db04,edt2db03
> Database is administrator managed
> 
> 
> Single instance:
> [oracle@edt1db01 ~]$ srvctl config database -d ribtst
> Database unique name: RIBTST
> Database name: RIBTST
> Oracle home: /u01/app/oracle/product/11.2.0.3/dbhome_3
> Oracle user: oracle
> Spfile: +DATA_EDT2/RIBTST/spfileRIBTST.ora
> Domain:
> Start options: open
> Stop options: immediate
> Database role: PRIMARY
> Management policy: AUTOMATIC
> Server pools: RIBTST
> Database instances: RIBTST1,RIBTST2,RIBTST3,RIBTST4
> Disk Groups: DATA_EDT2,RECO_EDT2,DATA_EDT1,RECO_EDT1
> Mount point paths:
> Services: RIBTST_dba
> Type: RAC
> Database is administrator managed
> 
> 
> 
> 
> 
> 
> Steve Harville
> 
> 
> 
> 
> 
> On Wed, Feb 5, 2014 at 8:30 AM, Freek D'Hooge <freek.dhooge@xxxxxxxxx>
> wrote:
> 
>         Hi,
>         
>         I'm building a script to set the oracle environment variables,
>         but I would require to have some command output from different
>         types of environments to see what I need to parse.
>         Who can provide me with the output of "srvctl config database"
>         for a single instance database on rac (not oracle restart) and
>         for a rac one node database?
>         
>         The scripts are publicly available via github:
>         https://github.com/dhoogfr/rac_scripts
>         
>         
>         thanks,
>         
>         

Other related posts: