Chinaunix首页 | 论坛 | 博客

abo000的ChinaUnix博客

首页　| 　博文目录　| 　关于我

abo000

  • 博客访问： 15298
  • 博文数量： 5
  • 博客积分： 10
  • 博客等级： 民兵
  • 技术积分： 35
  • 用 户 组： 普通用户
  • 注册时间： 2012-11-02 13:52
文章分类

全部博文（5）

文章存档

2012年（5）

我的朋友
最近访客
推荐博文
重启Oracle

分类：

2012-11-02 13:58:13

原文地址：重启Oracle 作者：linux_kaige

//提交文章的时候，弹出个提示“文章中有违禁词汇，请修改”，检查之后才发现，里面我写了个“shabi”，cu博客还是挺人性化，赞一个!
重启Oracle：
Oracle由于打不到补丁，运行一段时间就出问题，准备重装，但是一直没重装，最近就是出了问题，就重启。。。

人总是很懒，最烦周末接电话了，中午tony打电话给我，说下星期有要给客户交付的东西么？我说没，然后说我们的主程请了婚假，进度咋办？他请假我都不知道，tony还不满意，说你们项目组的人请假你都不知道，你们好好沟通下吧。。。靠，这种请假是跟公司制度有关系，我虽然是项目的负责人，但请假他们是给他们直属领导请假的，这是公司的制度！！！
这种sb的制度，第一，请假人为什么不通知项目负责人？第二：他的直属领导为什么不通知他所在的项目的负责人？毕竟任务是从我这边分发的。

刚才客户又给我打电话说数据库的事儿，我不想弄，还得上vpn。。。我就说“你找XXX吧”，结果人家说是XXX让他找我了，我日。。。那就干吧。

