Re: request for srvctl output

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_at_exitas.be
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_at_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_at_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_at_gmail.com>

> 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,

>         

>         



--
http://www.freelists.org/webpage/oracle-l