ora 00942

Question one:ERROR at line 1:ora-29538:java not installedWorkaround1. Check that there are no Java components installedSELECT * from V$option t where t.parameter= ' Java ';If the return line description is installed, if no rows are returned, run Oracle Universal installer install Java components2. If the row is returned in step 1th, check that there is no Dbms_java in Oracle.Select distinct owner,name from Dba_source where lower (name) = ' Dbms_java '

Native IP Address: 192.168.1.163[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.2.0-production on Sun 4 19:32:13 2014Copyright (c) 1982, 2005, Oracle. All rights Reserved.@>conn sys/oracleerror:ora-01034:oracle not availableora-27101:shared memory realms does not existlinux Error:2: No s Uch file or directoryThe generation of ORA-01034 and ORA-27101 is due to the fact that the database is not sta

Oracle Bug 6136074 encountered at work, a bug of 10203, is the first time this problem was encountered. On 10.2.0.3, a bug may cause compilation or view failure. The failure may not only result in unavailability of the current view or process, but may affect the entire data dictionary, this results in a ORA-04068 error when the stored procedure is executed.The error message is as follows:ORA-04068: existing state of packages has been discarded.ORA-040

Ora-00210:cannot Open the specified control fileOra-00202:control file: '/u01/app/oracle/oradata/orcl/control01.ctl 'Ora-27086:unable to lock File-already inch useIdeas:1 , look at "LK" and "sgadef.dbf " These two documents are not present, and if they exist, they are deleted;2 , see if there is a background process exists;3 , look at Oracle shared memory segments and signal sets (semaphores) is not still t

Retain the data files, control files, and redo log files of the original database on Windows. Reinstall the Windows system and redo the database. 1. Install Oracle database software 2. Use Oracle dbca to create a database with the same name as the original database 3. Back up the spfile file (usually in the $ ORACLE_HOME \ dbs directory) and generate a pfile (usually in the $ ORACLE_HOME \ database directory ): SQL> create pfile from spfile; 4. Modify the path of the pfile control file. Path poi

O M Engineers deployed a set of Oracle (Database not built) on an IBM P750 (AIX6.1), allowing me to perform a disaster tolerance for a commercial database with its DG. I deployed the DG following the normal steps. 1. Start log recovery in the slave Database Alter database recover managed standby database using current logfile disconnect; 2. Check whether the standby database receives logs normally. Select process, client_process, sequence #, status from v $ managed_standby; -- Logs are received

Problem description: The following error is reported when you log on to the database today because the notebook is often disabled and directly covered: 1. Using PLSQL login, error: ora-12514 error, TNS could not recognize service name 2. Log on to the Apsara stack console with the following error: Enter the User name: SYSEnter the password:Error:A ORA-01034: Oracle not availableORA-27101: Shared Memory rea

Oracle remove tablespace data file ora-00604 ora-01426, ora-00604ora-01426Zookeeper Project Background: Database Management in the previous development environment is messy. When the tablespace is insufficient, only data files are added. After the test, the data has been deleted, but the space occupied by the tablespace in the database cannot be recycled, as a re

greater than the undersized retention parameter following the steps from note:563470 .1Sql> ALTER TABLE Applsys. Fnd_lobs Modify LOB (File_data) (pctversion 5);Table altered.Sql> ALTER TABLE Applsys. Fnd_lobs Modify LOB (File_data) (retention);Table altered.3. Query the LOB retention again to verify, the change have taken hold:Sql> Select Column_name,securefile,pctversion,retention from Dba_lobs where Owner=upper (' owner ') and TABLE_ Name=upper (' table_name ');column_name SEC pctversion RETE

= ' AUTO 'standbyfilemanagement = ' AUTO 'Archivelagtarget = ' 0 'logarchivemaxprocesses = ' 4 'Logarchiveminsucceeddest = ' 1 'Dbfilenameconvert = ' 'Logfilenameconvert = ' 'Faststartfailovertarget = ' 'Inconsistentproperties = ' (monitor) 'Inconsistentlogxptprops = ' (monitor) 'Sendqentries = ' (monitor) 'Logxptstatus = ' (monitor) 'Recvqentries = ' (monitor) 'Applylagthreshold = ' 0 'Transportlagthreshold = ' 0 'Transportdisconnectedthreshold = ' 30 'Sidname = ' Queuedb 'Staticconnectidentif

ORACLE database space bare device is out of the problem, startOracle failure, workaroundProblem phenomenon:StartOracle reported the following error:Database mounted.Ora-01122:database File 6 failed verification checkOra-01110:data file 6: '/dev/raw/rlv_cbs_user_dat 'Ora-01203:wrong incarnation of this file-wrong creation SCNProblem solving:There is a problem with this database space, you need to delete the database space and then add it againThe corre

Environment: AIX 11.2.0.3 RACSymptom: Node 1 operating system cannot connect, Node 2 shows RAC service status OK, 15 minutes after connection recoveryDB logOra-27300:os system dependent Operation:fork failed with Status:12Ora-27301:os Failure Message:not enough spaceOra-27302:failure occurred at:skgpspawn3OS Log650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M00/80/F2/wKioL1dFV2CBdfHEAAHpVYWcRog031.jpg "title=" Img_ 20160522_233726.jpg "alt=" Wkiol1dfv2cbdfheaahpvywcrog031.jpg "/>Check fo

Although deleteinput is configured in the script to delete the archive after the archive is backed up, to reduce the disk space occupied by the archive, you can see in the backup log of the RMAN script, from January 1, August 3 Although the archive is deleted using delete input after the archive is backed up in the script to reduce the disk space occupied by the archive, you can see in the backup log of the RMAN script, from January 1, August 3 So I decided to re-build the DG, shut down the

Perform replica uard. After the standby database RMAN is synchronized, alterdatabaseopenreadonly cannot start. There is no error in the rman process. When the standby database is started, there is a heap of E in alter. log. Perform replica uard. After the standby database RMAN is synchronized, the alter database open read only command cannot start. There is no error in the rman process. When the standby database is started, there is a heap of E in alter. log. SQL> alter database open read o

Tags: style code tar ext color CNative IP Address: 192.168.1.163[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.2.0-production on Sun 4 19:32:13 2014Copyright (c) 1982, 2005, Oracle. All rights Reserved.@>conn sys/oracleerror:ora-01034:oracle not availableora-27101:shared memory realms does not existlinux Error:2: No s Uch file or directoryORA-01034 and ORA-27101 are generated because the database does not start and requires a SYSDBA to ent

On the AIX platform, after ORACLE11GRAC is upgraded from 11.2.0.2 to 11.2.0.3, the database fails to start. The error is as follows: [oracle @ p520] $ sqlplusquot; assysdba On the AIX platform, after ORACLE 11g rac is upgraded from 11.2.0.2 to 11.2.0.3, the database fails to start. The error is as follows: [oracle @ p520] $ sqlplus quot;/as sysdba On the AIX platform, after Oracle 11g rac is upgraded from 11.2.0.2 to 11.2.0.3, the database fails to start. The error is as follows: [Oracle @

The first time Oracle 11g R2 Active Data guard is configured today, after physical standby database is created with rman,The following error occurs when you try to open standby in read only mode: SQL> alter database open read only;Alter database open read only*Error at line 1:ORA-10458: standby database requires recoveryORA-01152: File 1 was not restored from a sufficiently old backupORA-01110: Data File 1:'/U01/APP/Oracle/oradata/standby/datafile/o1_

For listeners that are not on the default port (1521), The pmon process does not register the service/instance to the listener, that is, dynamic registration is not implemented. Similar to a single instance, listeners with non-default RAC ports also set the local_listener parameter. In addition, you can remotely register an instance to achieve load balancing. This is achieved through the remote_listener parameter. For more information about the basics and concepts of Oracle network configuratio

Example of ORA-19527 and ORA-00312 error resolution in 10gDG In the past few days, we have set up a 10g DG Windows 2008 R2 testing environment, mainly to re-build a production database DG for a customer tomorrow. Some problems have been found, so I would like to record it. Because it is to be deployed to the production environment, we need to consider the online build of DG solution, that is, when the datab

the production database wants to build the DG without stopping the database, it is necessary to use the original db_unique_name, which is usually the same name as db_name. After modifying the spfile, use it to create a pfile for the standby database. Create pfile from spfile; 3. Create standby redo logfile in the master database, and alter database add standby logfile group # datafile ('xxxx') size 50 M. xxxx specifies the path and file name. 4. Create listener.