修改Oracle Java路径,oracle controlfile路径修改

最新推荐文章于 2023-04-17 10:41:23 发布
最新推荐文章于 2023-04-17 10:41:23 发布
阅读量173 收藏
点赞数
文章标签： 修改Oracle Java路径

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 -----spfileC"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'

*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC"

*.db_block_size=8192

*.db_domain=''

*.db_name='athena'

*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=10737418240

*.diagnostic_dest='/s01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'

*.log_archive_dest_1='location=/oracle/archive1/'

*.log_archive_format='arch_%d_%t_%r_%s.log'

*.memory_target=838860800

*.open_cursors=300

*.processes=850

*CC"ka.remote_login_passwordfile='EXCLUSIVE'

*.sessions=940

*.undo_tablespace='UNDOTBS1'

[oracle@athena dbs]$

[oracle@athena dbs]$ cd /s01/oracle/oradata/athena/

[oracle@athena athena]$ ll

total 5699580

-rw-r----- 1 oracle oinstall   89137152 Aug 20 20:12 chenjh.dbf

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:15 control01.ctl

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:15 control03.ctl

-rw-r----- 1 oracle oinstall  328343552 Aug 20 20:12 example01.dbf

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo01.log

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo02.log

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo03.log

-rw-r----- 1 oracle oinstall  587210752 Aug 20 20:12 sysaux01.dbf

-rw-r----- 1 oracle oinstall  744497152 Aug 20 20:12 system01.dbf

-rw-r----- 1 oracle oinstall   30416896 Jun 23 21:54 temp01.dbf

-rw-r----- 1 oracle oinstall   99622912 Aug 20 20:12 undotbs01.dbf

-rw-r----- 1 oracle oinstall 3803717632 Aug 20 20:12 users01.dbf

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ho

[oracle@athena athena]$ cd /s01/oracle/oradata/athena/

[oracle@athena athena]$ ll

total 5699580

-rw-r----- 1 oracle oinstall   89137152 Aug 20 20:16 chenjh.dbf

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control01.ctl

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control03.ctl

-rw-r----- 1 oracle oinstall  328343552 Aug 20 20:16 example01.dbf

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo01.log

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:16 redo02.log

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo03.log

-rw-r----- 1 oracle oinstall  587210752 Aug 20 20:16 sysaux01.dbf

-rw-r----- 1 oracle oinstall  744497152 Aug 20 20:16 system01.dbf

-rw-r----- 1 oracle oinstall   30416896 Jun 23 21:54 temp01.dbf

-rw-r----- 1 oracle oinstall   99622912 Aug 20 20:16 undotbs01.dbf

-rw-r----- 1 oracle oinstall 3803717632 Aug 20 20:16 users01.dbf

[oracle@athena athena]$cp control01.ctl control04.ctl-----------增加控制文件[oracle@athena athena]$ ll

total 5709116

-rw-r----- 1 oracle oinstall   89137152 Aug 20 20:16 chenjh.dbf

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control01.ctl

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control03.ctl

-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control04.ctl

-rw-r----- 1 oracle oinstall  328343552 Aug 20 20:16 example01.dbf

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo01.log

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:16 redo02.log

-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo03.log

-rw-r----- 1 oracle oinstall  587210752 Aug 20 20:16 sysaux01.dbf

-rw-r----- 1 oracle oinstall  744497152 Aug 20 20:16 system01.dbf

-rw-r----- 1 oracle oinstall   30416896 Jun 23 21:54 temp01.dbf

-rw-r----- 1 oracle oinstall   99622912 Aug 20 20:16 undotbs01.dbf

-rw-r----- 1 oracle oinstall 3803717632 Aug 20 20:16 users01.dbf

[oracle@athena 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:16 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]$ vi spfileathena.ora

[oracle@athena dbs]$ vi spfileathena.ora

[oracle@athena dbs]$ cat init.ora

#

# $Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $

#

# Copyright (c) 1991, 1997, 1998 by Oracle Corporation

# NAME

#   init.ora

# FUNCTION

# NOTES

# MODIFIED

