14 Temmuz 2010 Çarşamba

Redo log Dosyalarında Bozulma (ORA-00312)

O an kullanılmayan (statusu current olmayan) Redo log dosyalarında bozulma olursa, Archiver redo log dosyasını kullanmaya çalıştığında durur ve veritabanı DML işlemini tamamlayamaz. Örnek bir redo log bozulması durumunda alert log’da göreceğimiz mesajlara bakalım:

Errors in file /oracle/diag/rdbms/oratest/oratest/trace/oratest_arc3_10426.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘/oracle/oradata/oratest/redo01.log’
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Bu durumda yapılması gereken hatalı olan redo logları sıfırlamaktır. Hata mesajlarında görüldüğü üzere 1. gruptaki redo log dosyasında (redo1.log) problem var. Bozulmuş olan redo log dosyasını aşağıdaki komutlar ile temizleyebilirsiniz:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE ‘/oracle/oradata/oratest/redo1.log’;

veya

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
Alternatif olarak bu log dosyasını DROP edip yeniden oluşturabilirsiniz. Log file’ı temizlerken kullanılan UNARCHIVED parametresi, log file’ın henüz archivelenmediğini, yeniden kullanıldıktan sonra arşivleme yapılmasının istendiğini gösterir. Bu işlemden sonra archiever prosesi çalışmaya devam edecektir:

Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE group 1
Wed May 26 22:50:43 2009
Archiver process freed from errors. No longer stopped
Wed May 26 22:50:50 2009
Starting background process SMCO
Wed May 26 22:50:50 2009
SMCO started with pid=15, OS id=16754
Wed May 26 22:52:41 2009
Thread 1 cannot allocate new log, sequence 14
Private strand flush not complete
Current log# 1 seq# 13 mem# 0: /oracle/oradata/oratest/redo01.log
Thread 1 advanced to log sequence 14 (LGWR switch)
Current log# 2 seq# 14 mem# 0: /oracle/oradata/oratest/redo02.log
Thread 1 cannot allocate new log, sequence 15
Checkpoint not complete
Archiver prosesi çalışmasına devam etmesine rağmen eğer “checkpoint not complete” uyarısı veriyorsa manuel olarak checkpoint yaptırmamız gerekir:

ALTER SYSTEM CHECKPOINT;
Eğer sorunlu olan redo log dosyası “o an kullanımda olan” (statusu current) redolog dosyası ise hata archiver yerine logwiter (LGWR) prosesi tarafından tespit edilecek ve veritabanı kapanacaktır. Yeniden açtığınız zaman veritabanı, redo log’un silinmesine izin vermez. Bu durumda recovery işlemi yapmanız gerekir:

RMAN> RESTORE DATABASE;
SQL> RECOVER DATABASE UNTIL CANCEL;
SQL> ALTER DATABASE OPEN RESETLOGS;
---------------------------------------
http://www.gokhanatil.com/2009/07/redo-log-dosyalarinda-bozulma-ora-00312/

8 Temmuz 2010 Perşembe

CP of Datafile for Online Backup Returns "A system call received a parameter that is not valid."

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.3
AIX5L Based Systems (64-bit)

Symptoms
Coping a datafile after a 'begin backup' with the database is open returns an error:
A system call received a parameter that is not valid.


Cause
This problem is caused with the use of JFS2 file systems, CIO not enabled, and the parameter FILESYSTEMIO_OPTIONS set to SETALL.

Note 272520.1 - Direct I/O or Concurrent I/O on AIX 5L:
External utilities or tools cannot read datafiles on JFS2 file systems if you use the values SETALL or DIRECTIO for the FILESYSTEMIO_OPTIONS parameter. For more information, refer to the AIX
documentation which covers the open() restriction in cio mode.


Solution
1. Enable CIO on JFS2 file system

OR

2. Change FILESYSTEMIO_OPTIONS=asynch


Since its a dynamic initialization parameter you can use the ALTER SESSION,
ALTER SYSTEM commands to do this.

Parameter type
String

Syntax
FILESYSTEMIO_OPTIONS = {none | setall | directIO | asynch}

Default value
There is no default value.

Parameter class
Dynamic: ALTER SESSION, ALTER SYSTEM


