Create sysman user manually.
Dear Sir,
i'm trying to create a new database under oracle linux enterprise 6 with the folowing command:
*1- create database*
connect "SYS"/"&&sysPassword" as SYSDBA
startup nomount pfile="/u02/app/oracle/admin/oramh/scripts/init.ora";
create database oramh
USER SYS IDENTIFIED BY "&&sysPassword"
USER SYSTEM IDENTIFIED BY "&&systemPassword"
logfile group 1 ('/u01/app/oracle/oradata/oramh/red01.log','/u01/app/oracle/oradata/oramh/red0102.log','/u01/app/oracle/oradata/oramh/red0103.log','/u01/app/oracle/oradata/oramh/red0104.log') size 1024M,
group 2 ('/u01/app/oracle/oradata/oramh/red02.log','/u01/app/oracle/oradata/oramh/red0202.log','/u01/app/oracle/oradata/oramh/red0203.log','/u01/app/oracle/oradata/oramh/red0204.log') size 1024M,
group 3 ('/u01/app/oracle/oradata/oramh/red03.log','/u01/app/oracle/oradata/oramh/red0302.log','/u01/app/oracle/oradata/oramh/red0303.log','/u01/app/oracle/oradata/oramh/red0304.log') size 1024M
character set AR8ISO8859P6
national character set AL16UTF16
datafile '/u01/app/oracle/oradata/oramh/system01.dbf'
size 4000M
autoextend off
extent management local
sysaux datafile '/u01/app/oracle/oradata/oramh/sysaux01.dbf'
size 4000M
autoextend on
next 10M
maxsize unlimited
BIGFILE undo tablespace UNDOTBS
datafile '/u01/app/oracle/oradata/oramh/undotbs01.dbf'
size 4000 M
autoextend on
next 10M
maxsize unlimited
BIGFILE DEFAULT temporary tablespace TEMP1
tempfile '/u01/app/oracle/oradata/oramh/temp101.dbf'
size 6000M
autoextend off;
*2- CreateDBCatalog*
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql;
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catblock.sql;
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql;
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catoctk.sql;
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/owminst.plb;
@/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/help/hlpbld.sql helpus.sql;
*3- emrepository.sql*
DEFINE sysPassword = 'man'(char)
DEFINE sysmanPassword = 'sysman'(char)
DEFINE dbsnmpPassword = 'dbsnmp'(char)
connect "SYS"/"&&sysPassword" as SYSDBA
@/u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/sql/emreposcre /u01/app/oracle/product/10.2.0/db_1 SYSMAN &&sysmanPassword TEMP ON;
and when the script reach
dbms_registry.load(‘EM’);
it's give me an error 'EM' not registred
any ideas?!
regards,