You are hereOracle / Oracle 10g

Oracle 10g


Covers releases 10.1.0.x to 10.2.0.x

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!

I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %

$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 12722 96.4 0.2 19560 4600 pts/5 R 15:36 0:06 sqlplus

So, found out on metalink... (338461.1)
SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time (Linux x86)

Used "strace" :

$ strace sqlplus -V 2>&1 |less

Move LOBSEGMENT to different tablespace

When we created table by using "XMLTYPE" datatype...
create table tmp01 (id number, xml_data XMLTYPE) tablespace users;

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!

I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %
$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND

Move LOBSEGMENT to different tablespace

When we created table by using "XMLTYPE" datatype...
create table tmp01 (id number, xml_data XMLTYPE) tablespace users;

[Web Seminar] Adding Nodes to 10gR2 RAC

This week:
==========
*** Thursday, 8-Jan-2009, 9am Pacific (5pm GMT)

Adding Nodes to 10gR2 RAC
*** Presented by Mengmeng Tang (Dell Inc)

Will discuss detail steps for Oracle DBA and Linux Engineer to add new nodes to existing 10gR2 database RAC. Which including four major Parts :-
· Pre-install checking
· Adding an Oracle clusterware home to new nodes using OUI in interactive node · Adding an Oracle home to new nodes using OUI in interactive mode
· Adding ASM instance to new nodes

http://www.oracleracsig.org

Guia de 2 minutos-Instalacion silenciosa de Oracle 10g

En este articulo compartire con ustedes la forma de instalar el manejador de base de datos Oracle 10g sin necesidad de interface grafica y totalmente automatizado. Esto es lo que Oracle llama una instalación "silenciosa".

Esta habilidad del instalador universal de Oracle (OUI) es invaluable en situaciones donde se tiene que hacer un despliegue masivo de software, estandarización de instalaciones y automatización si es una tarea repetitiva y tediosa.



Distribuir

Distribuir contenido

Follow DatabasesLA on Twitter

En línea

En este momento hay 0 usuarios y 1 invitado en línea.

Estadisticas

Locations of visitors to this page

hidden hit counter