- 博客(8)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 DOS下里的sqlplus
问题描述：Host装的是oracle9i，以及oracle10g的developer suite，于是就有了一个DB的sqlplus，一个app的sqlplus。在运行里面：cmd -> sqlplus或者直接敲sqlplus，我输入9i的scott/tiger居然既不去，出现情况如下： 看来是Developer Suite的sqlplus将Oracle9i的sqlplus给覆盖了。于
2009-12-18 21:29:00
1807
原创 用户、权限、角色
简单表：dba_tablespaces：查看表空间名，类型，数据块大小等。database_properties：查看DB的所有属性等,eg.default_temp_tablespace, nls_languagev$session：通过sid，username,status查看当前登录用户,username为空的是系统用户。dba_users：查看所有的用户，密码，账号状态，过
2009-12-15 22:31:00
540
原创 操作系统认证登录Oracle
按照视频学习一步步来，出现的错误sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directorySQL> show parameter authNAME
2009-12-15 15:21:00
2273
原创 遭遇lsnrctl start错误
[oracle@Oracle9iDemo ~]$ lsnrctl startLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-DEC-2009 00:31:53Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /u01/oracle/bin/tn
2009-12-14 17:27:00
4255
原创 Undo segment相关信息与实验
Implement Automatic Undo Management(rather than Manual) Undo = rollback Undo segment ->save old value(undo data)&relevant location Undo segment header ->contains a transaction table->stores t
2009-12-10 23:00:00
1710
原创 关于联机重做日志文件
Redo Online Log Files:The log sequence number is assigned each time that the Oracle server writes to a log group to uniquely identify each online redo log file. The current log sequence number is stor
2009-12-07 20:40:00
611
原创 关于控制文件
Maintaining the control file1. Sized initially by CREATE DATABASEMain determinants: MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAX INSTANCES2. Multiplexing the Control fi
2009-12-05 20:40:00
446
原创 linux下纯手工创建10g数据库
Creating a DB ManuallyStep 1: Specify an Instance Identifier (SID) gwan （我GF）Step 2: Ensure That the Required Environment Variables Are Set [oracle@Oracle9iDemo dbs]$ touch gwan.en
2009-12-04 22:09:00
517
OCP Oracle Database Administration Exam Guide
2010-04-07
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人