404
«
»
2008
21
mar

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

clip_image001

3. Coloque as credenciais do Host (nome e senha do servidor):

clip_image002

4. Veja o resultado:

clip_image003

ii. Parando:

1. Depois que o BD estiver no ar, entre na página no Listener pelo link destacado abaixo:

clip_image004

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:

clip_image005

Publicado em Administração | por Carlos Kich
deixar uma resposta | trackback

RSS feed | Trackback URI

Comentários »

Nenhum comentário ainda.

Nome (requerido)
Email (requerido - mas nunca mostrado publicamente)
URI
Seu comentário (tamanho pequeno | tamanho grande)
Viagra Cialis Levitra Kamagra tretinoin cream accutane buy viagra