ora 02063

Stored Procedure ora-00942 when ora-00942 table or view does not exist Solution: Grant select, insert, update, delete on bookmarks. * to bm_user @ localhost identified by 'Password' Authorization statement: Grants the XXX select, insert, update, and delete permissions to the bm_user table. Log on to the system as sys and grant the select and delete sys. fga_log $ permissions to the system. Otherwise,

Prepare to migrate database in customer's Oracle 10.2.0.1 environment, but prompt for error when executing EXPDPOra-39006:internal ErrorOra-39213:metadata processing is notavailableUse Oracle users to view ORA-39213 specific content:Oerr Ora 3921339213, 00000, "Metadata processing IsNot available"*cause:the Data Pump could not use the Metadata API. Typically,This is caused by the XSL stylesheets isn't being

My local database version installed is Oracle 11g R2, when using PLSQL connection, the following error is reported ora-12514: However, when using sqlplus in cmd to connect a user already created, the following error is reported: Oracle not available ORA-01034ORA-27101-shared memory realm does not existI checked several solutions on the Internet to solve Oracle Home and Sid problems, or asked net confi

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: Check whether the table is locked SELECT /*+ rule*/a.sid, b.owner, object_name, object_typeFR

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 message mentioned in the ' LISTENER_ORCL ', such

Tags: fixed restart rod effect install CLR Global user file1. The Tomcat was released yesterday, but after login error, unable to open hibernate session, check that the database cannot connect 2. Using PL/SQL to log in to the database, reported ora-12541,tns no listening program, Baidu found the need to configure monitoring, not its solution, because I have not moved the database, try to configure the method by can refer to http://www.cnblogs.com/Ve

Number: 0Because of this small mistake, toss me for several hours, the special record is as follows.Search the Internet for the next solution, as follows:Sqlplus "Sys/password as SYSDBA"Connection successful, prompting "connected to idle routine"Sql> StartupThe ORACLE routine has been started.Total System Global area 535662592 bytesFixed Size 1375792 bytesVariable Size 293601744 bytesDatabase buffers 234881024 bytesRedo buffers 5804032 bytesThe database is loaded.ORA-03113: End of file for comm

It takes a day and a half to resolve the client connection to the Oracle database on the server side, unable to connect the problem. Ora-01034:oracle Not available (ORACLE does not exist), ora-27101:shared memory realm does not exist analysis:A few days ago you can also connect to the database, but yesterday, the local no reason to connect to the server database. Many people on the internet say that the cau

Sometimes God is love and you joke, yesterday very hard to configure the Oracle, can be used with PL/SQL Normal login, today suddenly lost. And the error is very strange, there is no hint of what error code. Enter the user name password, click Login after PL/SQL is not reflected, the direct card dead.I was depressed, do not give hints how to solve the problem. It suddenly occurred to me that Oracle would certainly have a record of the logs. Check it out and there should be surprises.Oracle Log L

etldata); Batch Script Association to write Because the data table space in this project is separate from the index table space, there are no related operations on the index, and if there is an index, the condition is similar to the table. D. Verify that the data file is empty A. See if the dba_extents has a record (requires no records) SELECT * FROM Dba_extents twhere t.file_id = 10; B. See if Dba_segments has a record (requires no records) SELECT * FROM Dba_segments twhere T.header_file = 10

Label:Operating system: windows2008 Database: oracle11g Problem occurs: A set of normal run a year of application system, suddenly unable to connect to the database, but another application can be normal link, data storage normal. Database server-side view: Use Lsnrctl status to view the listening status of the card, 10 minutes or so before the results will be feedback. Plsql cannot connect. Restart monitoring is still the problem. An error in the Alter log file: Fatal NI Connect error 12537, c

ORA-19870 and ORA-19573 errors occur when you restore an Oracle database. The cause of this problem is that the database is in the open state, and the database is in the mount state. ORA-19870 and ORA-19573 errors occur when you restore an Oracle database. The cause of this problem is that the database is in the open s

Streams exceptions are found in the source database, such as: Check: select * fromdba_capture to see the Exception error ORA-26744: STREAMScaptureprocessquot; CAPTURE Streams exceptions are found in the source database, such as: Check: select * from dba_capture see Exception error ORA-26744: STREAMS capture process quot; CAPTURE Problem: A Streams exception is found in the source database, such: Check:

Today, you can not log on to the tomcat front-end interface, view the log found that the original is ORA-28001: thepasswordhasexpired error, this error is due to Or Today, you can not log on to the tomcat front-end interface, view the log found that the original ORA-28001: the password has expired error, this error is caused by Or Today, you can not log on to the tomcat front-end interface, view the lo

One ORA-600 [13011], one ora-60013011SunOS 5.10 Oracle 10.2.0.2.0 development environment a database has a ora-600 error.Alert. error message in log: Thu Nov 13 15:11:43 2014 Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc: ORA-00600: internal error code, arguments: [13011], [298314], [4277430], [0], [4277430]

Tags: process based on breaking malicious attack information ASE CLI keep BSPJust work in the morning, as usual, supporting the computer support, open the computer, there is a war film inside, back to the position, set up machine guns, ready to meet the enemy of the ritual sense. Everything is so familiar, in the start test environment, the development of sound broke the office of quiet: "The company XXX system database is not hanging!!!" ” After listening to the habit of a cold sweat! It's emba

1.1.1. ora-19502,ora-27072 Date: 2014-05-12 00:12 Environment: Test machine "Error Number" $ oerr ora 19502 19502, 00000, "write error on File\"%s\ ", block number%s (block size=%s)" *cause:write Error on output file *action:check the file $ oerr ora 27072 27072, 00000, "File I/O error" *cause:read/write/read

The machine room is powered down, so Oracle's Datagard from the library needs to be restarted:1 Login sqlplus Start, error message:Sql> STARTUP MOUNT;Ora-16032:parameter log_archive_dest_3 Destination string cannot be translatedOra-07286:sksagdi:cannot obtain device information.linux-x86_64 error:2: No such file or directory2 Go to see the exact path to the log_archive_dest_3 .[Email protected] ~]# su-oracle[Email protected] ~]$ echo $ORACLE _home/ora

ORA-12523: TNS: Listeners cannot find routines for client connection, ora-12523tns Today, when you connect to a new test server using PL/SQL Developer, you encounter a ORA error: ORA-12523: TNS: The Listener cannot find a routine for client connection. The error in the corresponding listening log file is TNS-12523: TNS

ORA-01157 ORA-01110, ora01157ora01110 The test server after RMAN recovery, found that the alarm log file has the following error information ORA-01110: data file 206: '/u04/epps/oradata/temp02.dbf' Errors in file /u01/app/oracle/admin/epps/bdump/epps_j000_12672.trc: ORA-01157: cannot identify/lock data file 206 -