doc oracle_doc窗口运行oracle - CSDN
精华内容
参与话题
  • oracle 官方doc

    2013-11-29 16:21:59
    http://docs.oracle.com/cd/B28359_01/server.111/b28310/schedadmin002.htm#ADMIN12036
    http://docs.oracle.com/cd/B28359_01/server.111/b28310/schedadmin002.htm#ADMIN12036
    展开全文
  • oracle 实例关闭的情况下,Oracle 软件从10.2.0.1 升级到 10.2.0.5 之后,存在的数据库也要升级。 此时启动实例会报错 ORA-01092: ORACLE instance terminated. Disconnection forced SQL> alter database open;...

    ********************************************************************
    ** 欢迎转发,注明原文:blog.csdn.net/clark_xu   徐长亮的专栏
    ** 谢谢您的支持,欢迎关注微信公众号:clark_blog 
    ********************************************************************

    oracle 实例关闭的情况下,Oracle 软件从10.2.0.1升级到 10.2.0.5之后,存在的数据库也要升级。

    此时启动实例会报错 ORA-01092: ORACLE instance terminated. Disconnection forced

    SQL> alter database open;

    ERROR at line 1:

    ORA-01092: ORACLE instance terminated. Disconnection forced

    第一步,通过startup upgrade启动实例

    SQL> startup upgrade;

    ORACLE instance started.

    Total System Global Area 322961408 bytes

    Fixed Size             2095992 bytes

    Variable Size               100664456 bytes

    Database Buffers     213909504 bytes

    Redo Buffers                6291456 bytes

    Database mounted.

    Database opened.

     

    第二步,升级数据字典和实例等

    SQL>@ORACLE_HOME\rdbms\admin\catupgrd.sql

    整个过程需要15分钟至30分钟左右

    升级完毕显示如下:

    Oracle Database 10.2 Upgrade Status Utility          09-11-2014 21:48:21

    Component                               Status         Version  HH:MM:SS

    Oracle Database Server                   VALID      10.2.0.5.0  00:15:41

    JServer JAVA Virtual Machine             VALID      10.2.0.5.0  00:06:46

    Oracle XDK                               VALID      10.2.0.5.0  00:00:51

    Oracle Database Java Packages            VALID      10.2.0.5.0  00:00:45

    Oracle Text                              VALID      10.2.0.5.0  00:01:07

    Oracle XML Database                      VALID      10.2.0.5.0  00:03:26

    Oracle Workspace Manager                 VALID      10.2.0.5.0  00:01:21

    Oracle Data Mining                       VALID      10.2.0.5.0  00:00:39

    OLAP Analytic Workspace                  VALID      10.2.0.5.0  00:00:48

    OLAP Catalog                             VALID      10.2.0.5.0  00:02:01

    Oracle OLAP API                          VALID      10.2.0.5.0  00:02:01

    Oracle interMedia                        VALID      10.2.0.5.0  00:06:35

    Spatial                                  VALID      10.2.0.5.0  00:04:50

    Oracle Expression Filter                 VALID      10.2.0.5.0  00:00:30

    Oracle Enterprise Manager                VALID      10.2.0.5.0  00:02:59

    Oracle Rule Manager                      VALID      10.2.0.5.0  00:00:18

    .

    Total Upgrade Time: 00:53:47

    DOC>#######################################################################

    DOC>#######################################################################

    DOC>

    DOC>  The above PL/SQL lists the SERVER components in the upgraded

    DOC>  database, along with their current version and status.

    DOC>

    DOC>  Please review the status and version columns and look for

    DOC>  any errors in the spool log file.  If there are errors in the spool

    DOC>  file, or any components are not VALID or not the current version,

    DOC>  consult the Oracle Database Upgrade Guide for troubleshooting

    DOC>  recommendations.

    DOC>

    DOC>  Next shutdown immediate, restart for normal operation, and then

    DOC>  run utlrp.sql to recompile any invalid application objects.

    DOC>

    DOC>#######################################################################

    DOC>#######################################################################

    DOC>#

     

    第三步,shutdown实例。Startup实例

    第四步,再次编译无效的应用对象

    SQL> @?/rdbms/admin/utlrp.sql

    TIMESTAMP

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

    COMP_TIMESTAMP UTLRP_BGN 2014-09-11 21:52:02

    DOC>  The following PL/SQL block invokes UTL_RECOMP to recompile invalid

    DOC>  objects in the database. Recompilation time is proportional to the

    DOC>  number of invalid objects in the database, so this command may take

    DOC>  a long time to execute on a database with a large number of invalid

    DOC>  objects.

    DOC>

    DOC>  Use the following queries to track recompilation progress:

    DOC>

    DOC>  1. Query returning the number of invalid objects remaining. This

    DOC>     number should decrease with time.

    DOC>        SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

    DOC>

    DOC>  2. Query returning the number of objects compiled so far. This number

    DOC>     should increase with time.

    DOC>        SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;

    DOC>

    DOC>  This script automatically chooses serial or parallel recompilation

    DOC>  based on the number of CPUs available (parameter cpu_count) multiplied

    DOC>  by the number of threads per CPU (parameter parallel_threads_per_cpu).

    DOC>  On RAC, this number is added across all RAC nodes.

    DOC>

    DOC>  UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel

    DOC>  recompilation. Jobs are created without instance affinity so that they

    DOC>  can migrate across RAC nodes. Use the following queries to verify

    DOC>  whether UTL_RECOMP jobs are being created and run correctly:

    DOC>

    DOC>  1. Query showing jobs created by UTL_RECOMP

    DOC>        SELECT job_name FROM dba_scheduler_jobs

    DOC>           WHERE job_name like 'UTL_RECOMP_SLAVE_%';

    DOC>

    DOC>  2. Query showing UTL_RECOMP jobs that are running

    DOC>        SELECT job_name FROM dba_scheduler_running_jobs

    DOC>           WHERE job_name like 'UTL_RECOMP_SLAVE_%';

    DOC>#

     

    TIMESTAMP

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

    COMP_TIMESTAMP UTLRP_END 2014-09-11 21:53:40

    DOC> The following query reports the number of objects that have compiled

    DOC> with errors (objects that compile with errors have status set to 3 in

    DOC> obj$). If the number is higher than expected, please examine the error

    DOC> messages reported with each object (using SHOW ERRORS) to see if they

    DOC> point to system misconfiguration or resource constraints that must be

    DOC> fixed before attempting to recompile these objects.

    DOC>#

     

    OBJECTS WITH ERRORS

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

                     0

    DOC> The following query reports the number of errors caught during

    DOC> recompilation. If this number is non-zero, please query the error

    DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors

    DOC> are due to misconfiguration or resource constraints that must be

    DOC> fixed before objects can compile successfully.

    DOC>#

     

    ERRORS DURING RECOMPILATION

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

                             0

    SQL>

    展开全文
  • Oracle多表联查分页数据重复出现

    千次阅读 2017-11-22 17:10:43
    使用Oracle的分页语句进行分页,第一页,没问题,第二页出现重复数据: 第一页的数据: SELECT * FROM ( SELECT u.*, rownum AS r FROM ( SELECT configs.VIDEOSERVICE, configs.VOICESERVICE, configs.IMAGE...

    一、问题描述


    使用Oracle的分页语句进行分页,第一页,没问题,第二页出现重复数据:


    第一页的数据:

    SELECT *
    FROM (
    	SELECT u.*, rownum AS r
    	FROM (
    		SELECT configs.VIDEOSERVICE, configs.VOICESERVICE, configs.IMAGESERVICE, doc.id AS docid, doc.name AS docname
    			, doc.begood, rice.graphicprice, rice.speechprice, rice.videoprice, chart.titleName
    			, hpath.FTPURL || doc.PHOTOID AS ftpurl, luate.score
    		FROM HEALTHDOCTOR doc
    		LEFT JOIN HealthServiceConfig configs ON doc.id = configs.docid 
    		LEFT JOIN HEALTHPRICE rice ON doc.id = rice.docid 
    		LEFT JOIN healthTitleChart chart ON doc.titlecode = chart.TITLECODE 
    		LEFT JOIN HEALTHFTPPATH hpath ON doc.PATHCODE = hpath.PATHCODE 
    		LEFT JOIN (
    			SELECT round(AVG(score), 1) AS score, docid
    			FROM healthevaluate
    			GROUP BY docid
    		) luate ON doc.id = luate.docid 
    			LEFT JOIN (
    				SELECT COUNT(*) AS ordersum, docid
    				FROM HealthyOrder
    				GROUP BY docid
    			) orders ON doc.id = orders.docid 
    		WHERE rice.GRAPHICPRICE >= 0
    	) u
    	WHERE rownum < 13
    )
    WHERE r >= 1



    第二页的数据:

    SELECT *
    FROM (
    	SELECT u.*, rownum AS r
    	FROM (
    		SELECT configs.VIDEOSERVICE, configs.VOICESERVICE, configs.IMAGESERVICE, doc.id AS docid, doc.name AS docname
    			, doc.begood, rice.graphicprice, rice.speechprice, rice.videoprice, chart.titleName
    			, hpath.FTPURL || doc.PHOTOID AS ftpurl, luate.score
    		FROM HEALTHDOCTOR doc
    		LEFT JOIN HealthServiceConfig configs ON doc.id = configs.docid 
    		LEFT JOIN HEALTHPRICE rice ON doc.id = rice.docid 
    		LEFT JOIN healthTitleChart chart ON doc.titlecode = chart.TITLECODE 
    		LEFT JOIN HEALTHFTPPATH hpath ON doc.PATHCODE = hpath.PATHCODE 
    		LEFT JOIN (
    			SELECT round(AVG(score), 1) AS score, docid
    			FROM healthevaluate
    			GROUP BY docid
    		) luate ON doc.id = luate.docid 
    			LEFT JOIN (
    				SELECT COUNT(*) AS ordersum, docid
    				FROM HealthyOrder
    				GROUP BY docid
    			) orders ON doc.id = orders.docid 
    		WHERE rice.GRAPHICPRICE >= 0 
    	) u
    	WHERE rownum < 25
    )
    WHERE r >= 13



    第一页和第二页有数据重复了,排序有问题。


    二、解决方法


    在最外层加个"order by id"其中这个id是主键就行了:



    展开全文
  • oracle 创建用户进行登录

    千次阅读 2018-02-05 09:22:49
    oracle只有一个数据库叫orcl, ip地址 数据库名称也叫sid:oracle 帐号用户名 密码 示例帐号 scott/tiger 使用cmd 打开doc 窗口。输入sqlplus /nolog登录进去就是sys用户,管理system用户 conn /as ...
    oracle只有一个数据库叫orcl,


    ip地址
    数据库名称也叫sid:oracle
    帐号用户名
    密码


    示例帐号 scott/tiger

    使用cmd 打开doc 窗口。输入sqlplus /nolog登录进去就是sys用户,管理system用户

    conn /as sysdba 让sys拥有dba权限


    修改system密码
    alter user system identified by oracle;


    conn system/oracle 以正常的超级用户身份登录进去


    自己建帐号需要建表空间
    create tablespace t1 datafile 't1.dbf' size 10m autoextend on;


    建完表空间再建用户test 密码123456
    create user test identified by 123456 default tablespace t1;


    用户要分配权限(创建表,修改表,增删改查)
    连接权限connect
    资源权限resource


    grant connect to test;
    grant resource to 123456;


    conn test/123456;
    展开全文
  • Oracle EBS Documents

    千次阅读 多人点赞 2014-10-07 02:27:01
    EBSGuideOracle® Applications Flexfields Guide Release 12Oracle® ApplicationsFlexfields Guide Release 11Oracle® Applications ConceptsRelease 11i (11.5.10) Part No. B13892-01Oracle Applications ...
  • 按照这里的步骤 将 oracle客户端安装到Linux上即可, https://oracle.github.io/odpi/doc/installation.html#linux
  • oracle linux 下载地址

    千次阅读 2018-07-17 17:18:52
    https://community.oracle.com/docs/DOC-917963 http://mirrors.kernel.org/oracle/  https://blog.csdn.net/shaoyong_15/article/details/52164043
  • oracle database 10.2.0.4 升级到 10.2.0.5

    千次阅读 2012-11-22 21:38:14
    某发票开发测试库升级 升级前准备,此次升级只是很对测试环境数据库升级,所以没有事先一个月来获取系统,数据库的统计信息,机器性能比对 为了加快升级只是清理了以下信息 01.截断SYS.AUD$基表: ...
  • Oracle BI Publisher

    千次阅读 2013-07-14 08:30:31
    Oracle BI Publisher以前叫XML Publisher,这里'BI'为'Business Inteligence'Wiki:Oracle BI PublisherOracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally ...
  • Oracle BLOB内容批量导出

    千次阅读 2015-11-11 17:03:53
    将存储图片的BLOB字段批量导出--(1)生成图片存储过程 CREATE OR REPLACE PROCEDURE TMU_TMEDMS.GET_PIC_BLOB(i_xh VARCHAR2) IS l_file UTL_FILE.FILE_TYPE; l_buffer RAW(32767); l_amount BINARY_INTEGER := ...
  • 查看oracle客户端版本和位数 一、windows环境 (1)方法一:查看comps.xml文件 查看sqlplus的位置,打开doc界面后 where sqlplus D:\it\oracle\11\product\11.2.0\dbhome_1\BIN\sqlplus.exe 然后找到$ORACLE_HOME...
  • oracle-xe安装简单,卸载也很简单

    千次阅读 2012-06-02 10:15:16
    oracle-xe安装简单,卸载也很简单 [oracle@monitor u02]$ more remove-oracle-xe.sh #!/bin/bash /etc/init.d/oracle-xe stop rpm -e oracle-xe-univ rm -rf /etc/init.d/oracle-xe rm -rf /usr/lib/oracle rm -...
  • Oracle中的口令管理

    万次阅读 2015-02-02 11:54:34
    1.Oracle中的各个用户如下: 0.数据库统一管理账号:orcl 1.普通用户:用户名:scott,密码:scott 2.普通管理员:system,密码:system 3.超级管理员:用户名:sys,密码:sys 2.为了便于记忆,用户名和密码一样 2....
  • startup migrate=> Used to upgrade a database till 9i.See the step 11 from the 9.2 manual upgrade guide :http://download-east.oracl
  • oracle数据类型和对应的java类型

    万次阅读 2014-02-03 21:18:40
    http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/java.102/B19275-03/datacc.htm#BHCJBJCC SQLデータ型 JDBC型コード 標準Java型 Oracle拡張機能Java型   標準JDBC 1.0型:
  • CVE-2015-4852 java 反序列化漏洞--weblogic补丁

    万次阅读 热门讨论 2018-09-25 13:12:19
    CVE-2015-4852 Patch Availability Document for Oracle WebLogic Server Component of Oracle Fusion Middleware (Doc ID 2075927.1) To Bottom APPLIES TO: PeopleSoft Enterprise PT Peo...
  • oracle 表结构全部导出方法

    万次阅读 2017-08-21 14:53:13
    使用DBExportDoc V1.0 For Oracle导出数据库表结构详细步骤   在网上查找到的,只有该工具的下载和一些基本的使用步骤,但是并未能介绍该...oracle.doc时,会弹出是否启用宏的对话框,这时需要选择是。如果是
  • 探索Oracle之数据库升级二  11.2.0.3 升级到11.2.0.4完整步骤   说明:  这篇文章主要是记录下单实例环境下Oracle 11.2.0.1 升级到11.2.0.3的过程,当然RAC的升级是会有所不同。但是他们每个版本之间升级步骤都是...
  • JAVA JDK API文档(帮助文档下载)

    千次阅读 2017-12-20 18:49:30
    JDK API文档 ...http://www.oracle.com/technetwork/java/javase/documentation/jdk8-doc-downloads-2133158.html   jdk-8-apidocs 在线版: http://docs.oracle.com/javase/8/docs/api/index.h
  • oracle10.2.0.1升级到10.2.0.4oracle10.2.0.1升级到10.2.0.4   环境: Windows Server2003 R2, 32位系统 Oracle 10g 版本:10.2.0.1 .0 补丁包:p6810189_10204_Win32   D:\>sqlplus /nolog   SQL*...
1 2 3 4 5 ... 20
收藏数 45,873
精华内容 18,349
关键字:

doc oracle