Pesquisar neste blog

sexta-feira, 15 de maio de 2009

Oracle 11g - Inicializando a Console do Oracle Interprise Manager

Olá pessoal, hoje vou deixar uma dica de como inicializar a console via web do Oracle 11g através dos seguintes passos baixo:

1) Startup db

Os procedimentos abaixo demostram como inicializar uma instância, ou seja, uma base de bados através do seu SID. Se caso você tinha várias instâncias, ou seja, várias bases você deve alterar o parâmetro ORACLE_SID de acordo com o nome da sua instância para incializá-la, repetir o mesmo procedimento abaixo para cada base.

[oracle@server ~]$ ORACLE_SID=oracle; export ORACLE_SID
[oracle@server ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sun Nov 9 22:52:26 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup;
ORACLE instance started.
Total System Global Area 1389391872 bytes
Fixed Size 1299848 bytes
Variable Size 838863480 bytes
Database Buffers 536870912 bytes
Redo Buffers 12357632 bytes
Database mounted.
Database opened.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

2) listener start

Execute o comando abaixo e aguarde seu término.

[oracle@server ~]$ ORACLE_SID=oracle; export ORACLE_SID
[oracle@server ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 09-MAI-2009 22:52:00
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /home/oracle/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.1.0.6.0 – Production
System parameter file is /home/oracle/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/app/oracle/diag/tnslsnr/isc/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.net)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 09-NOV-2008 22:52:03
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/isc/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.net)(PORT=1521)))
The listener supports no services
The command completed successfully


3)Oracle Enterprise Manager start

[oracle@server ~]$ ORACLE_SID=oracle; export ORACLE_SID
[oracle@server ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://oracle.domain.net:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ………… started.
——————————————————————
Logs are generated in directory /home/oracle/app/oracle/product/11.1.0/db_1/oracle.domain.net_oracle/sysman/log

4) Teste
browser : https://oracle.domain.net:1158/em/
oracle.domain.net : 172.10.10.10



Um comentário:

Renato F. O. Silva disse...

Valeu pela dica man! Só assim consegui subir o Enterprise Manager.