References
Note 257338.1 - Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L
Note 272520.1 - Direct I/O or Concurrent I/O on AIX 5L
----------------------------------------------------
http://ebsblog.blog.163.com/blog/static/127949789200981533133531/
http://forums.sdn.sap.com/message.jspa?messageID=3129195

26 Haziran 2010 Cumartesi

Solaris Oracle kurulumu Hazırlıkları

network ip sabitleme;
/etc/hostname
/etc/hosts
/etc/nodename
----------------------
Creating Required Operating System Groups and Users

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper
id nobody
id -a oracle
useradd -g oinstall -G dba,oper -m -d /export/home/oracle -s /bin/bash oracle
# id -p
uid=0(root) gid=0(root) projid=1(user.root)
# prctl -n project.max-sem-ids -i project user.root
#prctl -n project.max-shm-memory -i project 1
#prctl -n project.max-shm-memory -v 6gb -r -i project 1
#projadd -p 101 -c 'ORA DBA' -U oracle -G dba -K 'project.max-shm-memory=(privileged,6G,deny)' ORA
/etc/user_attr
oracle::::project=ORA
id -p
uid=100(oracle) gid=100(oinstall) projid=101(ORA)
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
--swap alanı ekleme
swap -l
zfs create -V 1G -b 4k rpool/swap2
zfs volsize=1G rpool/swap2
swap -a /dev/zvol/dsk/rpool/swap2
http://docs.sun.com/app/docs/doc/817-5093/gizfl?a=view

TDP for Oracle for Solaris RMAN backup

root>pkgadd -d TIVsmCapi.pkg
root>./TDPoraclex86.bin
set LD_LIBRARY_PATH=$ORACLE_HOME/lib
shutdown db
$ ln -s /usr/lib/amd64/libobk.so $ORACLE_HOME/lib/libobk.so
$ ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so $ORACLE_HOME/lib/libobk.so
veya
ln -s /opt/tivoli/tsm/client/oracle/bin/libobk.so $ORACLE_HOME/lib/libobk.so
start db
/usr/bin/dsm.opt
SERVERNAME TBM
traceflag config
tracefile /export/home/oracle/log/tsm_trace.out /opt/tivoli/tsm/client/oracle/bin64
/usr/bin/dsm.sys
SErvername TBM
COMMMethod TCPip
TCPPort 1500
TCPServeraddress ipaddress
NODENAME TBM
PASSWORDACCESS prompt
COMPRESSION yes
root ile
Export DSMO_NODE=TBM
Export DSMI_CONFIG=/usr/bin/dsm.opt
Export DSMI_LOG=/opt/tivoli/tsm/client/oracle/bin
DSMI_DIR
/opt/tivoli/tsm/client/oracle/bin/tdp.opt
DSMI_ORC_CONFIG /usr/bin/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
TDPO_FS orc8_db
TDPO_NODE TBMI
TDPO_OWNER root
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
resolv.conf
nsswitch.conf
/opt/tivoli/tsm/client/oracle/bin/tdpoconf password veya showenv
backup;
shutdown immediate;
startup mount;
--------------------------
hata verirse log dosyasına yazma izni verilmesi yeterli!
--------------------------
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
format 'df_%t_%s_%p'
(database);
}

run
{
allocate channel 'c1' device type sbt_tape
PARMS='SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin/libobk.so';
}

24 Haziran 2010 Perşembe

TDP for Oracle for Windows RMAN backup

1. Register a node on the TSM server.
register node nodename password domain=domainname
parola-123
2. Stop all Oracle services.
OK
3. Install TDP for Oracle for Windows.
E diskine kuruldu
4. Configure the client options file (dsm.opt).
commmethod tcpip
tcpport 1500
TCPServeraddress ip
Nodename TBMI
passwordaccess generate
5. Generate the encrypted password using aobpswd.exe.
E:\Program Files\Tivoli\TSM\AgentOBA\tdpoconf password - 123
E:\Program Files\Tivoli\TSM\AgentOBA\tdpoconf show
6. Test a TDP for Oracle for Windows RMAN backup.
set ORACLE_HOME
rman nocatalog
connect target user/pass@
shutdown immediate
startup mount
ora12514
lissner
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(GLOBAL_DBNAME = orcl)
)