好久没操作了，都tm忘记怎么整的了，命令都打错了，搞个sqlplus /nologin 。。。不废话了，写下操作步骤：
1.找到Oracle安装目录--bin目录
2.lnsrctl stop
3.sqlplus /nolog
4.conn /as sysdba;
5.shutdown immediate;
6.lnsrctl start
7.sqlplus /nolog
8.conn /as sysdba;
9.startup;
10.exit
很简单，但是注意查看屏幕打印的东西，是否报错。

  1. [oracle@cms01 ~]$ echo $ORACLE_HOME
  2. /u01/app/oracle/product/11.2/db1
  3. [oracle@cms01 ~]$ cd /u01/app/oracle/product/
  4. [oracle@cms01 product]$ ls
  5. 11.2
  6. [oracle@cms01 product]$ cd
  7. cd cdrdao cdrwtool
  8. cddb-slave2-properties cdrecord
  9. [oracle@cms01 product]$ cd 11.2/db1/
  10. apex/ cv/ instantclient/ mgw/ owm/ srvm/
  11. assistants/ dbs/ inventory/ network/ perl/ mn/ root.sh wwg/
  12. config/ EMStage/ ldap/ oracore/ scheduler/ xdk/
  13. crs/ has/ lib/ oraInst.loc slax/
  14. csmig/ hs/ log/ ord/ sqldeveloper/
  15. css/ ide/ md/ oui/ sqlj/
  16. ctx/ install/ mesg/ owb/ sqlplus/
  17. [oracle@cms01 product]$ cd 11.2/db1/bin/
  18. [oracle@cms01 bin]$ ls
  19. acfsroot emagtmc0 ldapmodifymt ott
  20. adapters emca ldapsearch owm
  21. d xmlcg
  22. emagent lcsscan orapwdO xmlwf
  23. emagent0 ldapadd oraxml xsl
  24. emagentdeploy.pl ldapaddmt oraxsl xsql
  25. EMAgentPatch.pm ldapbind orion xvm
  26. EMAgent.pm ldapcompare orionO zip
  27. emagtm ldapdelete osdbagrp
  28. emagtm0 ldapmoddn osdbagrp0
  29. emagtmc ldapmodify osh
  30. [oracle@cms01 bin]$ lsn
  31. lsnodes lsnrctl lsnrctl0
  32. [oracle@cms01 bin]$ lsnrctl stop
  34. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-APR-2012 17:11:42
  36. Copyright (c) 1991, 2011, Oracle. All rights reserved.
  38. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cms01)(PORT=1521)))
  39. The command completed successfully
  40. [oracle@cms01 bin]$ sqlplus /nologin
  42. SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 22 17:11:59 2012
  44. Copyright (c) 1982, 2011, Oracle. All rights reserved.
  47. SQL*Plus: Release 11.2.0.3.0 Production
  49. Copyright (c) 1982, 2011, Oracle. All rights reserved.
  51. Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.
  53. Usage 1: sqlplus -H | -V
  55. -H Displays the SQL*Plus version and the
  56. usage help.
  57. -V Displays the SQL*Plus version.
  59. Usage 2: sqlplus [ [
  63. -C Sets the compatibility of affected commands to the
  64. version specified by . The version has
  65. the form "x.y[.z]". For example, -C 10.2.0
  66. -L Attempts to log on just once, instead of
  67. reprompting on error.
  68. -M "" Sets automatic HTML markup of output. The options
  69. have the form:
  70. HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
  71. [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
  72. -R Sets restricted mode to disable SQL*Plus commands
  73. that interact with the file system. The level can
  74. be 1, 2 or 3. The most restrictive is -R 3 which
  75. disables all user commands interacting with the
  76. file system.
  77. -S Sets silent mode which suppresses the display of
  78. the SQL*Plus banner, prompts, and echoing of
  79. commands.
  81. is: {[/][@] | / }
  82. [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]
  84. Specifies the database account username, password and connect
  85. identifier for the database connection. Without a connect
  86. identifier, SQL*Plus connects to the default database.
  88. The AS SYSDBA, AS SYSOPER and AS SYSASM options are database
  89. administration privileges.
  91. can be in the form of Net Service Name
  92. or Easy Connect.
  94. @[ | [//]Host[:Port]/]
  96. is a simple name for a service that resolves
  97. to a connect descriptor.
  99. Example: Connect to database using Net Service Name and the
  100. database net service name is ORCL.
  102. sqlplus myusername/mypassword@ORCL
  104. Host specifies the host name or IP address of the database
  105. server computer.
  107. Port specifies the listening port on the database server.
  109. specifies the service name of the database you
  110. want to access.
  112. Example: Connect to database using Easy Connect and the
  113. Service name is ORCL.
  115. sqlplus myusername/mypassword@Host/ORCL
  117. The /NOLOG option starts SQL*Plus without connecting to a
  118. database.
  120. The EDITION specifies the value for Session Edition.
  123. is: @|[.] [ ...]
  125. Runs the specified SQL*Plus script from a web server (URL) or the
  126. local file system (filename.ext) with specified parameters that
  127. will be assigned to substitution variables in the script.
  129. When SQL*Plus starts, and after CONNECT commands, the site profile
  130. (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
  131. (e.g. login.sql in the working directory) are run. The files may
  132. contain SQL*Plus commands.
  134. Refer to the SQL*Plus User's Guide and Reference for more information.
  135. [oracle@cms01 bin]$ sqlplus /nolog
  137. SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 22 17:13:17 2012
  139. Copyright (c) 1982, 2011, Oracle. All rights reserved.
  141. SQL> conn /as sysdba;
  142. Connected.
  143. SQL> shutdown immediate;
  144. Database closed.
  145. Database dismounted.
  146. ORACLE instance shut down.
  147. SQL> quit
  148. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  149. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  150. [oracle@cms01 bin]$ lsnrctl start
  152. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-APR-2012 17:14:37
  154. Copyright (c) 1991, 2011, Oracle. All rights reserved.
  156. Starting /u01/app/oracle/product/11.2/db1/bin/tnslsnr: please wait...
  158. TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  159. System parameter file is /u01/app/oracle/product/11.2/db1/network/admin/listener.ora
  160. Log messages written to /u01/app/oracle/diag/tnslsnr/cms01/listener/alert/log.xml
  161. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cms01)(PORT=1521)))
  162. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  164. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cms01)(PORT=1521)))
  165. STATUS of the LISTENER
  166. ------------------------
  167. Alias LISTENER
  168. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  169. Start Date 22-APR-2012 17:14:37
  170. Uptime 0 days 0 hr. 0 min. 0 sec
  171. Trace Level off
  172. Security ON: Local OS Authentication
  173. SNMP OFF
  174. Listener Parameter File /u01/app/oracle/product/11.2/db1/network/admin/listener.ora
  175. Listener Log File /u01/app/oracle/diag/tnslsnr/cms01/listener/alert/log.xml
  176. Listening Endpoints Summary...
  177. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cms01)(PORT=1521)))
  178. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  179. The listener supports no services
  180. The command completed successfully
  181. [oracle@cms01 bin]$ sqlplus /nolog
  183. SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 22 17:14:42 2012
  185. Copyright (c) 1982, 2011, Oracle. All rights reserved.
  187. SQL> conn /as sysdba;
  188. Connected to an idle instance.
  189. SQL> startup;
  190. ORACLE instance started.
  192. Total System Global Area 1.8840E+10 bytes
  193. Fixed Size 2236248 bytes
  194. Variable Size 2617245864 bytes
  195. Database Buffers 1.6173E+10 bytes
  196. Redo Buffers 47484928 bytes
  197. Database mounted.
  198. Database opened.
  199. SQL>
  200. SQL> quit
  201. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  202. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  203. [oracle@cms01 bin]$
