Thursday, June 10, 2010

Reinstall APEX - Oracle 11gR2 - Linux + Embedded PL/SQL Gateway

Ambiente 

SO : Linux
Banco de dados : Oracle Database 11gR2

Objetivo : Fazer a instalação do Apex + Embedded PL/SQL 
 
1º cd $ORACLE_HOME/apex

SQLPLUS 

--Instala o apex
2º  @apexins SYSAUX SYSAUX TEMP_01 /i/
obs. Pode ser outra tablespace de escolha livre desde que exista

--Embedded gateway + configuração do local das imagens
3 º @apex_epg_config $ORACLE_HOME/apex

ALTER USER ANONYMOUS ACCOUNT UNLOCK; 

5º @apexconf
obs. setar a senha do USUARIO ADMIN

Depois :

http://hostname ou IP:8080/apex_admin

Troque a senha do usuário ADMIN  e enjoy it!

http://hostname ou IP:8080/apex

Agradecimentos  a ,

Rodrigo Almeida e Christian


Abs,

JC

Wednesday, June 02, 2010

Client do Oracle 11gR2 no Ubuntu 10.04

Instalei o client do Oracle 11gR2 no meu Ubuntu 10.04.

Rodando certinho...

jcorrea@ubuntu:/$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 2 17:38:59 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL>; exit
jcorrea@ubuntu:/$ tnsping stewie

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-JUN-2010 17:39:13

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/jcorrea/product/11.2.0/client_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.36.2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = stewie)))
OK (10 msec)

jcorrea@ubuntu:/$ oerr ora 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause:  The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener.  This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
//  - Wait a moment and try to connect a second time.
//  - Check which services are currently known by the listener by executing:
//    lsnrctl services
//  - Check that the SERVICE_NAME parameter in the connect descriptor of the
//    net service name used specifies a service known by the listener.
//  - If an easy connect naming connect identifier was used, check that
//    the service name specified is a service known by the listener.
//  - Check for an event in the listener.log file.

jcorrea@ubuntu:/$ oerr ora 1555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"
// *Cause: rollback records needed by a reader for consistent read are
//
   overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
//          setting. Otherwise, use larger rollback segments
jcorrea@ubuntu:/$