数据库的日常使用

文章描述:-2022年2月19日发(作者:排课算法)开机脚本 启动HA ytyxora1:#>smitty clstart COMMAD STATUS Command: OK stdout: yes stderr: no Before command completion, additional

-

数据库的日常使用 2022年2月19日发(作者:排课算法)


开机脚本
启动HA
ytyxora1:#>smitty clstart
COMMAD STATUS

Command: OK stdout: yes stderr: no

Before command completion, additional instructi may appear below.

[TOP]


Starting Cluster Services on node: ytyxora1
This may take a few minutes. Please wait...
ytyxora1: start_cluster: Starting HACMP
ytyxora1: 127232 - 0:00 syslogd
ytyxora1: Setting routerevalidate to 1
ytyxora1: 0513-059 The clsmuxpdES Subsystem has been started. Subsystem PID is 2
70712.
ytyxora1: 0513-059 The topsvcs Subsystem has been started. Subsystem PID is 2747
46.
ytyxora1: 0513-059 The grpsvcs Subsystem has been started. Subsystem PID is 1807
[MORE...26]

F1=Help F2=Refresh F3=Cancel F6=Command
F8=Image F9=Shell F10=Exit =Find
n=Find ext
确认进程启动
ytyxora2:#>ps -ef | grep oracle
oracle 106496 1 0 07:34:00 -

oracle 168064 233478 0 0:00
oracle 233478 233798 0 07:46:01 -

oracle 241764 106496 0 07:46:02 -

0:00
0:00
0:00
-o



-l

oracle 151950 1 0 07:46:24 - 0:00
oraapporacleproduct10.1.0dbbintnslsnr LISTEER_YTYXORA2 -inherit
oracle 172468 176574 0 07:46:01 - 0:00 ksh -c
oraapporacleproduct10.1.0crsbinocssd || exit 137
root 184760 1 0 07:34:00 - 0:00

oracle 205074 213272 0 0:00
oracle 213272 172468 0 07:46:01 - 0:00

oracle 217554 1 0 07:46:35 - 0:01
oraapporacleproduct10.1.0dbjdkjrebinjava -DPROGRAM=gsd -classpath
:
:::
emon
oraapporacleproduct10.1.0db
root 225634 176136 0 07:48:20 pts0 0:00 grep oracle
oracle 233798 209130 0 07:46:01 - 0:00 ksh -c
oraapporacleproduct10.1.0crsbinoclsmon || exit $?
oracle 250260 217554 1 0:00
ytyxora2:#>
修正tcp_sendspace
ytyxora1:#>cd ora
ytyxora1:ora#>.tcp_
Setting tcp_sendspace to 262144
Change to tunable tcp_sendspace, will only be effective for future connecti
Setting tcp_recvspace to 262144
Change to tunable tcp_recvspace, will only be effective for future connecti
Setting udp_sendspace to 65536
Change to tunable udp_sendspace, will only be effective for future connecti
Setting udp_recvspace to 262144
Change to tunable udp_recvspace, will only be effective for future connecti
Setting rfc1323 to 1
Change to tunable rfc1323, will only be effective for future connecti
ytyxora1:ora#>

切换为ORACLE用户
ytyxora1:ora#>su – oracle


确认CRS状态
$ crs_stat -t
ame Type Target State Host
------------------------------------------------------------
ora.... application OLIE OLIE ytyxora1
ora.... application OLIE OLIE ytyxora1
ora.... application OLIE OLIE ytyxora1
ora.... application OLIE OLIE ytyxora1
ora.... application OLIE OLIE ytyxora2
ora.... application OLIE OLIE ytyxora2
ora.... application OLIE OLIE ytyxora2
ora.... application OLIE OLIE ytyxora2
$
启动监听
$ lsnrctl start

LSRCTL for IBMAIX RISC System6000: Version 10.1.0.4.0 - Production on 11-AUG-2005
07:51:19

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Starting oraapporacleproduct10.1.0dbbintnslsnr: please wait...

TSLSR for IBMAIX RISC System6000: Version 10.1.0.4.0 - Production
System parameter file is
Log messages written to
Listening on:
(DESCRIPTIO=(ADDRESS=(PROTOCOL=tcp)(HOST=ytyxora1)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTEER
------------------------
Alias LISTEER
Version TSLSR for IBMAIX RISC System6000: Version 10.1.0.4.0 -
Production
Start Date 11-AUG-2005 07:51:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security O: Local OS Authentication
SMP O

-

数据库的日常使用

发布时间:2022-02-19 02:00:55
文章版权声明:除非注明,否则均为IT技术网-学习WEB前端开发等IT技术的网络平台原创文章,转载或复制请以超链接形式并注明出处。

发表评论

评论列表 (有 13 条评论,20人围观)