In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-11-08 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
SQL > startup
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2232960 bytes
Variable Size 633343360 bytes
Database Buffers 197132288 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL > ho
[oracle@athena ~] $cd $ORACLE_HOME
[[oracle@athena db_home1] $cd dbs/
[oracle@athena dbs] $ll
Total 9560
-rw-rw---- 1 oracle oinstall 1544 Aug 20 20:12 hc_athena.dat
-rw-r--r-- 1 oracle oinstall 921 Feb 26 21:18 initathena.ora
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r- 1 oracle oinstall 24 Oct 25 2013 lkATHENA
-rw-r- 1 oracle oinstall 1536 Oct 25 2013 orapwathena
-rw-r- 1 oracle oinstall 9748480 Jul 8 23:07 snapcf_athena.f
-rw-r- 1 oracle oinstall 3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs] $cat initathena.ora-pfile
Athena.__db_cache_size=197132288
Athena.__java_pool_size=4194304
Athena.__large_pool_size=4194304
Athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
Athena.__pga_aggregate_target=335544320
Athena.__sga_target=503316480
Athena.__shared_io_pool_size=0
Athena.__shared_pool_size=289406976
Athena.__streams_pool_size=0
* .audit_file_dest='/s01/oracle/admin/athena/adump'
* .audit_trail='db'
* .compatible='11.2.0.0.0'
* .control_files='/s01/oracle/oradata/athena/control01.ctl','/s01/oracle/fast_recovery_area/athena/control02.ctl'
* .db_block_size=8192
* .db_domain=''
* .db_name='athena'
* .db_recovery_file_dest='/s01/oracle/fast_recovery_area'
* .db_recovery_file_dest_size=4322230272
* .diagnostic_dest='/s01/oracle'
* .dispatchers=' (PROTOCOL=TCP) (SERVICE=athenaXDB)'
* .memory_target=838860800
* .open_cursors=300
* .processes=850
* .remote_login_passwordfile='EXCLUSIVE'
* .sessions=940
* .undo_tablespace='UNDOTBS1'
[oracle@athena dbs] $ll
Total 9560
-rw-rw---- 1 oracle oinstall 1544 Aug 20 20:12 hc_athena.dat
-rw-r--r-- 1 oracle oinstall 921 Feb 26 21:18 initathena.ora
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r- 1 oracle oinstall 24 Oct 25 2013 lkATHENA
-rw-r- 1 oracle oinstall 1536 Oct 25 2013 orapwathena
-rw-r- 1 oracle oinstall 9748480 Jul 8 23:07 snapcf_athena.f
-rw-r- 1 oracle oinstall 3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs] $cat spfileathena.ora-spfile
C "R8 $4j3CC" aathena.__db_cache_size=197132288
Athena.__java_pool_size=4194304
Athena.__large_pool_size=4194304
Athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
Athena.__pga_aggregate_target=335544320
Athena.__sga_target=503316480
Athena.__shared_io_pool_size=0
Athena.__shared_pool_size=289406976
Athena.__streams_pool_size=0
* .audit_file_dest='/s01/oracle/admin/athena/adump'
* .audit_trail='db'
* .compatible='11.2.0.0.0'
* .GetWord ("control_files='/s01/oracle/oradata/athena/control01.ctl','CC");; "s01Universe Universe fastening; recoveryrecovery; area;
* .db_block_size=8192
* .db_domain=''
* .db_name='athena'
* .db_recovery_file_dest='/s01/oracle/fast_recovery_area'
* .db_recovery_file_dest_size=4322230272
* .diagnostic_dest='/s01/oracle'
* .dispatchers=' (PROTOCOL=TCP) (SERVICE=athenaXDB)'
* .memory_target=838860800
* .open_cursors=300
* .processes=850
* .remote_login_passwordfile='EXCLUSIVE'
* .girls = 94CC "610 0
* .undo_tablespace='UNDOTBS1'
CC "FeCC" EeCC "DeC [oracle@athena dbs] $Xshell
Bash: Xshell: command not found
[oracle@athena dbs] $sqlplus / nolog
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:59:22 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL > conn / as sysdba
Connected.
SQL > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL > startup
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2232960 bytes
Variable Size 633343360 bytes
Database Buffers 197132288 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL > ho
[oracle@athena dbs] $cd $ORACLE_HOME
[oracle@athena db_home1] $LL
Bash: LL: command not found
[oracle@athena db_home1] $cd dbs/
[oracle@athena dbs] $ll
Total 9560
-rw-rw---- 1 oracle oinstall 1544 Aug 20 21:00 hc_athena.dat
-rw-r--r-- 1 oracle oinstall 1007 Aug 20 20:22 initathena.ora
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r- 1 oracle oinstall 24 Oct 25 2013 lkATHENA
-rw-r- 1 oracle oinstall 1536 Oct 25 2013 orapwathena
-rw-r- 1 oracle oinstall 9748480 Jul 8 23:07 snapcf_athena.f
-rw-r- 1 oracle oinstall 3584 Aug 20 21:00 spfileathena.ora
[oracle@athena dbs] $cat spfileathena.ora
C "? Vu3CC" aathena.__db_cache_size=197132288
Athena.__java_pool_size=4194304
Athena.__large_pool_size=4194304
Athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
Athena.__pga_aggregate_target=335544320
Athena.__sga_target=503316480
Athena.__shared_io_pool_size=0
Athena.__shared_pool_size=289406976
Athena.__streams_pool_size=0
* .audit_file_dest='/s01/oracle/admin/athena/adump'
* .audit_trail='db'
* .compatible='11.2.0.0.0'
* .ctlUniverse "> / s01Universe Universe fastening fastening recoveryActionaUniverse control02.ctllemagenatives01byoraclelemadataUniverse control_files='/s01/oracle/oradata/athena/control01.ctl','CC" > / s01aporacleUniplicasedbyfastfastening oracleUniplicatareaUniverse control 04.ctl'
* .db_block_size=8192
* .db_domain=''
* .db_name='athena'
* .db_recovery_file_dest='/s01/oracle/fast_recovery_area'
* .db_recovery_file_dest_size=4322230272
* .diagnostic_dest='/s01/oracle'
* .dispatchers=' (PROTOCOL=TCP) (SERVICE=athenaXDB)'
* .memory_target=838860800
* .open_cursors=300
* .processes=850
* .remote_login_passwordfile='EXCLUSIVE'
* .girls = 94CC "610 0
* .undo_tablespace='UNDOTBS1'
CC "FeCC" EeCC "DeC [oracle@athena dbs] $Xshell
Bash: Xshell: command not found
[oracle@athena dbs] $sqlplus / nolog
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 21:00:51 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL > conn / as sysdba
Connected.
SQL > col name for A60
SQL > select * from v$controlfile
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
/ s01/oracle/oradata/athena/control01.ctl NO 16384 594
/ s01/oracle/fast_recovery_area/athena/control02.ctl NO 16384 594
/ s01/oracle/oradata/athena/control03.ctl NO 16384 594
/ s01/oracle/oradata/athena/control04.ctl NO 16384 594
SQL >
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.
12
Report
