$ svmon -G size inuse free pin virtual memory 5079040 5076409 2631 706856 2983249 pg space 7864320 12885 work pers clnt other pin 540803 0 2758 163295 in use 2983249 0 2093160
Thursday, January 10, 2013
AIX for Oracle DBA
A) Memory Consumption:
Wednesday, January 9, 2013
Manual Creation of Oracle Database
1. Create the pfile and sample parameter file is below
DUMMY.__db_cache_size=109051904
DUMMY.__java_pool_size=4194304
DUMMY.__large_pool_size=4194304
DUMMY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DUMMY.__pga_aggregate_target=167772160
DUMMY.__sga_target=251658240
DUMMY.__shared_io_pool_size=0
DUMMY.__shared_pool_size=125829120
DUMMY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DUMMY/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ORADATA/DUMMY/fra/DUMMY/controlfile/control_01_.ctl','/ORADATA/DUMMY/fra2/DUMMY/controlfile/control_02_.ctl'
DUMMY.__db_cache_size=109051904
DUMMY.__java_pool_size=4194304
DUMMY.__large_pool_size=4194304
DUMMY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DUMMY.__pga_aggregate_target=167772160
DUMMY.__sga_target=251658240
DUMMY.__shared_io_pool_size=0
DUMMY.__shared_pool_size=125829120
DUMMY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DUMMY/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ORADATA/DUMMY/fra/DUMMY/controlfile/control_01_.ctl','/ORADATA/DUMMY/fra2/DUMMY/controlfile/control_02_.ctl'
Friday, January 4, 2013
Using ssh-keys from Openssh to Tectiassh and vice-versa
How to find the server is Openssh or Tectiassh
> ssh -V
> ssh -V
Configuration starts from here
1. On SERVERA with Openssh:
1. ssh-keygen -t rsa
2. cd .ssh
3. It creates two files id_rsa and id_rsa.pub
4. Create a file authorized_keys and copy/paste id_rsa.pub into it.
5. ssh-keygen -e -f id_rsa.pub >Openssh_to_Tectiassh
2. cd .ssh
3. It creates two files id_rsa and id_rsa.pub
4. Create a file authorized_keys and copy/paste id_rsa.pub into it.
5. ssh-keygen -e -f id_rsa.pub >Openssh_to_Tectiassh
Subscribe to:
Posts (Atom)