ora 03114

Discover ora 03114, include the articles, news, trends, analysis and practical advice about ora 03114 on alibabacloud.com

Oracle 11gR2 RAC environment DBCA create database error ORA-15055 ORA-15001

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

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

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

Help friends deal with ora-00600 [2662] And ora-00600 [4194] errors

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

Myeclipse connects to Oracle with ORA-00604 and ORA-12705 exceptions

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

ORACLE RAC 11.2.0.4 ORA-01172, ORA-01151 error after startup

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

Oracle Database error ORA-01122 ORA-01210 fault recovery

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

Sqlplus/rman Login Permission Error ora-01031/ora-04005/0ra-00554

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

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

DGMGRL error caused by ORA-16664, ORA-16625, TNS-12537-bin/oracle command permission issues

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

ORA-01092 ORA-12432: LBAC error: zllegnp: OCIStmtExecute fault case

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

ORA-01187 and ORA-01110 problems during data import

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

Expdp ora-31640, ora-19505

Expdp ora-31640, ora-19505Oracle @ db01:/oraapp/oracle/backup> impdp \ '/as sysdba \' directory = DB_BACKUP dumpfile = newdb.20140918.dmp logfile = newdb_0919.log parallel = 4 c>Import: Release 11.2.0.3.0-Production on Fri Sep 19 11:27:12 2014Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWit

Oracle input Account Login error ORA-12154: TNS: unable to resolve the specified connection identifier issue resolved, ora-12154tns

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

Database creation on 11.2 grid infracture with role separation (ORA-15025, KFSG-00312, ORA-15081)

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

Ora-01034 ora-27101 Solution)

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

ORA-19554 ORA-27211

: ========================================================== ==============================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

ORA-24324 & ORA-01041

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

OracleASM errors-ORA-15031, ORA-15014

OracleASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: [Oracle @ aix213 ~] $ Sql

ORA-28002/ORA-28000 solve 11g password expiration, password wrong lock user problems -- modify defaultprofil

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

Total Pages: 15 1 .... 11 12 13 14 15 Go to: Go

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.