{"id":3489,"date":"2021-06-26T12:32:14","date_gmt":"2021-06-26T12:32:14","guid":{"rendered":"https:\/\/markitiers.in\/step\/?p=3489"},"modified":"2021-07-14T13:21:51","modified_gmt":"2021-07-14T13:21:51","slug":"oracle-dba","status":"publish","type":"post","link":"https:\/\/stepforwardsolution.com\/oracle-dba\/","title":{"rendered":"Oracle DBA"},"content":{"rendered":"

 <\/p>\n

A) Start Oracle Apps Process<\/strong><\/p>\n

1.<\/strong>\u00a0Login to the Linux server system with the login credentials specified whilst installation of Oracle Apps server.<\/p>\n

e.g. In this case, user logged in with \u201cOracle\u201d user.<\/p>\n

\"5\"<\/p>\n

2.<\/strong>\u00a0Check the network connectivity.<\/p>\n

\"51\"<\/p>\n

3.<\/strong>\u00a0Check the filesystem for space available and required in future.<\/p>\n

4.<\/strong>\u00a0Refer to the last session stop log file for any error if occurred.<\/p>\n

5.<\/strong>\u00a0Now set the environment in the db stack (oracle db home) by executing the <dbname>_<hostname>.env<\/p>\n

e.g. user executed below command from \u201c\/oracle\/u01\/oraprod\/11.2.0\u201d<\/p>\n

. VIS_step.env<\/p>\n

\"52\"<\/p>\n

\"53\"<\/p>\n

6.<\/strong>\u00a0Now start the listener : listener start <listener name><\/p>\n

e.g \u00a0\u00a0\u00a0\u00a0\u00a0lsnrctl start VIS<\/p>\n

\"54\"<\/p>\n

7.<\/strong>\u00a0Now login to Database as sys user and start the database.<\/p>\n

[oracle@step 11.2.0]$ sqlplus “\/as sysdba”<\/p>\n

 <\/p>\n

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 9 13:38:55 2016<\/p>\n

Copyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.<\/p>\n

Connected to an idle instance.<\/p>\n

SQL> startup<\/p>\n

\"55\"<\/p>\n

8.<\/strong>\u00a0Please confirm the database is up and running along with the listener.<\/p>\n

9.<\/strong>\u00a0Go to APPL_TOP and set the environment of Apps.<\/p>\n

\"56\"<\/p>\n

10.\u00a0<\/strong>Go to ADMIN_SCRIPTS_HOME<\/p>\n

\"57\"<\/p>\n

11.<\/strong>\u00a0Now, Run adstrtal.sh to start Application Server<\/p>\n

adstrtal.sh apps\/apps<\/p>\n

It will ask for Weblogic Password. We need to enter weblogic password.<\/p>\n

\"58\"<\/p>\n

12.<\/strong>\u00a0Once the script is executed till the point we keep on receiving ——–\u201cexited with 0\u201d means that the everything is going on track, the moment we get exited with 1 means that part of server has not been up due to any reason, the details of the same can be viewed in the log file of the same.<\/p>\n

B) Stop Oracle Apps Server<\/strong><\/p>\n

1.<\/strong>\u00a0Go to APPL_TOP and set the environment of Apps.<\/p>\n

e.g. cd \/oracle\/u01\/applprod\/fs1\/EBSapps\/appl<\/p>\n

\"59\"<\/p>\n

13.<\/strong>\u00a0Go to ADMIN_SCRIPTS_HOME and run adstpall.sh to stop Application Server<\/p>\n

adstpall.sh apps\/apps<\/p>\n

\"60\"<\/p>\n

It will ask for weblogic password, which we need to provide.<\/p>\n

\"61\"<\/p>\n

14.<\/strong>\u00a0Ensure that the script exits with 0 if not then refer to the log file.<\/p>\n

15.<\/strong>\u00a0Now before shutting down DB please ensure that all the oracle apps process is down by checking the FNDLIBR process.<\/p>\n

ps -ef |grep FNDLIBR<\/p>\n

\"62\"<\/p>\n

It is showing 4 processors.<\/p>\n

Keep on executing FNDLIBR command as above to confirm that each and every process is closed.<\/p>\n

\"63\"<\/p>\n

16.<\/strong>\u00a0Now, set DB environment.<\/p>\n

\"64\"<\/p>\n

17.<\/strong>\u00a0Now login to Database as sys user and stop the database.<\/p>\n

\"65\"<\/p>\n

\"66\"<\/p>\n

18.<\/strong>\u00a0Now we can stop the listener.<\/p>\n

\"67\"<\/p>\n","protected":false},"excerpt":{"rendered":"

  A) Start Oracle Apps Process 1.\u00a0Login to the Linux server system with the login credentials specified whilst installation of Oracle Apps server. e.g. In this case, user logged in with \u201cOracle\u201d user. 2.\u00a0Check the network connectivity. 3.\u00a0Check the filesystem for space available and required in future. 4.\u00a0Refer to the last session stop log file…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_jetpack_memberships_contains_paid_content":false},"categories":[45],"tags":[],"class_list":["post-3489","post","type-post","status-publish","format-standard","hentry","category-oracle-dba","category-45","description-off"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts\/3489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/comments?post=3489"}],"version-history":[{"count":3,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts\/3489\/revisions"}],"predecessor-version":[{"id":3679,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts\/3489\/revisions\/3679"}],"wp:attachment":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/media?parent=3489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/categories?post=3489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/tags?post=3489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}