-
编辑 删除
Create schemas for new prod
create tablespace DATA datafile '+ORA_DATA' size 100M autoextend on;create user OWNER identified by **** default tablespace DATA temporary tablespace TEMP;create user USER identified by **** default tablespace DATA temporary tablespace TEMP;grant connect, resource to OWNER;grant crea...
-
编辑 删除
Modify AWR Automatic Snapshot Settings
Question: I wan to modify the frequency that I take my AWR snapshots. I understand that there is a utility that allows me to modify my AWR automatic snapshot settings. Can you please advise me on how to modify this snapshot settings? Answer:&n...
-
编辑 删除
crsctl commands
http://heliosguneserol.com/2013/01/03/how-to-stopstart-rac-components/How to Stop/Start RAC componentsIn this article, I am going to explain how to stop/start rac components. Here is the my system:My db version : 11.2.0.3My Operating System : AIX 7.1My servers host...
-
编辑 删除
srvctl commands
CRS RESOURCE STATUS srvctl status database -d<database-name> [-f] [-v] [-S <level>] srvctl status instance -d<database-name> -i <instance-name>>[,<instance-name-list>] [-f] [-v] [-S <level>] srvctl status service -d<database-name> -s <service-name>[,<se...
