PC單機最強魔人

root@test1 /databk/aix53tl12/cd1/installp/ppc => oslevel -r
5300-07

1.error

Thu Dec 13 12:11:51 2012

/etc/profile

TMOUT=300

System Requirements

This patch set has the following system requirements:

Patch Set components

Fixes for the following components (visible in the Oracle Universal Installer Summary) are included in the 8.1.7.4.0 Patch set:

1.

chuser loginretries=5 pwdwarntime=15 expires=1231230013 maxage=12 minage=1 minlen=6 minalpha=1  minother=1 maxrepeats=2 mindiff=1 USERNAME

 svrmgrl
exec(): 0509-036 Cannot load program svrmgrl because of the following errors:

ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress

1.

restore datafiles and controlfile from backup tape. try to start up a instance and find these error

1.

smitty install -> Software Maintenance and Utilities-> Remove Installed Software -> 第一個選F4然後只選openssh 的項目 (按F7選擇）

一、前置準備

基本上 AIX都是跑64bit (下lsconf)可以看到，但要 oracle在32bit故要上patch 才可跑

1.PROBLEM

conn l123/123user@web;

0.download sudo from  http://www.courtesan.com/sudo/

1.下載 SSL, SSH位置
https://www14.software.ibm.com/webapp/iwm/web/reg/pick.do?source=aixbp

A. lsnrctl status

Service "star" has 1 instance(s).

SQL> startup
ORA-09925: Unable to create audit trail file

how to change archive log dest ?

1.check current status and setting

plan-A:

1.check current status and setting.

1. check current redo log file setting  , we got 3 groups with 1 member.

SQL> select * from v$log;

1.check database current set, AL32UTB8 is Unicode. our target is to conver to BIG5

SQL> SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET';