冷静、沉淀

10g使用手记 2004-10-19

上一篇 / 下一篇  2004-10-19 00:00:00 / 个人分类:Oracle

环境:

windows 2000 server

oracle 10.1.0.2


 

1.      log_archive_start已经被废弃

如果指定了该参数,数据库在启动的时候会出现:

ORA-32004: obsolete and/or deprecated parameter(s) specified错误.

 

2.数据库关闭后,远程不能连接上10g

远程:

-- 这里的关闭不能真正关闭数据库!

test@GZSERVER> shutdown abort

ORACLE 例程已经关闭。

test@GZSERVER> startup

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE 例程已经启动。

ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA

 

test@GZSERVER> startup

ORA-01041: 内部错误,hostdef 扩展名不存在

test@GZSERVER> exit

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options中断开

 

C:Documents and Settingshxd>sqlplus /nolog

 

SQL*Plus: Release 9.0.1.0.1 - Production on 星期二 10 19 15:14:50 2004

 

(c) Copyright 2001 Oracle Corporation.  All rights reserved.

 

 

> conn sys/manager@test10g as sysdba

ERROR

ORA-01017: 无效的用户名/口令;拒绝登录

 

本地:

C:Documents and SettingsAdministrator>set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

 

C:Documents and SettingsAdministrator>sqlplus / as sysdba

 

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Oct 19 15:16:52 2004

 

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

 

SQL> startup

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown abort

ORACLE instance shut down.

SQL>

 

本地启动后在远程:

 

> conn sys/manager@test10g as sysdba

已连接。

>

TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-10-14  
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 13749
  • 日志数: 838
  • 建立时间: 2007-12-28
  • 更新时间: 2008-10-02

RSS订阅

Open Toolbar