Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Collect oracle error codes and solutions by yourself

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

ORA-28547:connection to server failed,probable Oracle Net admin

Comment out PROGRAM = extproc in listener.ora

ORA-09925: Unable to create audit trail file

show parameter audit_file_dest

mkdir parameter audit_file_dest

ORA-01157/ORA-01110:

After RAC1 builds DG, close RAC1+DG database, RAC2 database cannot be opened to open state

startup nomount;

alter database mount;

alter database open;

ERROR at line 1:

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01110: data file 6:

'/oracle/app/oracle/product/11.2.0/db_1/dbs/oradataorclGLOBAL.DBF'

alter database datafile 6 offline;

alter database open;

Database altered.

ORA-10456:

SQL> startup nomount

ORACLE instance started.

Total System Global Area 417546240 bytes

Fixed Size 2228944 bytes

Variable Size 318770480 bytes

Database Buffers 92274688 bytes

Redo Buffers 4272128 bytes

SQL> alter database mount standby database;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

PRVG-1013:

Add nodes to rac environment, pre-check fails, installation cannot continue, but installation conditions are actually met, for example: /u01/11.2.0/grid directory exists, but pre-check fails

Set the environment variable IGNORE_PREADDNODE_CHECKS=Y

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report