`
suxing
  • 浏览: 209109 次
  • 性别: Icon_minigender_1
  • 来自: 遵义
社区版块
存档分类
最新评论

oracl problems

 
阅读更多

If you change max memroy in oracle,must change 2 parameters floow:

ALTER SYSTEM SET MEMORY_MAX_TARGET = 1024M SCOPE = SPFILE;
ALTER SYSTEM SET MEMORY_TARGET = 1024M SCOPE = SPFILE;

 

ORA-32001: write to SPFILE requested but no SPFILE is in use
show parameter spfile;
create spfile from pfile;
shutdown immediate;
startup
http://hi.baidu.com/fujinwang/item/476907dfcc1b7af693a9742d
http://superlee0815.blog.163.com/blog/static/10575132120091585954516/


lrm-00109: could not open parameter file '/opt/oracle
将$ORACLE_BASE/admin /数据库名称/pfile目录下的init.ora.012009233838形式的文件copy到$ORACLE_HOME/dbs目录下 initoracle.ora即可
http://shuhui018125.blog.163.com/blog/static/7711050201012793636729/

分享到:
评论

相关推荐

    Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition

    Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition by Stelios Charalambides English | 8 May 2017 | ISBN: 1484224353 | 408 Pages | PDF | 24.39 MB Learn through this practical guide ...

    [Oracle] Oracle Spatial 应用扩展 (英文版)

    Understand how to develop Oracle Spatial data models and applications that use PL/SQL and Java to solve common problems using practical, hands-on examples Design a data model for spatial applications ...

    机器学习图像分类程序的蜕变测试框架.pdf

    However, since the testing of machine learning image classification programs faces test oracle problems, it will require a lot of manpower and material resources in the testing process. 在机器学习...

    Oracle Inequalities in Empirical Risk Minimization and Sparse Recovery Problems

    Oracle不等式在经验风险最小化和稀疏恢复问题中的应用是机器学习和统计学习理论中的一个重要研究领域。经验风险最小化(Empirical Risk Minimization, ERM)是机器学习中重要的概念,其基本思想是通过最小化训练数据...

    Expert Oracle Database Architecture 3rd

    If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised third edition covers the developments up...

    Troubleshooting Oracle Performance, 2nd Edition

    Oracle Database. Chapter 3, “Analysis of Reproducible Problems,” describes how to identify performance problems with the help of SQL trace and PL/SQL profilers. Chapter 4, “Real-time Analysis of ...

    Oracle-type posterior contraction rates in Bayesian inverse problems

    贝叶斯逆问题(Bayesian Inverse Problems)的核心思想是利用贝叶斯定理,结合先验知识和观测数据来推断未知参数的后验分布。其中,先验分布表达了在获得观测数据之前的不确定性,而似然函数则描述了观测数据出现的...

    Oracle OPC认证教程3.0.rar

    If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-...

    最完整的Toad For Oracle使用手册

    - **Diagnosing Problems**:介绍了诊断问题的方法。 - **View Extents**:提供了查看范围的方法。 - **Identify Space Deficits**:指导用户如何识别空间不足的问题。 - **Log Switch Frequency Map**:介绍了日志...

    Qt操作Oracle解决汉字乱码方案

    //uncomment this if you have problems with oracle character sets //#define QOCI_NO_CHARSET_CONVERSION ``` 2. **修改代码**: 将上述注释去掉,即取消`#define QOCI_NO_CHARSET_CONVERSION`的注释,这样...

    TroubleshootingOraclePerformance_2ndEdition

    “Performance Problems,” explains not only why it’s essential to approach performance problems at the right moment and in a methodological way, but also why understanding business needs and problems...

    Apress - Troubleshooting Oracle Performance, 2nd Edition

    Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian ...

    Expert Oracle Database Architecture 9i and 10g programming Techniques and Solutions

    One of the problems with having plenty of development options is that it’s sometimes hard to figure out which one might be the best choice for your particular needs. Everyone wants as much ...

    Oracle SQL Tuning with Oracle SQLTXPLAIN(Apress,2013)

    Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to ...

    oracle 1000

    "Oracle 1000"这个标题可能是指Oracle数据库在使用过程中可能遇到的一千个问题,而"Oracle has 1000 problems"描述则可能是对这些问题的概述,暗示了Oracle系统的复杂性和深度,同时也揭示了学习和掌握Oracle数据库...

    Apress.Expert.Oracle.Database.Architecture.2nd.Edition

    If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest ...

Global site tag (gtag.js) - Google Analytics