#     ysarig     05/14/09  - Updating compatible to 11.2

#     ysarig     08/13/07  - Fixing the sample for 11g

#     atsukerm   08/06/98 -  fix for 8.1.

#     hpiao      06/05/97 -  fix for 803

#     glavash    05/12/97 -  add oracle_trace_enable comment

#     hpiao      04/22/97 -  remove ifile=, events=, etc.

#     alingelb   09/19/94 -  remove vms-specific stuff

#     dpawson    07/07/93 -  add more comments regarded archive start

#     maporter   10/29/92 -  Add vms_sga_use_gblpagfile=TRUE

#     jloaiza    03/07/92 -  change ALPHA to BETA

#     danderso   02/26/92 -  change db_block_cache_protect to _db_block_cache_p

#     ghallmar   02/03/92 -  db_directory -> db_domain

#     maporter   01/12/92 -  merge changes from branch 1.8.308.1

#     maporter   12/21/91 -  bug 76493: Add control_files parameter

#     wbridge    12/03/91 -  use of %c in archive format is discouraged

#     ghallmar   12/02/91 -  add global_names=true, db_directory=us.acme.com

#     thayes     11/27/91 -  Change default for cache_clone

#     jloaiza    08/13/91 -         merge changes from branch 1.7.100.1

#     jloaiza    07/31/91 -         add debug stuff

#     rlim       04/29/91 -         removal of char_is_varchar2

#   Bridge     03/12/91 - log_allocation no longer exists

#   Wijaya     02/05/91 - remove obsolete parameters

#

##############################################################################

# Example INIT.ORA file

#

# This file is provided by Oracle Corporation to help you start by providing

# a starting point to customize your RDBMS installation for your site.

#

# NOTE: The values that are used in this file are only intended to be used

# as a starting point. You may want to adjust/tune those values to your

# specific hardware and needs. You may also consider using Database

# Configuration Assistant tool (DBCA) to create INIT file and to size your

# initial set of tablespaces based on the user input.

###############################################################################

# Change '' to point to the oracle base (the one you specify at

# install time)

db_name='ORCL'

memory_target=1G

processes = 150

audit_file_dest='/admin/orcl/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='/flash_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest=''

dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'

open_cursors=300

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

# You may want to ensure that control files are created on separate physical

# devices

control_files = (ora_control1, ora_control2)

compatible ='11.2.0'

[oracle@athena dbs]$ ll

total 9560

-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:16 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

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]$ vi initathena.ora