run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(DSMO_DEBUG=49)';
backup (database);}
rman>list backup;
tsm>q occupancy
tsm>select * from backups where node_name='nodename'
rman>allocate channel for delete type 'sbt_tape';
rman>list backup;
rman>change backuppiece '03lh1hgg_1_1' delete; -tsm LL_NAME:03lh1hgg_1_1
rman>change backuppiece '06lh1meb_1_1' delete;
ANS4994S DP Oracle Win32 ANU0599 TDP for Oracle: (848): => () ANS1126E (RC27) The
file space cannot be deleted because this node does not have
permission to delete archived or backed up data.
tsm>update node backdel=y

7. Install the TSM backup-archive client (optional).

job listesi

EXEC dbms_job.broken(jobno, FALSE);
select job,broken from user_jobs;
select text from user_source
where type = 'PROCEDURE'
and name = procedure_name;
SELECT text FROM all_source WHERE name like '%CTRL%';

SQL> CREATE OR REPLACE PROCEDURE CTRL IS
2 begin
3 dbms_utility.exec_ddl_statement('alter database backup controlfile to trace as ''/oracle/yedek/ctrlbackup.trc'' reuse');
4 end CTRL;
5 /

Procedure created.

SQL> execute CTRL;
SQL> SET ARRAYSIZE 1
SQL> SET MAXDATA 60000
SHOW ERRORS PROCEDURE
DROP PROCEDURE

23 Haziran 2010 Çarşamba

sqlplus ile bağlanma methodları

sqlplus system/pass@tnsnames_sid

sqlplus system/pass@//host:port/SID

sqlplus system/pass@'(description=(address=(protocol=tcp)(host=host_name)(port=port_))
(connect_data=(server=dedicated)(service_name=SID)))'

28 Mayıs 2010 Cuma

SAP -sm37 tablo bilgileri

SELECT
*
FROM
TBTCP --as of timestamp to_timestamp('29/05/2010 07:00', 'DD/MM/Yyyy hh24:mi')
where jobname like 'Z100%GERC%'

SELECT
*
FROM
V_OP --as of timestamp to_timestamp('29/05/2010 07:00', 'DD/MM/Yyyy hh24:mi')
where jobname like 'Z100%GERC%'

FROM "TBTCO" T0001, "TBTCP" T0002
WHERE T0001."JOBNAME" = T0002."JOBNAME"
AND T0001."JOBCOUNT" = T0002."JOBCOUNT";


create table ZTBTCO
as select * from TBTCO

14 Nisan 2010 Çarşamba

Oracle - redo log group eklem

SELECT * FROM V$LOG;
select GROUP#,MEMBER,TYPE from v$logfile order by 1 ;

ALTER DATABASE ADD LOGFILE GROUP 5 ('/oracle/sid/origlogA/log_g15m1.dbf','/oracle/sid/origlogA/log_g15m2.dbf') size 100M;

alter database drop logfile group 5;
--------------------veya;
ALTER DATABASE ADD LOGFILE GROUP 5 ('/oracle/sid/origlogA/log_g15m1.dbf') size 100M;

alter database add logfile member '/oracle/sid/origlogA/log_g15m2.dbf' to group 5 ;

alter database drop logfile member '/oracle/sid/origlogA/log_g15m2.dbf'
-----------------------
ALTER DATABASE CLEAR LOGFILE GROUP 5;

If the corrupt redo log file has not been archived, use the UNARCHIVED keyword in the statement.

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

http://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/server.111/b28310/onlineredo003.htm

Oracle - iostat, vmstat , filestat ve çift kayıt silme

http://adminschoice.com/iostat-vmstat-netstat
http://vsbabu.org/oracle/sect02.html
http://www.dba-oracle.com/art_disk_iostat.htm
https://netfiles.uiuc.edu/jstrode/www/oraview/V$FILESTAT.html
http://download-uk.oracle.com/docs/cd/F49540_01/DOC/server.815/a67775/ch20_io.htm#2688
------------------------------
create table SAPSR3.zTPALOG as select * from SAPSR3.TPALOG

SAPSR3.CSMCLSMAP

