No question at this time
DBA Top 10
1 A. Kavsek 8700
2 B. Vroman 6600
3 M. Cadot 5600
4 T. Boles 4550
5 P. Wisse 4100
6 J. Schnackenberg 3700
7 G. Lambregts 1100
7 . Lauri 1100
7 T. P 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48379
Total active users1533
Act. users last 24h5
Act. users last hour0
Registered user hits last week231
Registered user hits last month580
Go up

automating shutdown and startup
Next thread: IDLE_TIME
Prev thread: Oracle Fusion Middleware

Message Score Author Date
Hi Guys I have a server with 11g R2, 12c R1 and...... Tso P Feb 01, 2019, 14:18
Hello Tso, the oratab file contains the ORACLE_...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Bruno Vroman Feb 01, 2019, 16:31
Thanks Bruno... Tso P Feb 01, 2019, 18:22
Hi Tso, Additionally, if this is your first exp...... Lauri Feb 07, 2019, 13:19

Follow up by mail Click here


Subject: automating shutdown and startup
Author: Tso P, South Africa
Date: Feb 01, 2019, 14:18, 135 days ago
Os info: solaris 10
Oracle info: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Message: Hi Guys

I have a server with 11g R2, 12c R1 and 12c R2 I want to automate shutdown and startup.

I have followed this link https://docs.oracle.com/database/121/UNXAR/strt_stp.htm#UNXAR417 from Oracle, but I don't know how to call different oracle homes as the link only shows exporting one ORACLE_HOME.

Please Help!!!

Thanks in advance...




Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: automating shutdown and startup
Author: Bruno Vroman, Belgium
Date: Feb 01, 2019, 16:31, 135 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hello Tso,

the oratab file contains the ORACLE_HOME for each database (you can have several different ORACLE_HOMEs in the file but still there is only one "oratab" file)

Thanks to this the scripts can set the ORACLE_HOME environment variable to the relevant value. Typically you write a script that read the oratab line by line (or that searches for the "pmon" processes, or any other way to list the database that you want) and for each you set the environment to the relevant values ( . oraenv ) then whatever you will do for a given database will use the correct version.

Have a look at the content of dbshut / dbstart to have more explanations.

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: automating shutdown and startup
Author: Tso P, South Africa
Date: Feb 01, 2019, 18:22, 135 days ago
Message: Thanks Bruno
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-automating shutdown and startup
Author: Lauri, Netherlands
Date: Feb 07, 2019, 13:19, 130 days ago
Message: Hi Tso,

Additionally, if this is your first experience, you can follow the steps on this link:
https://oracle-base.com/articles/linux/automating-database-startup-and-shutdown-on-linux

Kind Regards,

Lauri
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here