Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the database ORA-01261". In the daily operation, I believe many people have doubts about how to solve the database ORA-01261 problem. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts about "how to solve the database ORA-01261". Next, please follow the editor to study!

When building a DG, restart the database after modifying the parameters

SQL > startup

ORA-01261: Parameter db_create_file_dest destination string cannot be translated

ORA-01262: Stat failed on a file destination directory

Linux-x86_64 Error: 2: No such file or directory

Generate pfile to view spfile content

SQL > create pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora' from spfile

File created.

Find that the orcl of the path is written as ocrl

* .db_create_file_dest='/oradata/ocrl'

After correction

SQL > create spfile from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'

File created.

Common error: reproduced from http://www.dataguru.cn/thread-179398-1-1.html

Error 1:

ORA-16057: DGID from server not in Data Guard configuration

Reason: the parameter log_archive_config is not set in the main library

Solution * .log _ archive_config='dg_config= (orcl,auxdb)'

Alter system set log_archive_config='dg_config= (orcl,auxdb) 'scope=both

Error 2:

PING [ARC0]: Heartbeat failed to connect to standby 'aux'. Error is 1031.

ORA-01031: insufficient privileges

Ideas to solve the problem: 1, check whether the sys password is correct, mostly for this reason.

Remarks:

I have encountered that no matter connecting to the master database or the slave database from the machine where the master database is located, or from the machine where the slave database is located, using the sysdba role, there is no problem with the connection.

But the log can not be transferred from the database, I am puzzled.

Later, I finally found out that there was something wrong with the password file. Oracle's data guard cannot use operating system authentication, it must use password authentication

Just because you can use "SQLplus as sysdba" to connect to the slave database from the machine where the master database resides does not mean that the password file on the slave database must be valid.

Note that there is a password file on the machine where the database is located, and the location and naming of the password file are in accordance with the oracle specification, but the password file is not necessarily valid. Check the valid way of the password file.

Is to create an operating system user on windows, and do not add this user to the operating system ora_dba group, then the operating system user must not be able to use operating system authentication

Log in again with this user, and then use the "sqlplus as sysdba" to connect to the database, if you do not report an error that does not have sufficient permissions

That means there must be nothing wrong with the password file.

2. Oracle users have permission to write standby_archive_dest

Error 3:

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

The reason for this error is LOG_ARCHIVE_DEST_2='SERVICE=orcl LGWR ASYNC VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'

Caused by the lack of a space before db_unique_name

At this point, the study on "how to solve the database ORA-01261" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.