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