以上就是给各位分享HowtoAddtheJVMComponenttoanExistingOracleDatabase，同时本文还将给你拓展68.YouaremanaginganOracleDataba
以上就是给各位分享How to Add the JVM Component to an Existing Oracle Database，同时本文还将给你拓展68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database、73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO、78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R、81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,等相关知识，如果能碰巧解决你现在面临的问题，别忘了关注本站，现在开始吧！
本文目录一览：- How to Add the JVM Component to an Existing Oracle Database
- 68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database
- 73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO
- 78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R
- 81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,
How to Add the JVM Component to an Existing Oracle Database
Applies to: Oracle Server - Enterprise Edition - Version 11.2.0.1.0 and later Information in this document applies to any platform. This article details how to install the JVM in an existing Oracle11g Release 2 database. Goal Add the Oracl
Applies to:
Oracle Server - Enterprise Edition - Version 11.2.0.1.0 and laterInformation in this document applies to any platform.
This article details how to install the JVM in an existing Oracle11g Release 2 database.
Goal
add the oracle jvm component to an existing oracle database or instance.
As with all destructive actions, Oracle Corporation strongly advises taking a FULL COLD BACKUP of the database before these actions are performed.
Fix
There are two options:
Option 1. Add the Oracle JVM component using the Database Configuration Assistant Utility
a. Start the Database Configuration Assistant and Click Next at the Welcome screen.
b. Choose the option to configure a database. Click Next
c. Select the database service name to configure. Click Next
c. Click the Button labeled "Standard Database Components" and check or enable the box "Oracle JVM". Click Ok.
d. Click Next and then Finish to complete the action.
Option 2. Manually Add the JVM Component by executing the initjvm.sql script.
The following steps need to be executed precisely as listed below to ensure that they complete successfully:
a. Verify the following system requirements are available:
The Shared Pool has at least 96Mb of free space.
The Java Pool has at least 50Mb of free space
The SYSTEM tablespace has at least 70Mb of free space
The SYSTEM RBS has at least 100Mb of free space
The initjvm.sql script in 11g will check these resources are available when it is run, and if they aren''t available the execution of the script will terminate with an error indicating which resource needs to be increased.
b. Shutdown the instance and then create and run the following sql script from a new sqlplus session:
-- Start of File full_jvminst.sql
spool full_jvminst.log;
set echo on
connect / as sysdba
startup mount
alter system set "_system_trig_enabled" = false scope=memory;
alter database open;
select obj#, name from obj$
where type#=28 or type#=29 or type#=30 or namespace=32;
@?/javavm/install/initjvm.sql
select count(*), object_type from all_objects
where object_type like ''%JAVA%'' group by object_type;
@?/xdk/admin/initxml.sql
select count(*), object_type from all_objects
where object_type like ''%JAVA%'' group by object_type;
@?/xdk/admin/xmlja.sql
select count(*), object_type from all_objects
where object_type like ''%JAVA%'' group by object_type;
@?/rdbms/admin/catjava.sql
select count(*), object_type from all_objects
where object_type like ''%JAVA%'' group by object_type;
@?/rdbms/admin/catexf.sql
select count(*), object_type from all_objects
where object_type like ''%JAVA%'' group by object_type;
shutdown immediate
set echo off
spool off
exit
-- End of File full_jvminst.sql
c. Once the database has been restarted, resolve any invalid objects.
This can be performed by running the utlrp.sql script e.g.:
@?/rdbms/admin/utlrp.sql
68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database
68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task? A.Multiplex all database files. B.Configure the Flash Recovery Area. C.Configure the database instance for ARCHIVELOG mode. D.Configure the FAST_START_MTTR_TARGET initialization parameter. 答案：C 解析：这个说是恢复到错误发生的时间点,这个相当于不完全恢复，不完全恢复的先觉条件是@R_301_6250@处于归档模式 当@R_301_6250@设置为归档模式之后对@R_301_6250@意味着 1.当@R_301_6250@(磁盘或系统文件问题所导致的)崩溃之后，所有提交的数据都能恢复 2.可以对@R_301_6250@进行联机备份，而且在联机备份期间可以继续进行其他的操作 3.当某一非系统表空间脱机时，@R_301_6250@的其他部分继续正常工作 4.可以进行如下的不完全恢复 a.恢复到某一特定的时间点 b.恢复到某一特定的scn号 c.恢复到某一特定的归档文件的结尾
73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO
73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.) A.You must shut down the database instance to perform the backups. B.You must configure the Flash Recovery Area (FRA) for the database. C.You can perform complete database backups without closing the database. D.All the prevIoUs closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode. 答案：CD 解析： A.归档模式后，备份不需要关闭数据库，属于热备，因此A是错误的，当然也可以关闭进行一致性备份，但不是必须关闭数据库 B.fra默认路径为$ORACLE_BASE/fast_recovery_area,不需要费的配置，因此B也是错误的 C.正确，备份的时候，是备份了一个点，然后通过归档日志执行前滚实现了完全备份 D.正确，当打开归档后 sql> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 77 Next log sequence to archive 77 Current log sequence 79 这里的Current log sequence将会被重置为1，也就是之前的都变成了invalid
78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R
78.You are managing an Oracle Database 11g database. The database is open,and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.) A.The backups would be consistent. B.The backups would be inconsistent. C.The backups would be possible only if the database is running in ARCHIVELOG mode. D.The backups would be possible only if the database is running in NOARCHIVELOG mode. E.The backups need to be restored and the database has to be recovered in case of a media failure. 答案：BCE 解析：只要是open状态进行备份的都是不一致备份排除A rman在非归档模式下执行进行脱机备份也就是冷备，因此排除D E说的是介质有问题了，备份必须restore然后recovered，这里说一下restore和recover的区别 restore：从备份位置还原一个或者多个数据库文件 recover:应用归档和联机重做日志文件，将整个数据库或单独数据库文件前滚到指定的scn 这就是归档文件的作用，当执行备份的时候，只是备份到一个点的数据，但是在备份之后这段时间执行的数据，就需要 通过recover利用归档日志，来进行前滚实现，因此需要这两步
81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,
81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,level 0 backup is performed. - On Monday night and subsequent days,level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday's backup is true? A.The backup contains all the used blocks. B.The backup contains all the used and unused blocks. C.The backup contains blocks that have changed since the last level 0 backup. D.The backup contains blocks that have changed since the last level 1 backup taken last week. 答案：C 解析：参考80题，这个是1级Incremental Differential 备份，由于周日是0级，因此周1应该在周日的基础上进行 备份，选择C关于How to Add the JVM Component to an Existing Oracle Database的问题就给大家分享到这里，感谢你花时间阅读本站内容，更多关于68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database、73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO、78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R、81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,等相关知识的信息别忘了在本站进行查找喔。
本文标签：
