obsolete and/or deprecated parameter(s) specified

简介: <div style="margin:0px; padding:0px; border:0px; line-height:1.57143em; font-family:gotham,helvetica,arial,sans-serif; font-size:14px; color:rgb(56,56,56)"> obsolete and/or deprecated parameter(s
obsolete and/or deprecated parameter(s) specified


SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  599785472 bytes
Fixed Size              2098112 bytes
Variable Size            322964544 bytes
Database Buffers       268435456 bytes
Redo Buffers              6287360 bytes
Database mounted.
Database opened.



SQL>show paramter log_arcvhive_start
NAME                         TYPE     VALUE
------------------------------------ ----------- ------------------------------
log_archive_start               boolean     TRUE
解决方法:
10g中丢弃了log_arvhive_start 参数 不能置为true

SQL> alter system reset log_archive_start scope=spfile sid='*';

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area  599785472 bytes
Fixed Size              2098112 bytes
Variable Size            322964544 bytes

Database Buffers       268435456 bytes
Redo Buffers              6287360 bytes
Database mounted.
Database opened.


------------------服务名不识别
原因:用户不对,没有在sysdba用户下建立DB_LINK连接

SQL> select * from dual@jssweb;
select * from dual@jssweb
                   *
ERROR at line 1:
ORA-02019: connection description for remote database not found

conn stradmin/stradmin  
OK  ------------------------> OK
目录
相关文章
|
小程序 JavaScript API
Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ?
Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ?
819 0
|
C++
Reference Parameter
Reference Parameter(引用参数)是一种 C++ 编程语言中的参数传递方式。它允许将一个变量的引用(而不是副本)作为函数参数传递。引用参数的主要优点是可以避免在函数内部对实参进行拷贝操作,从而提高代码的效率。
81 1
|
存储 Linux Docker
snapshotter not loaded: overlayfs: invalid argument
snapshotter not loaded: overlayfs: invalid argument
201 0
|
开发工具
WARNING: library configuration mismatch
WARNING: library configuration mismatch
314 0
error: invalid argument ‘-std=gnu++98‘ not allowed with ‘C‘
error: invalid argument ‘-std=gnu++98‘ not allowed with ‘C‘
116 0
Duplicate methods named spliterator with the parameters () and () are inherited from the types Colle
Duplicate methods named spliterator with the parameters () and () are inherited from the types Colle
73 0
|
SQL 监控 数据库
ORA-32004: obsolete and/or deprecated parameter(s) specified
如果在启动数据库时遇到ORA-32004: obsolete and/or deprecated parameter(s) specified 错误,这个是因为数据库里面设置了过时或不推荐使用的参数,如下描述所示: SQL> ho oerr ora 3200432004, 00000, "obsol...
1263 0
|
关系型数据库 Oracle
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
5141 0
Error saving your changes: Description control characters are not allowed
在修改 GitHub 上的仓库描述时出现此提示信息:Error saving your changes: Description control characters are not allowed 开始以为是 Fork 来的没有修改权限,但之前没有遇到这样的情况,提示信息说的也不是这个意思。
2384 0