ora 03114 not connected to oracle solution

Environment: CentOS 6.2 + Oracle 11.2.0.3 Problem description: data cannot be started when oracle is installed or when you configure dataguard, error message ORA-00845: MEMORY_TARGET not supported on this system The main cause of this error is that the tmpfs value is smaller than the memory_target value. [Root @ dac-vm02 ~] # Oerr

After the connection to the database is successful, check the listener status: lsnrctlstatusstatusREADY status, which must be switched from non-archive to archive mode. The operation is as follows: 1. Disable After the connection to the database is successful, check the listener status: lsnrctl status READY status, which must be switched from non-archive to archive mode. The operation is as follows: 1. Close Oracle error

Oracle exception [ORA-22908: NULL Table value reference] Problem Analysis and Solution Oracle exception [ORA-22908: NULL Table value reference] Problem Analysis and Solution The scenario is as follows:Type list_obj; test (nam

The Client Version is 10.2.0.1.0 32-bit, and the server is 9.2.0.4.0 64-bit. Client Connection server reported ORA-28547: Connection server failed, may be an Oracle Net management error.The status is as follows: C: \> sqlplus "sys/Oracle @ vm9i as sysdba"SQL * Plus: Release 10.2.0.1.0-production on Thursday January 7 13:41:20 2010Copyright (c) 1982,200 5,

1. Environment Description OS: Linux RedHat5.5 Oracle version: Oracle RAC 11.2.0.1 2. Problem Description Use exp to export data of multiple users in the database. The statement is exp buffer = 4096000 file = exp. dmp wner = user1, user2 .... The ORA-1455: converting column overflows integer ype error is reported when the export ends at the end. 3.

A solution that prompts "ORA-01788: This query block requires a connect by clause" when creating a remote materialized view on Oracle 11g maps a table on the remote server to a local materialized view, use the following statement: www.2cto.com ---- create database link lnk connect to user1 identified by pwd1 using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTO

question: When logged in with Pl/sql, it appears: "Ora-01045:user system lacks create session privilege; Logon denied ". Reason: the user does not have permission to create session sessions Google found this section of the description: What does "Ora-01045:user USERNAME lacks CREATE session Privilege;logon denied" mean? It means that's username and password with which you tried to login are known and a

Cainiao oracle -- ORA-28000: the account is locked solution 1. today, oracle 10g and plsql are installed, and an error is reported when scott is installed. the reason is: scott of Oracle10g cannot log on 3 by default. solution: 1: www.2cto.com Step 1: Use PL/SQL, the login n

Today with the client to connect to oracle, found to report ORA-01033: ORACLE is initializing or closing the error, in fact, this error reported for a few days, the first two restart just fine, why can't I get up today? By searching on the Internet, it's a good solution,First, I use the startup mount command, which is

Oracle Log File loss (ORA-O1109: the database is not open) solution after deleting the oracle11g tablespace file by mistake, the database is not open the cause of the above problem is mistakenly put 'f: \ ORADB. DEF 'the data file is deleted. This deletion method is not normal. If the user and tablespace are deleted, then the data file is deleted, however, this o

Today we mainly introduce you to Oracle Database ORA-01460 errors in actual operations, we all know that using PL/SQL DEVELOPER 7 to connect to a newly installed Oracle Server sometimes has a ORA-01460 error, for example, type conversion error. Only PL/SQL DEVELOPER has this problem. The suspect is a character set prob

On the platform after Oracle 10.2.0.4, we may encounter the following error when importing materialized views using a Data Pump: ...Ksedmp: internal or fatal errorORA-7445: exception encountered: core dump [_ intel_fast_memcpy.A () + 10][SIGSEGV] [Address not mapped to object] [0x000000000] [] []Current SQL statement for this session:Alter materialized view "MVIEW_OWNER". "MVIEW_NAME" COMPILE----- PL/SQL Call Stack -----Object line objectHandle numbe

Once the Oracle system was started when the system was started, an error message was prompted when connecting with the client tool: Oracle startup error. ORA-01033: Oracle initialization or shutdown in progress, and then enter the console to find that the database is not open, in the service, oraclesid Database Service

Today, the VM memory is reduced a little, and the following error occurs when the data is started: SQL> startup ORA-00845: MEMORY_TARGET not supported on this system I guess it should be the problem of system memory conflicts with sga. Then I checked it on the Internet. It is true that: The official analysis from Oracle is: Starting with Oracle Database 11g, the

Problem:"Ora-01045: user system lacks create session privilege; logon denied" appears when you log on with PL/SQL ". Cause: no permissionIn Google, find the following description:What does "ORA-01045: User Username lacks create session privilege;Logon denied "mean?It means that the username and password with which you tried to login are known and accepted by the Oracle