[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:22:40 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup initathena.ora

SP2-0714: invalid combination of STARTUP options

SQL> ho

[oracle@athena dbs]$ ll

total 9560

-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:16 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 20:12 spfileathena.ora

[oracle@athena dbs]$ pwd

/s01/oracle/proudct/11.2.0.1/db_home1/dbs

[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:24:21 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora';

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> 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> ho

[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:27:33 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> 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/oradata/athena/control03.ctl       NO       16384        594

/s01/oracle/fast_recovery_area/athena/control02.ctl      NO       16384        594

SQL> ho

[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:45:53 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> create spfile from pfile;

create spfile from pfile

*

ERROR at line 1:

ORA-32002: cannot create SPFILE already being used by the instance

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora';---默认从pfile启动

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

ORA-00214: control file '/s01/oracle/oradata/athena/control01.ctl' version 2617 inconsistent with file '/s01/oracle/oradata/athena/control04.ctl' version 2602------版本不对，原因是复制控制文件的时候数据库没有关闭

SQL> ho

[oracle@athena dbs]$ cd /s01/oracle/oradata/athena/

[oracle@athena athena]$ cp control01.ctl control04.ctl;

[oracle@athena athena]$ sqplus /nolog

bash: sqplus: command not found

[oracle@athena athena]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:48:46 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> startup^H^H

SP2-0714: invalid combination of STARTUP options

SQL> startup pfile=''/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'

LRM-00109: could not open parameter file ''/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'

ORA-01078: failure in processing system parameters

SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'

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> 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

c[oracle@athena athena]$ cd $ORACLE_HOME

[[oracle@athena dbs]$ ll

total 9560

-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:50 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 20:50 spfileathena.ora

[oracle@athena dbs]$ cat spfileathena.ora

C"y!$s3CC"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'

*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC"

*.db_block_size=8192

*.db_domain=''

*.db_name='athena'

*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=10737418240

*.diagnostic_dest='/s01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'

*.log_archive_dest_1='location=/oracle/archive1/'

*.log_archive_format='arch_%d_%t_%r_%s.log'

*.memory_target=838860800

*.open_cursors=300

*.processes=850

*CC"ka.remote_login_passwordfile='EXCLUSIVE'

*.sessions=940

*.undo_tablespace='UNDOTBS1'

CC"FeCC"EeCC"DeC[oracle@athena dbs]$ Xshell

bash: Xshell: command not found

[oracle@athena dbs]$

[oracle@athena dbs]$ ll

total 9560

-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:50 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 20:50 spfileathena.ora

[oracle@athena dbs]$ cat initathena.ora

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','/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/oradata/athena/control04.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]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:51:31 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> sl

SP2-0042: unknown command "sl" - rest of line ignored.

SQL> select * from v$controlfile;

STATUS NAME            IS_ BLOCK_SIZE FILE_SIZE_BLKS

------- ------------------------------------------------------------ --- ---------- --------------

/s01/oracle/oradata/athena/control01.ctl       NO       16384        594

/s01/oracle/oradata/athena/control03.ctl       NO       16384        594

/s01/oracle/fast_recovery_area/athena/control02.ctl      NO       16384        594

SQL> create spfile from pfile;

create spfile from pfile

*

ERROR at line 1:

ORA-32002: cannot create SPFILE already being used by the instance

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'

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

ORA-00214: control file '/s01/oracle/oradata/athena/control01.ctl' version 2647 inconsistent with file '/s01/oracle/oradata/athena/control04.ctl' version 2632

SQL> ho

[oracle@athena dbs]$ shutdown immediate;

bash: shutdown: command not found

[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:55:31 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> ho

[oracle@athena dbs]$ cd $ORACLE_HOME

[oracle@athena db_home1]$ cd dbs/

[oracle@athena dbs]$ ls

hc_athena.dat  initathena.ora  init.ora  lkATHENA  orapwathena  snapcf_athena.f  spfileathena.ora

[oracle@athena dbs]$ cd ~

[oracle@athena ~]$ cd ..

[oracle@athena home]$ cd oracle/

[oracle@athena ~]$ ll

total 0

[oracle@athena ~]$ cd/s01

bash: cd/s01: No such file or directory

[oracle@athena ~]$ cd /s01/

controlbak.txt  oracle/         oraInventory/

[oracle@athena ~]$ cd /s01/oracle/oradata/

[oracle@athena oradata]$ ll

total 4

drwxr-x--- 2 oracle oinstall 4096 Aug 20 20:16 athena

[oracle@athena oradata]$ cd athena/

[oracle@athena athena]$ cp control01.ctl control04.ctl

[oracle@athena athena]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:57:21 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba;

Connected to an idle instance.

SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'

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> SQL> create spfile from pfile;

File created.

SQL> ho

c[oracle@athena 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:58 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 20:58 spfileathena.ora

[oracle@athena dbs]$ cat spfileathena.ora

C"??u3CC"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'

*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC">/s01/oracle/fast_recovery_area/athena/control02.ctl','/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/oradata/athena/control04.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=94CC"6,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'

*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC">/s01/oracle/fast_recovery_area/athena/control02.ctl','/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/oradata/athena/control04.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=94CC"6,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>

weixin_39980234
关注
Oracle SQL Developer修改错误JDK路径
Just do it!
11-26 1万+
问题   安装好Oracle11g后，第一次使用 Oracle SQL Developer，会提示选择JDK路径。选择了本机的JDK1.8路径，但是出现闪退的问题，无法进入Oracle SQL Developer。 解决方案   Oracle SQL Developer选择的JDK应该是Oracle安装目录下的product\11.2.0\dbhome_1\jdk路径，而不是我们自
oracle安装java路径_Oracle SQL Developer的JDK安装的完整路径名
weixin_42467374的博客
02-27 1274
问题描述我想用这个命令在Ubuntu上运行Oracle SQL Devloper：sh sqldeveloper/sqldeveloper.sh然后我收到了这条消息：Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/aimad/.sqldevelo...
oracle的java路径,oracle学习----访问路径
weixin_29571873的博客
04-05 196
什么是访问路径？表扫描数据的时候使用了什么方式，这个方式就是访问路径1.全表扫描TABLE ACCESS FULL 全表扫描，多块读，等待事件：db file scattered read如果是并行全表扫描，等待事件： direct path read11g 有个新特征，在进行全表扫描的时候也会产生 direct path read在OLTP环境中要通过 10949 event 禁止该新特征在OL...
更改Oracle数据文件、控制文件、日志文件位置
wky1709的专栏
01-16 868
关于更改Oracle数据文件(包括系统数据文件)位置，网上的方法很多，但我是初学者，理解不够透彻，测试的时候急于求成，以至于试验多次才成功，原因是没有注意顺序，在此总结一下，错误之处请 多包涵，也请高手多指教。过程其实很简单。 环境win2003+Oracle10 数据文件变更前：C:\ORACLE\PRODUCT\10.2.0\ORADATA\ELE\ 数据文件变更后：D:\OR
oracle修改日志文件位置,更改Oracle数据文件、控制文件、日志文件位置
weixin_35941591的博客
04-05 696
关于更改Oracle数据文件(包括系统数据文件)位置，网上的方法很多，但我是初学者，理解不够透彻，测试的时候急于求成，以至于试验多次才成功，原因是没有注意顺序，在此总结一下，错误之处请 多包涵，也请高手多指教。过程其实很简单。 环境win2003+Oracle10 数据文件变更前：C:\ORACLE\PRODUCT\10.2.0\ORADATA\ELE\ 数据文件变更后：D:\ORA_...
oracle创建物理路径,ORACLE DUPLICATE创建物理standby数据库
weixin_33438788的博客
04-02 674
一、创建物理standby数据库1.利用duplicate命令创建物理standby数据库的Oracle官方的三点说法：a.duplicate命令创建物理standby数据库，是通过Primary数据库的备份进行，因此不会对primary有影响b.duplicate命令支持以OMF方式管理文件以及路径结构c.duplicate命令支持在恢复过程中自动执行recover，尽可能保持standby数据...
oracle修改数据文件存储位置,oracle 修改数据库文件位置
weixin_42525106的博客
04-04 1671
Oracle 体系结构Oracle 服务器如图所示：由oracle实例(INSTANCE)和数据库(database)组成。1) Instance 实例用于管理和调用数据库，是由oracle系统启动时在内存中分配的系统全局区(system global area：SGA)和后台所运行的oracle...文章余二五2017-11-22809浏览量修改oracle数据库的名字最近闲来无事，决定修改一下...
Oracle数据库1
08-08
当安装了32位JDK后，我们需要手动编辑`sqldeveloper.conf`文件来指定正确的java.exe路径，以确保SQL Developer正常运行。 此外，我们学习了如何在SQL*Plus中调整显示设置，如`SET LINESIZE 200`用于设置每行显示的...
oracle 11g DG 物理搭建 DG切换模式
qq_40195937的博客
11-10 1491
oracle 11g DG 物理搭建 DG切换模式
networker for ORACLE备份与异机恢复
07-21
- 设置环境变量，如`JAVA_HOME`、`HOME`、`ORACLE_HOME`等。 - 配置软链接以指向库文件，例如`ln -s /usr/lib/libnwora.so libobk.so`。 ##### 2.2 配置 Oracle 数据库 1. **开启日志归档模式**： - 使用管理员...
JDK和ORACLE JDK冲突修改环境变量
03-27
JDK和ORACLE JDK冲突修改环境变量
oracle java 路径_Oracle安装目录及主要文件介绍
weixin_39877050的博客
02-16 638
C:\oracle目录是Oracle数据库服务器安装后的目录：1、admin目录：该文件夹下按照数据库系统标识符名称建立子文件夹，在每个子文件夹下存放对该数据库的管理信息和日志文件，是数据库管理员分析数据库、查找历史记录的地方。2、ora90：存放的是整个数据库服务器的程序文件。3、oradata：该文件夹下面是按照数据库系统标识符名称建立子文件夹，存放某个数据库的数据文件、控制文件、索引文件等，...
Java的API在oracle中的查询路径
mengxiang_的博客
08-10 802
最近发现Java文档，还是看官方的逻辑会更清晰一些。而最权威则是oracle里的API文档。但是网站的更新，会导致查询的路径不同，就直接说一下查询的方法。今天的内容就到这里，如果有什么问题，欢迎留言~5、最常用的API是Java.lang中。6、可以看到各种类和接口得到解释。1、先进入oracle文档界面。4、点击Java.base。点击Java这个大的选项。7、以Boolean为例。...
Ubuntu tomcat7+Java-8-oracle 设置 JDK 路径
seafit的专栏
08-12 1060
If you are a newbie like me, you might have the same problem as me when you wanted to start the tomcat7 on ubuntu: no JDK found - please set JAVA_HOME Make sure the JAVA_HOME is set properly: if i
java链接数据库oracle数据库文件路径,Java连接Oracle数据库
weixin_35218304的博客
04-04 505
要将Java应用程序与oracle数据库连接, 我们需要执行以下5个步骤。在此示例中, 我们使用Oracle 10g作为数据库。因此, 我们需要了解oracle数据库的以下信息：驱动程序类：oracle数据库的驱动程序类是oracle.jdbc.driver.OracleDriver。连接URL：oracle10G数据库的连接URL为jdbc：oracle：thin：@localhost：1521...
oracle自带的jdk,ubuntu 替换原本自带的oracle-jdk
weixin_35651471的博客
04-06 206
解压 安装自己的jdk例 jdk1.8.0_131sudo vim /etc/profile## 加入自己的环境变量javaexport JAVA_HOME=/home/panda/software/jdk/jdk1.8.0_131export JRE_HOME=${JAVA_HOME}/jreexport CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib终...
Linux 修改默认jdk为oracle
张林强的专栏
12-24 783
因~/.bashrc~/.profile中设置的环境变量仅在shell中生效，桌面系统双击执行，或者由exec命令执行的脚本无法读到这些环境变量。以下方式为网络搜集： 解决方式1：安装openjdk，会全局应用，不过最新版Ubuntu使用openjdk-10部分老工程可能会出现兼容问题 解决方式2：将oracle-jdk安装到系统中，具体方式： #1.安装oracle jdk到系统，/hom...
windows 安装 Oracle Java环境
最新发布
qq_40615333的博客
04-17 1459
前言：公司有个app的项目，我是打算使用uniapp来实现，那么调试是需要使用到java环境，所以我本地就得安装java环境，接着我找了好多文章发现没有相对完整的，所以我想在这里整合一下，写一遍傻瓜式操作的记录一下，这样大家安装的时候也可以少走点弯路。
oracle数据库设置 jdk,从jdk安装到jsp连接oracle数据库的相关配置
weixin_42317115的博客
04-03 165
1.安装jdk(版本6u7);2.配置jdk环境变量(安装目录:D:/tools/java/jdk1.6.0_07):1). JAVA_HOME = D:/tools/java/jdk1.6.0_07;2). Path的最前面追加"D:/tools/java/jdk1.6.0_07/bin;D:/tools/java/jre1.6.0_07/bin";3). CLASSPATH = D:/tool...
Oracle9i数据文件、日志及控制文件存储路径更改教程
"这篇资料介绍了如何在Oracle 9i数据库中更改数据文件、日志文件和控制文件的存储路径，提供了详细的SQL命令步骤。" 在Oracle数据库管理中，有时需要改变数据文件、日志文件和控制文件的存储位置，以满足磁盘空间...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值