Database Control, Listener, iSQLplus e Instância
Iniciando e parando
1. Database Control
A. Para iniciar:
Entre no prompt de comando e digite:
[oracle@centos45 ~]$ emctl start dbconsole
Deverá aparecer a seguinte resposta:
| Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. http://centos45.localdomain:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control ………………. started. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/ centos45.localdomain_orcl/sysman/log |
Note o texto em vermelho, é por este link que você entrará no Database Control
B. Para parar:
[oracle@centos45 ~]$ emctl stop dbconsole
| Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. http://centos45.localdomain:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control …… Stopped. |
2. Listener:
A. Pelo prompt:
i. Iniciando:
[oracle@centos45 ~]$ lsnrctl start
| LSNRCTL for Linux: Version 10.2.0.1.0 – Production on
19-MAR-2008 02:37:05 Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait… TNSLSNR for Linux: Version 10.2.0.1.0 – Production System parameter file is /u01/app/oracle/product/10.2.0/db_1/ network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.2.0/db_1/ network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=centos45.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ———————— Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production Start Date 19-MAR-2008 02:37:05 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/ network/admin/listener.ora Listener Log File /u01/app/oracle/product/10.2.0/db_1/ network/log/listener.log Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=centos45.localdomain)(PORT=1521))) Services Summary… Service “PLSExtProc” has 1 instance(s). Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service… The command completed successfully |
ii. Parando:
[oracle@centos45 ~]$ lsnrctl stop
| LSNRCTL for Linux: Version 10.2.0.1.0 -
Production on 19-MAR-2008 02:37:22 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp) (HOST=)(PORT=1521))The command completed successfully |
B. Pelo Database Control:
i. Iniciando:
1. Acesso o endereço do Database Control destacado acima;
2. Clique em Start Listener
3. Coloque as credenciais do Host (nome e senha do servidor):
4. Veja o resultado:
ii. Parando:
1. Depois que o BD estiver no ar, entre na página no Listener pelo link destacado abaixo:
2. Clique em stop;
3. Banco de Dados
A. Pelo prompt: veja este post
B. Pelo Database Control:
i. Clique em Startup
ii. Informe as credenciais do Host e as do sysdba;
iii. Clique em Ok;
iv. Clique em Yes;
4. iSQL*Plus
(Somente pelo Prompt)
a. Iniciando:
[oracle@centos45 ~]$ isqlplusctl start
| iSQL*Plus 10.2.0.1.0Copyright (c) 2003, 2005, Oracle.
All rights reserved. Starting iSQL*Plus … iSQL*Plus started. |
b. Parando:
[oracle@centos45 ~]$ isqlplusctl stop
| iSQL*Plus 10.2.0.1.0 Copyright (c) 2003, 2005, Oracle.
All rights reserved.Stopping iSQL*Plus … iSQL*Plus stopped. |
Para entrar:
Nenhum comentário ainda.