Want to know ora 03114 not connected to oracle solution? we have a huge selection of ora 03114 not connected to oracle solution information on alibabacloud.com
document does not need to be read :-)
Error Cause Analysis
Improper Unix core parameter setting/improper init parameter settingIf the operating system core variables are not set correctly during the database installation process, there may be no problems when installing the database file, and 03113 errors may often occur during database creation. Another reason for this is that the processes parameter in the init. ora parameter file specifies an un
Run ps-ef | grep ora _ to check that no Oracle process is found.Entering the database boot encountered a ORA-01261: ORA-01262: error.
$ Sqlplus "/as sysdba"
SQL * Plus: Release 10.2.0.1.0-Production on Tue Dec 15 08:25:22 2009
Copyright (c) 1982,200 5, Oracle. All rights
Oracle ORA-00031: session marked for kill (marking the session to be terminated) solution, ora-00031marked
Today, I encountered a problem where a table cannot be operated and may be locked. The first thing I thought was to kill the session. So I executed the following script to find out which session has a problem:
Che
Tags: related binary lis two database services spfile using the command SYS requiresIn the Oracle server with SYS user login times wrong ora-00119,ora-00132, such asReading the newspaper wrong is the need to modify the configuration information of the parameter file network registration moduleThe first step: View the init.ora.418201831545 file, find the error mes
This is a real oracleORA-19815 solution) case, hope to help everyone.Today, the platform of a friend company encountered slow login and slow data query, and the failure to log on to oracle monitored through spotlight. No problems were found by checking the system memory and processes, finally, I found myself. I first checked the memory and processes of the platform, and did not find any problems. Finally, I
When the hardware is maintained, someone accidentally disconnected the power supply from the production library, and after restarting the enclosure and server, an Oracle 10g 10.2.0.4 startup error message appears:
The code is as follows
1
Database loading complete.ORA-01122: Database file 1 validation failedORA-01110: Data file 1: ' E:\ORACLE
Yesterday, a colleague reported that when Oracle9i was used, the service name was successfully configured in the net assistant, but it was always unable to connect when SQL * Plus and other client tools were used.
· First, check whether the service name exists and find that the service name does exist and can be connected and tested in the net assistant.
· Next with SQL * Plus connection error, error: ORA-
If you need to view the general meaning of the error, run the following command:
[plain] [root@localhost ~]# su - oracle [oracle@localhost ~]$ oerr ora 01507 01507, 00000, "database not mounted" // *Cause: A command was attempted that requires the database to be mounted. // *Action: If you are using the ALTER DATABASE statement via the SQLDBA //
Startup Mount Tip: Oracle routines are startedTotal System Global area 118255568 bytesFixed Size 282576 bytesVariable Size 82886080 bytesDatabase buffers 33554432 bytesRedo buffers 532480 bytesDatabase loading complete ALTER DATABASE open;Tips:An error occurred on line 1th:ORA-01157: Unable to identify/lock data file 19-see DBWR trace fileORA-01110: Data file: "' F:/llh/bookspace. DBF ";This hint file section is somewhat different depending on the c
: RAC Connection Redirected Wrong Host/IP ORA-12545 is described accordingly. Solution: Modify the database initialization parameter LOCAL_LISTENER: SQL code SQL> CONN SYS @ nuage1 AS SYSDBA and enter the password ***** connected. SQL> ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.127) (PORT = 1521)' SID = 'nuage1 '; the SYSTEM
After connecting to oracle error "ORA-28547: connectiontoserverfailed, probableappslenetadmin solution,
Listener. ora is the oracle configuration file on the server.
Then, comment out this line of listener. ora, and (PROGRAM = ex
Preface
Every DBA in the Process of database management should inevitably encounter a variety of errors (ORA-1547, ORA-904, ORA-1578 ......). Some errors are often called "classic errors" by Oracle DBAs due to frequent and complex causes ". The ORA-3113 "end of file on commu
Connect to Oracle today error: ORA-18008: unable to find the OUTLN solution, the day before yesterday also used well, now no matter query any SQL statement or click list view will pop up this error
Connect to Oracle today error: ORA-18008: unable to find the OUTLN
Problem Description: I used the C # program to manipulate the image data-a number of images to synthesize a picture, because the image is large, through the Oracle database to store, but because the program runs for a period of time after the system consumes too much resources, the results of the program in response, I will shut down the program As a result, the Oracle database collapsed.
By connecting to t
System Environment:1. Operating System: Windows 2000 server,2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition3. installation path: C: \ oracle
Error:A data file in the database was accidentally deleted due to misoperations,The Oracle-related services on the control panel are displayed as started, but cannot be con
registered or static.
When the instance status is UNKNOWN, it indicates that the service is set for static registration, and the listener indicates that it does not know any information about the instance, only when the user sends a connection request, to check whether the instance exists.
The status of a dynamically registered database is indicated by READY or BLOCKED in the status information. No matter when the database is closed, the dynamically registered database will be logged out of t
automatically
AlterTablespace usersAddDataFile'/home/oracle/oradata/users04.dbf'Size 32760m Autoextend on Next1024m MaxSize Unlimited; --Segment Space Management auto Extent management Local; It is said that the previous sentence can be connected with the execution (the last semicolon is removed), did not execute, do not know the effect of implementation, cautious period, use caution.
--Resize the data fi
This is a real oracle (ORA-19815 solution) case, hope to help everyone. Today, the platform of a friend company experienced slow login and slow data query. In addition, spotlight was used to monitor oracle
This is a real oracle (ORA
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.