WHERE ROWID IN (
SELECT t.ROWID AS targetrowid
FROM TEST t,
(SELECT tst_id, tst_name, MAX (ROWID) AS maxrowid
FROM SAPSR3.TPALOG
GROUP BY tst_id, tst_name
HAVING COUNT (*) > 1) m
WHERE t.ROWID != m.maxrowid AND t.tst_id = m.tst_id)

SELECT MAX (ROWID) AS maxrowid
FROM SAPSR3.TPALOG

SELECT TRTIME, TRKORR, TARSYSTEM,TRCLI,TRSTEP,ALLCLI,PROJECT,TRUSER,RETCODE,HOST,ADMIN,TPSTAT_KEY,LINESeQUENCE
FROM SAPSR3.TPALOG
GROUP BY TRTIME, TRKORR, TARSYSTEM,TRCLI,TRSTEP,ALLCLI,PROJECT,TRUSER,RETCODE,HOST,ADMIN,TPSTAT_KEY,LINESeQUENCE
HAVING count('x') > 1;


create table SAPSR3.TPALOG as

create table SAPSR3.TPALOG2 as select distinct * from SAPSR3.TPALOG
create table SAPSR3.TPALOG tablespace PSAPSR3 as select distinct * from SAPSR3.TPALOG2

drop table SAPSR3.TPALOG

rename SAPSR3.TPALOG2 to SAPSR3.TPALOG;

select * from sapsr3.CSMCLSMAP

Oracle -audit komutları

select * from SYS.AUD$
select * from DBA_AUDIT_TRAIL

DELETE FROM SYS.AUD$;

SELECT sql_text FROM dba_common_audit_trail;
-------------------------------
AUDIT ALL BY sapsr3

AUDIT SESSION BY sapsr3 by access;

AUDIT SELECT TABLE, UPDATE TABLE BY SAPSR3 BY ACCESS;

AUDIT select ANY TABLE;

AUDIT SELECT, INSERT, DELETE
ON sapsr3.vbak
BY ACCESS
WHENEVER SUCCESSFUL;
----------------------------
select * from sys.fga_log$


AUDIT SESSION
BY SAPSR3

NOAUDIT session;

NOAUDIT ALL;


SELECT * FROM DBA_PRIV_AUDIT_OPTS; -- aktif auditleri gosterir.

http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14266/cfgaudit.htm

Oracle - session, process sayisi

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5671284058977

ps -auxww | grep

set autotrace on statistics;
select username from v$session where username is not
null;

(1.1*processes)+5. That means process=415 will give me sessions=461

300 - 335

ps -eaf
-------------------------------------------
the number of dirty buffers that are waiting to be written;

select dirty, count(*) from v$bh group by dirty;
update big_table.big_table set id=id where rownum < 1000;
select dirty, count(*) from v$bh group by dirty;
alter system checkpoint;
select dirty, count(*) from v$bh group by dirty;
-------------------------------------------------
alter session set sql_trace=true;

select p.spid
from v$session s, v$process p
where s.paddr = p.addr
and s.audsid = userenv('sessionid');


---------------------------------
select username,count(*)
from v$session
group by username;
select *
from v$resource_limit
where resource_name in ('processes','sessions');

30 Mart 2010 Salı

oracle ornek komutlar- unix için kurulum

select * from dba_registry_history
---------------------------------
select * from dba_audit_trail a
where
a.username='SYS' and
a.logoff_time> sysdate - 100
----------------------------
groupadd -g 102 dba
useradd -d /export/home/oruser -m -s /bin/bash -g dba -u 101 orauser
passwd orauser
usermod -u 101 orauser

ls -alF /export/home/orauser
chown -R orafmi /export/home/orauser
ORACLE_HOME ve ORACLE_SID set
mkdir oracle
ls -alF /oracle
chown -R orauser /oracle
vi /etc/system
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256

http://download.oracle.com/docs/cd/B19306_01/install.102/b15697/pre_install.htm#BABIBGFA

id -p
prctl -n project.max-shm-memory -i project 101

-prctl -n project.max-shm-memory -r -v 24gb -i project 100

projadd -p 101 -c 'ORA_DBA' -U orauser -G dba -K 'project.max-shm-memory=(privileged,6G,deny)' ORA

