Oracle 11gR2 RAC environment DBCA create database error ORA-15055 ORA-15001
Symptom:
After installing the Oracle 11gR2 GridInfrastructure and Database software, run DBCA to create a Database to 30% and report the following error. Click OK to ignore and stop the installation.
Problem Analysis:
From the above problem, it is not difficult to see that it is caused by the inability to access the ASM disk group.
Add ASM disk error ORA-02097 and ORA-15014
Background:
This is a set of currently installed 11.2.0.1 RAC. The Grid Infrastructure has been installed, the ASMLib and the disk partition have been completed, and no member disks were found when the disk was created through the asmca graphic interface.
Symptom:
Problem Analysis:
From the error message, we can see that the disk path is not found in the asm
Oracle reported error when importing imp data: ORA-12592: TNS: Package error, ora-12592tns
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/43153127
When using imp to import data, check that o
Recover database using backup controlfile until cancel
*. _ Allow_resetlogs_uption = true*. _ Allow_error_simulation = true
Add two implicit parameters and start again
SQL> alter database open resetlogs;Alter database open resetlogs*Row 3 has an error:ORA-00603: Oracle Server session terminated by fatal errorORA-00600: Internal error code, arguments: [2662], [0], [1080422], [0],[1083510], [12583040], [], [], [], [], [], []ORA
Using sqlplus can connect to Oracle normally, and using PLSQL to connect to Oracle is also normal. However, the following exception occurs when myeclipse's dB browser is used to connect to Oracle:
Java. SQL. sqlexception:
ORA-00604: Error occurred at recursive SQL Level 1
ORA-12705: cannot access NLS data files or invalid environment specified
Cause: the configuration item duser. Language = ZH-CN in
Environment descriptionOperating system: redhat6.4 64-bitOracle version: 11.2.0.4 RAC (two node)Disk array: Macro bin 3300eProblem descriptionWhen implementing a RAC cluster years ago, there is only one set of paths in the operating system where the RAC cluster resides, and the other set of redundant paths does not appear, but the RAC can start normally, because the time relationship is not resolved, directly shutdown the server where the RAC cluster resides. Years later to the scene, found that
There are friends. data file header error ORA-01122 and ORA-01210 error, the database is not normal open.
Because the platform is win, they seek me to consult win bbed, because the home computer did not bring, can not provide win bbed. I passed the DD part of the file header, and then the Linux platform analysis found that the file header block a large number of bad blocks
Bbed Analysis of bad blocks
Bbed
environment variables, permissions issues, environment variables are problematic, error, this phenomenon is unable to run Oracle program software Sqlplus/rman, so query operating system users[[email protected] admin]$ ID Oracleuid=502 (Oracle) gid=500 (oinstall) groups=500 (Oinstall), 1100 (WebLogic) --Discovery of exceptions for Oracle owner [Email protected] ~]# gpasswd-d Oracle WebLogicRemoving user Oracle from Group WebLogic[[email protected] ~]# ID Oracleuid=502 (Oracle) gid=500 (oinstall)
ORA-01092 ORA-12432: LBAC error: zllegnp: OCIStmtExecute fault case recently due to the database hang live, helpless directly killed the pmon process, once again started received the ORA-01092: ORACLE instance terminated. disconnection forced and ORA-12432: LBAC error: zllegnp: OCIStmtExecute. Well, it's an error that
1.1. ORA-16664, ORA-16625, TNS-12537
Master database:
16664,000 0, "unable to receive theresult from a database"
// * Cause: During execution of a command, a databasein the Data Guard
// Broker configuration failed to return a result.
// * Action: Check Data Guard broker logsfor the details of the failure.
// Ensure network communication is working properly amongst
// Members of the configuration. Fix any p
Recently because of the database hang live, helpless directly killed the pmon process, again when the startup received the ORA-01092: ORACLE instance terminated. Disconnection forced and ORA-12432: LBAC error: zllegnp: OCIStmtExecute. Well, it's an error that has never been encountered. The following describes and solves this error. 1. fault description idle> startupORACLE instance started. total System Glo
The ORA-01187 ORA-01110 error was encountered during data import, the most recent data import (IMP), because the database was restored using hot standby and the recovery was successful, because the database can be opened successfully, what are the omissions? If you have a similar problem, let's look at it. 1. Fault symptom [SQL] IMP-00003: ORACLE error 1187 encountered
Oracle input Account Login error ORA-12154: TNS: unable to resolve the specified connection identifier issue resolved, ora-12154tns
TNS-03505: unable to resolve Name:
Recently, after Oracle Developer Suite has been installed, you cannot log on to the system, enter an account logon error: ORA-12154: TNS: failed to parse the specified connection identifier.
Gen
This document discusses the necessary steps to take before creating a 11.2/11.1/10.2 database with 11.2 grid infrastructure when role separation is in place.
In case of role separation we typically have the following groups and users:Grid infrastructure home owner: GridPrimary Group: oinstallSecondary groups: asmadmin, asmdba, asmoper
RDBMS home owner: OraclePrimary Group: oinstallSecondary groups: dBA, role, asmdba
In case of stand alone set up, if the 11.2 database be managed by Oracle rest
Tags: Ar data art on Log Database Server SQL1. In the CMD command window of the Oracle server, enter LSNRCTL start to determine whether the listener is started.2. Started. Enter oracle_sid = [Your connected Sid], for example, oracle_sid = mydb.3. Input sqlplus/nolog to log in without outputting logs4. Enter Conn/As sysdba, and the connection to the idle routine is displayed.5. Output startup, indicating that the Oracle routine has been started.Below are some database information.And then try aga
: ========================================================== ==============================RMAN-03009: failure of allocate command on ch00 channel at 09/17/2012 14:36:13The ORA-19554: error allocating device, device type: SBT_TAPE, device name:ORA-27211: Failed to load Media Management LibraryAdditional information: 2
RMAN>
Recovery Manager complete.
Check that there are no problems with libraries, scripts, and network resolution.
Solution:
Symantec n
After the database is closed remotely, it cannot be started.ORA-12514 ORA-24324 errors
Simulate the solution process:
SQL> conn sys/×××× @ liangwei as sysdbaConnected.SQL> shutdown immediateThe database has been closed.The database has been detached.The Oracle routine has been disabled.
SQL> startupORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor
SQL> host LSNRCTL status
LSNRCTL for 32-bit wi
ORA-28002ORA-28000 to solve the problem of locking the user after the password expires and wrong password -- modify defaultprofile
ORA-28002/ORA-28000 address 11g password expiration, password wrong lock user problems-Modify default profile
A ORA-28002: the password will expire within 7 days
In the 11G, the defaul
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.