Oracle - Historial de revisiones

Gacq: /* Documentation */

2007-04-01T22:21:07Z

‎Documentation

Gacq: /* Documentation */

2007-01-30T15:10:13Z

‎Documentation

Gacq: /* Administracion */

2007-01-30T14:54:22Z

‎Administracion

Gacq: /* Documentation */

2007-01-29T18:33:17Z

‎Documentation

Gacq: /* Tools */

2007-01-29T17:20:42Z

‎Tools

Gacq: /* Errors */

2007-01-29T17:16:04Z

‎Errors

Gacq: /* Tools */

2007-01-26T22:57:57Z

‎Tools

Gacq: /* Codes */

2007-01-16T20:04:25Z

‎Codes

Gacq en 20:03 16 ene 2007

2007-01-16T20:03:57Z

Gacq: /* Tools */

2006-10-18T20:10:27Z

‎Tools

@@ Línea 3: / Línea 3: @@
 *[http://tahiti.oracle.com/ Oracle Database, Application Server, and Collaboration Suite Documentation]
 *[http://www.digilife.be/quickreferences/QRC/ORACLE%20Server%208i%20Quick%20Reference%20Card.pdf Oracle Server 8i Quick Reference Card]
 =Tools=

@@ Línea 2: / Línea 2: @@
 *[http://www.oracle.com/technology/documentation/index.html Oracle Documentation]
 *[http://tahiti.oracle.com/ Oracle Database, Application Server, and Collaboration Suite Documentation]
 =Tools=

@@ Línea 8: / Línea 8: @@
 *[http://www.novell.com/products/server/oracle/software.html Linux Software for Oracle]
 *[http://squirrel-sql.sourceforge.net Universal SQL Client]
 = Administracion =

← Revisión anterior		Revisión del 18:33 29 ene 2007
Línea 1:		Línea 1:
	=Documentation=		=Documentation=
		+	*[http://www.oracle.com/technology/documentation/index.html Oracle Documentation]
	*[http://tahiti.oracle.com/ Oracle Database, Application Server, and Collaboration Suite Documentation]		*[http://tahiti.oracle.com/ Oracle Database, Application Server, and Collaboration Suite Documentation]

← Revisión anterior		Revisión del 17:20 29 ene 2007
Línea 1:		Línea 1:
		+	=Documentation=
		+	*[http://tahiti.oracle.com/ Oracle Database, Application Server, and Collaboration Suite Documentation]
		+
	=Tools=		=Tools=
	*[http://tora.sourceforge.net/ TOra - Toolkit For Oracle]		*[http://tora.sourceforge.net/ TOra - Toolkit For Oracle]

← Revisión anterior		Revisión del 17:16 29 ene 2007
Línea 94:		Línea 94:

	</nowiki></pre>		</nowiki></pre>
		+
		+	=Drivers=
		+	Oracle provides two main types of drivers.
		+	==The OCI driver==
		+	The OCI (type 2) driver consists of java wrappers to the low-level Oracle Call Interface (OCI) libraries used by utilities like SQL*Plus to access the database server. The OCI driver offers potentially better performance that the thin driver. It however requires the OCI libraries to be installed on the local machine.
		+	==The thin driver==
		+	Also referred to as type 4 driver, the thin driver is a pure Java implementation of Oracle's networking protocol (Net8). Being self-contained, it may be used on any machine with--or without Oracle installed--or even distributed with application classes in an applet.

	=Errors=		=Errors=

@@ Línea 96: / Línea 96: @@
 =Errors=
 ==Codes==
 ;ORA-7306, ORA-7336, ORA-7329
 Oracle received a system error on a shmget() call. The system error should be reported. There are a few possibilities:

← Revisión anterior		Revisión del 20:03 16 ene 2007
Línea 93:		Línea 93:

	</nowiki></pre>		</nowiki></pre>
		+
		+	=Errors=
		+	==Codes==
		+	ORA-27154: post/wait create failed
		+	ORA-27300: OS system dependent operation:semget failed with status: 28
		+	ORA-27301: OS failure message: No space left on device
		+	ORA-27302: failure occurred at: sskgpcreates
		+
		+	;ORA-7306, ORA-7336, ORA-7329
		+	Oracle received a system error on a shmget() call. The system error should be reported. There are a few possibilities:
		+
		+	There is insufficient shared memory available. This is indicated by the operating system error ENOSPC. Most likely, SHMMNI is too small. Alternatively, there may shared memory already allocated; if it is not attached, perhaps it can be freed. Maybe shared memory isn't configured in the kernel.
		+	There is insufficient memory available. Remember, shared memory needs pages of virtual memory. The system error ENOMEM indicates there is insufficient virtual memory. Swap needs to be increased, either by adding more or by freeing currently used swap (i.e. free other shared memory, kill other processes)
		+	The size of the shared memory segment requested is invalid. In this case, EINVAL is returned by the system. This should be very rare - however, it is possible. This can occur if SHMMAX is not a muliple of the page size and Oracle is trying a multi-segment model. Remember that Oracle rounds its calculation of SHMMAX to a page boundary, so it may have rounded it up past the real SHMMAX! (Whether this is a bug is debatable).
		+	The shared memory segment does not exist. This would be indicated by the system error ENOENT. This would never happen on startup; it only would happen on connects. The shared memory most likely has been removed unexpectedly by someone or the instance is down.
		+
		+	;ORA-7307, ORA-7337, ORA-7320
		+	Oracle received a system error on a shmat() call. The system error should be reported. There a a few possibilities:
		+	The attach address is bad. If this is the cause, EINVAL is returned by the system. Refer to the section on the attach address to see why the attach address might be bad. This may happen after enlarging the SGA.
		+	The permissions on the segment do not allow the process to attach it. The operating system error will be EACCES. Generally the cause of this is either the setuid bit is not turned on for the oracle executable, or root started the database (and happens to own the shared memory). Normally, this would be seen only on connects.
		+	The process cannot attach any more shared memory segments. This would be accompanied by the system error EMFILE. SHMSEG is too small. Note that as long as SHMSEG is greater than SS_SEG_MAX, you should never see this happen.
		+
		+	;ORA-7329, ORA-7334
		+	Oracle has determined the SGA needs too many shared memory segments. Since you can't change the limit on the number of segments, you should instead increase SHMMAX so that fewer segments are required.
		+
		+	;ORA-7339
		+	Oracle has determined it needs too many semaphore sets. Since you can't change the limit on the number of semaphore sets, you should increase SEMMSL so fewer sets are required.
		+
		+	;ORA-7250, ORA-7279, ORA-7252
		+	Oracle received a system error on a semget() call. The system error should be reported. There should be only one system error ever returned with this, ENOSPC. This can mean one of two things. Either the system limit on sempahore sets has been reached or the system limit on the total number of semaphores has been reached. Raise SEMMNI or SEMMNS, as is appropriate, or perhaps there are some semaphore sets which can be released. In the case of ORA-7250, ORANSEMS may be set too high (>SEMMSL). If it is, raise SEMMSL or decrease ORANSEMS.
		+
		+	;ORA-7251
		+	Oracle failed to allocate even a semaphore set of only one semaphore. It is likely that semaphores are not configured in the kernel.
		+
		+	;ORA-7318
		+	Oracle could not open the sgadef file. The system error number will be returned. There are a few possible causes:
		+
		+	The file doesn't exist. In this case, the system error ENOENT is returned. Maybe ORACLE_SID or ORACLE_HOME is set wrong so that Oracle is looking in the wrong place. Possibly the file does not exist (in this case, a restart is necessary to allow connections again).
		+	The file can't be accessed for reading. The operating system error returned with this is EACCES. The permissions on the file (or maybe directories) don't allow an open for reading of the sgadef file. It might not be owned by the oracle owner. The setuid bit might not be turned on for the oracle executable.
		+
		+	;ORA-7319
		+	Oracle did not find all the data it expected when reading the sgadef.dbf file. Most likely the file has been truncated. The only recovery is to restart the instance.
		+
		+	;ORA-7430
		+	Oracle expected a key to be used for the segment which does not match the key stored in the shared memory and semaphore data structure. This probably indicates a corruption of the sgadef file (in version 6) or the data in the first segment of the SGA (in version 7). A restart of the instance is probably necessary to recover in that case.It may also be a key collision problem and Oracle is attached to the wrong instance.
		+
		+	;ORA-7321
		+	Oracle was able to attach the segment, but not at the address it requested. In most cases, this would be caused by corrupted data in the sgadefile (in version 6) or the first segment of the SGA (in version 7). A restart of the database may be necessary to recover.
		+
		+	;ORA-7324, ORA-7325
		+	Oracle was unable to allocate memory. Most likely, the heap (data segment) has grown into the bottom of the SGA. Relocating the SGA to a higher attach address may help, but there may be other causes. Memory leaks can cause this error. The init.ora parameter sort_area_size may be too large, decreasing it may resolve the error. The init.ora parameter context_incr may also be too large, decreasing it may resolve this
		+
		+	;ORA-7264, ORA-7265
		+	Oracle was unable to decrement/increment a semaphore. This generally is accompanied by the system error EINVAL and a number which is the identifier of the semaphore set. This is almost always because the semaphore set was removed, but the shadow process was not aware of it (generally due to a shutdown abort or instance crash). This error is usually ignorable.