• 博客访问: 145034
  • 博文数量: 68
  • 用 户 组: 普通用户
  • 注册时间: 2008-05-04 11:19
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2010年(35)

2009年(32)

2008年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2010-05-19 16:57:44

Applies to: Oracle Server - Enterprise Edition - Version: 7.3 to 9.2Microsoft Windows NT Terminal ServerMicrosoft Windows (32-bit)Oracle database instance, listener, clients attempting to connect via the listener. GoalThis document covers how to troubleshoot when the following errors are thrown to the client when it tries to connect from a client to the db instance running on Windows OS, via the listener -TNS-12500: TNS:listener failed to start a dedicated server processTNS-12540: TNS:internal l......【阅读全文】

阅读(1025) | 评论(0) | 转发(0)

发布时间:2010-05-19 14:32:10

问题产生:C:Documents and Settingsz9600261>sqlplus /nologSQL*Plus: Release 8.1.6.0.0 - Production on 星期三 5月 19 14:05:09 2010(c) Copyright 1999 Oracle Corporation. All rights reserved.SQL> connect sys/sys@orcl2.ap.enpad.org as sysdbaERROR:ORA-01031: insufficient privileges问题分析:以上使用远程SYSDBA连接管理数据库 ,所以必须满足2个条件1:remote_login_passwordfile=true2:正确创建密码文件orapwd FILE=$ORACLE_HOME/dbs/orapworclpassword=sys entries=20文件名称必须规范:orapwdSID[@more@]......【阅读全文】

阅读(729) | 评论(0) | 转发(0)

发布时间:2010-04-27 11:27:51

... of the following errors: select output from table (dbms_workload_repository.awr_report_html (: Dbid, * ERROR at line 1: ORA-00904:: invalid identi . ...解决:sys用户授权grant all on dbms_workload_repository to perfstat;[@more@]......【阅读全文】

阅读(3778) | 评论(0) | 转发(0)

发布时间:2010-04-12 10:57:51

wallacel -- Thanks for the question regarding "design the table", version 8.1.6Submitted on 14-Feb-2001 19:27 Central time zoneTom's latest followup | Bookmark | BottomLast updated 16-Feb-2010 11:12You Asked Tom: when doing the database design , i have the following question. let's say we have emp table which have empid,empname,deptno, as well as empPicture, empGreeting, empFamilyPict. since we don't use empPicture , empGreeting( which is avi), empFamilypicture a lot, do you t......【阅读全文】

阅读(1150) | 评论(0) | 转发(0)

发布时间:2010-04-08 14:36:01

In this Document Purpose Scope and Application ORA-01555 "Snapshot too old" - Detailed Explanation Terminology ORA-01555 Explanation Solutions Examples Special Cases Summary ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 8.1.7.0Information in this document applies to any platform.Purpose@Checked for relevance on 16-MAY-2008This article will discuss the circumstances under which a query can return the Oracle error ORA-01555: snapshot too ......【阅读全文】

阅读(2128) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册