启动oracle 
su - oracle 
sqlplus /nolog 
conn /as sysdba 
startup 
exit 
lsnrctl start 
exit 

关闭oracle 
su - oracle 
sqlplus /nolog 
conn /as sysdba 
// conn as username/passwd
shutdown immediate 
exit 
lsnrctl stop 
exit 
****************************************************************************
linux下安装oracle10g，在执行autorunner之前，执行xhost+   上次是报dispaly变量错误，所以才无法打开图形界面安装。

又在csdn上看到这个哥们写的比较详细的操作步骤，分享一下：

  1. 在实际的应用中，有时候工作数据库需要重新启动。本文介绍了一个特别实用的操作步骤，希望对大家有所帮助。
  3. 　　1. 停应用层的各种程序
  5. 　　2. 停Oralce的监听进程
  7. 　　$ lsnrctl stop
  9. 　　3. 在独占的系统用户下，备份控制文件:
  11. 　　$ sqlplus "/as sysdba"
  13. 　　SQL> alter database backup controlfile to trace;
  15. 　　4. 在独占的系统用户下，手工切换重作日志文件，确保当前已修改过的数据存入文件:
  17. 　　SQL> alter system switch logfile;
  19. 　　5. 在独占的系统用户下，运行下面SQL语句，生成杀数据库用户连接的kill_all_session.sql文件:
  21. 　　SQL> set head off;
  23. 　　SQL> set feedback off;
  25. 　　SQL> set newpage none;
  27. 　　SQL> spool ./kill_session.sql
  29. 　　SQL> select 'alter system kill session '''　　sid　　','　　serial#　　''';' from v$session where username is not null;
  31. 　　SQL> spool off;
  33. 　　6. 在独占的系统用户下，执行杀数据库用户连接的kill_session.sql文件
  35. 　　SQL> @./kill_session.sql
  37. 　　7. 在独占的系统用户下，用immediate方式关闭数据库:
  39. 　　SQL> shutdown immediate;
  41. 　　或者
  43. 　　SVRMGRL> shutdown immediate;
  45. 　　8. 启动oralce的监听进程
  47. 　　$ lsnrctl start
  49. 　　9. 进入独占的系统用户下，启动Oralce数据库
  51. 　　$ sqlplus /nolog
  53. 　　SQL> connect / as sysdba
  55. 　　SQL> startup;
  57. 　　或者
  59. 　　$ svrmgrl
  61. 　　SVRMGRL> connect internal;
  63. 　　SVRMGRL> startup;
  65. 　　10.启动应用层的各种程序
尊重作者，原文地址：http://blog.csdn.net/usthycp/article/details/3847624






阅读(1538) | 评论(0) | 转发(0) |
0

上一篇：一次Oracle rac宕机分析

下一篇：没有了

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6