etc/user_attr
orasti::::project:ORA

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:454420165038
-------------------------------------
http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnSolaris10.php
usermod -K project=OABS oracle
user_attr

17 Şubat 2010 Çarşamba

Oracle conrole file yaratma

iki şekilde control file yaratılır.
trace ile yaratma üzerine duracağız;
alter database backup controlfile to trace; dememiz yeterli.
oluşturduğumuz control file scriptini oluşturabilememiz için datafileların mevcut olması gerekir. özellikle sistem datafile nin header kısmına bakacaktır...

27 Ocak 2010 Çarşamba

plan table

SQL> explain plan for select count(*) from tablo;
SQL> @?/rdbms/admin/utlxpls.sql

On version up to and including 9i, use the utlxplan.sql script to createthe plan table as instructed below.
SQL> @?/rdbms/admin/utlxplan
On 10g and above there is a new script - catplan.sql - to create the plan
table that creates a public plan table as a global temporary table
accessible from any schema.
SQL> @?/rdbms/admin/catplan
Note that the plan table format can change between versions so ensure
that it is created using the utlxplan script from the current version.

sapnotes:#1303908

4 Ocak 2010 Pazartesi

instance bilgileri sql komutları

SELECT NAME, description FROM v$bgprocess ORDER BY NAME, description

select * from v$version
where banner like 'Oracle%';


select * from v$database

select * from v$license;

select * from v$version;

rman tsm backup

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/sid/102_64/dbs/snapcf_BPD.f'; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/sid/yedek/ora_df_%t_%s_%p';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/sid/yedek/%F';
CONFIGURE BACKUP OPTIMIZATION ON;



CONFIGURE DEFAULT DEVICE TYPE TO TSM;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'TSM' TO 'AUTOBACKUP_%F';
CONFIGURE DEVICE TYPE TSM PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE TSM TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' PARMS 'ENV=(tdpo_optfile=/usr/tivoli/tsm/tdp_r3/ora64/dsm.sys)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
CONFIGURE CHANNEL DEVICE TYPE 'BOYDAKTSM' PARMS 'ENV=(tdpo_optfile=TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';


XINT_PROFILE=//init.utl,PROLE_PORT=portnumber

CONFIGURE CHANNEL DEVICE TYPE 'TSM' MAXPIECESIZE 100 M;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' clear;

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(tdpo_optfile=/tsm/conf/client/tdpo.opt.tst)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';



SHOW CHANNEL FOR DEVICE TYPE TSM;

http://forums.oracle.com/forums/thread.jspa?threadID=697031

v$backup_device


CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=tape_svr, NSR_CLIENT=oracleclnt, NSR_GROUP=oracle_tapes)' FORMAT "BACKUP_%U";

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/api/bin/dsm.sys.smp)';

solaris oracle kurulumu

phgadd -d . SUNWbtool
http://ivan.kartik.sk/oracle/install_ora10gR2_solaris.html
http://blogs.sun.com/mandalika/entry/oracle_on_solaris_10_fixing
useradd -R printadm -m -d /export/deneme -s /usr/bin/bash deneme
http://www.kobhi.com/solaris/user_management/solaris_user_modify.htm
http://belgeler.org/lis/archive-tlkg-lis-7.2.html
http://www.ugurileri.com/2009/05/solaris-10da-network2u-restart-etmek.html
http://forums.oracle.com/forums/thread.jspa?threadID=382389
http://www.lazydba.com/oracle/0__53774.html

ifconfig -a pcn0

netstat -rn
route add default 10.200.0.111
etc/defaultrouter 10.200.0.111

/etc/nsswitch.conf host files dns
/etc/resolv.conf - nameserver -ip-

oracle enterprise manager

emca -config dbcontrol db -repos create -- manager console oluşturulur

emca -deconfig dbcontrol db -repos drop -- console silinir.


1) Set the environment variable ORACLE_SID to SID
2) /oracle/SID/102_64/bin/emctl stop dbconsole
3) /oracle/SID/102_64/bin/emctl config emkey -repos -sysman_pwd pass < Password for SYSMAN user >
4) /oracle/SID/102_64/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user >
5) /oracle/SID/102_64/bin/emctl start dbconsole