Re: [oracle_br] Erro no Create Database - Ainda continua :(
Alex,
O problema foi com seu arquivo de senha para a instância. Faça o seguinte:
Se estiver se autenticando por sistema operacional, ex: sqlplus / as
sysdba
Altere o valor do parâmetro remote_login_passwordfile = NONE e apague o
PWDRHC.ora do SO.
Refazer toda a construção do database, apague os datafiles e etc... e
construa novamente e veja o resultado.
ou
Utilize a mesma senha do PASSWORDFILE para o usuário SYS.
Abraços,
Rodrigo Almeida
On 12/4/06, Alex Ferreira [EMAIL PROTECTED] wrote:
Olá Rodrigo,
Segue o conteúdo:
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 0
control_files = C:\oracle\oradata\TESTE\control01.ctl,
C:\oracle\oradata\TESTE\control02.ctl,
C:\oracle\oradata\TESTE\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = TESTE
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\TESTE\bdump
user_dump_dest = C:\oracle\admin\TESTE\udump
core_dump_dest = C:\oracle\admin\TESTE\cdump
sort_area_size = 524288
db_name = TESTE
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Dec 04 20:48:11 2006
CREATE DATABASE TESTE
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *OGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 2
DATAFILE
'C:/ORACLE/ORADATA/TESTE/SYSTEM01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/TESTE/TEMP01.DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT
640K
MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE 'C:/ORACLE/ORADATA/TESTE/UNDOTBS01.DBF' SIZE 200M REUSE
AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('C:/ORACLE/ORADATA/TESTE/REDO01.LOG') SIZE 100M,
GROUP 2 ('C:/ORACLE/ORADATA/TESTE/REDO02.LOG') SIZE 100M,
GROUP 3 ('C:/ORACLE/ORADATA/TESTE/REDO03.LOG') SIZE 100M
Mon Dec 04 20:48:11 2006
Database mounted in Exclusive Mode.
Mon Dec 04 20:48:18 2006
Successful mount of redo thread 1, with mount id 4201073483
Assigning activation ID 4201073483 (0xfa674b4b)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\ORACLE\ORADATA\TESTE\REDO01.LOG
Successful open of redo thread 1
Mon Dec 04 20:48:18 2006
SMON: enabling cache recovery
Mon Dec 04 20:48:18 2006
create tablespace SYSTEM datafile
'C:/ORACLE/ORADATA/TESTE/SYSTEM01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Mon Dec 04 20:48:21 2006
Completed: create tablespace SYSTEM datafile
'C:/ORACLE/ORAD
Mon Dec 04 20:48:21 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon Dec 04 20:48:28 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE
'C:/ORACLE/ORADATA/TESTE/UNDOTBS01.DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT
5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:/ORAC
Mon Dec 04 20:48:32 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/TESTE/TEMP01.DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT
640K
MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:/ORA
Mon Dec 04 20:48:32 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Mon Dec 04 20:48:33 2006
SMON: enabling tx recovery
Mon Dec 04 20:48:35 2006
Errors in file c:\oracle\admin\teste\udump\rhc_ora_2444.trc:
ORA-01501: CREATE DATABASE falhou
ORA-01991: arquivo 'C:\oracle\ora92\DATABASE\PWDrhc.ORA' de senha invalido
Mon Dec 04 20:48:35 2006
Error 1991 happened during db open, shutting down database
USER: terminating instance due to error 1991
Mon Dec 04 20:48:35 2006
Errors in file c:\oracle\admin\teste\bdump\rhc_pmon_4000.trc:
ORA-01991: invalid password file ''
Instance terminated by USER, pid = 2444
ORA-1092 signalled during: CREATE DATABASE TESTE
USER SYS IDENTIFIED BY *USER...
- Original Message -
From: Rodrigo Almeida
To: oracle_br@yahoogrupos.com.br oracle_br%40yahoogrupos.com.br
Sent: Monday, December 04, 2006 8:06 PM
Subject: Re: [oracle_br] Erro no Create Database
Re: [oracle_br] Erro no Create Database - Ainda continua :(
Olá Pessoal,
Era o arquivo de senha mesmo
Obrigado pela ajuda!!!
Abraços!!
Alex
- Original Message -
From: Diego Nolasco
To: oracle_br@yahoogrupos.com.br
Sent: Tuesday, December 05, 2006 9:28 AM
Subject: Res: [oracle_br] Erro no Create Database - Ainda continua :(
Você esta com o parâmetro
REMOTE_LOGIN_PASSWORDFILE=exclusive
setado no init.ora e seu orapw deve tar corrompido
simplesmente execute o comando abaixo para recriá-lo, a senha que vc bota em
password vai se tornar a nova senha do usuário sys e entries eh igual ao numero
de usuários sysdba que vc tera no seu banco, lembre-se que caso vc estoure esse
número terá que recriar o orapwd, o que fará com que todos os usuários com
sysdba já setados percam seus privilégios de sysdba, ou seja, terá que dar
grant em todos novamente
orapwd file=C:\oracle\ora92\ DATABASE\orapwdRHC.ora password=mypasswd
entries=15
- Mensagem original
De: Alex Ferreira [EMAIL PROTECTED]
Para: oracle_br@yahoogrupos.com.br
Enviadas: Segunda-feira, 4 de Dezembro de 2006 20:50:23
Assunto: Re: [oracle_br] Erro no Create Database - Ainda continua :(
Olá Rodrigo,
Segue o conteúdo:
LICENSE_MAX_ SESSION = 0
LICENSE_SESSIONS_ WARNING = 0
SCN scheme 2
Using log_archive_ dest parameter default value
LICENSE_MAX_ USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_ size = 50331648
large_pool_size = 8388608
java_pool_size = 0
control_files = C:\oracle\oradata\ TESTE\control01. ctl,
C:\oracle\oradata\ TESTE\control02. ctl, C:\oracle\oradata\ TESTE\control03.
ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_ read_count= 16
fast_start_mttr_ target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_ passwordfile= EXCLUSIVE
db_domain =
instance_name = TESTE
hash_join_enabled = TRUE
background_dump_ dest = C:\oracle\admin\ TESTE\bdump
user_dump_dest = C:\oracle\admin\ TESTE\udump
core_dump_dest = C:\oracle\admin\ TESTE\cdump
sort_area_size = 524288
db_name = TESTE
open_cursors = 300
star_transformation _enabled= FALSE
query_rewrite_ enabled = FALSE
pga_aggregate_ target = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Dec 04 20:48:11 2006
CREATE DATABASE TESTE
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *OGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 2
DATAFILE
'C:/ORACLE/ORADATA/ TESTE/SYSTEM01. DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/ TESTE/TEMP01. DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE 'C:/ORACLE/ORADATA/ TESTE/UNDOTBS01. DBF' SIZE 200M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('C:/ORACLE/ ORADATA/TESTE/ REDO01.LOG' ) SIZE 100M,
GROUP 2 ('C:/ORACLE/ ORADATA/TESTE/ REDO02.LOG' ) SIZE 100M,
GROUP 3 ('C:/ORACLE/ ORADATA/TESTE/ REDO03.LOG' ) SIZE 100M
Mon Dec 04 20:48:11 2006
Database mounted in Exclusive Mode.
Mon Dec 04 20:48:18 2006
Successful mount of redo thread 1, with mount id 4201073483
Assigning activation ID 4201073483 (0xfa674b4b)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\ORACLE\ORADATA\ TESTE\REDO01. LOG
Successful open of redo thread 1
Mon Dec 04 20:48:18 2006
SMON: enabling cache recovery
Mon Dec 04 20:48:18 2006
create tablespace SYSTEM datafile
'C:/ORACLE/ORADATA/ TESTE/SYSTEM01. DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Mon Dec 04 20:48:21 2006
Completed: create tablespace SYSTEM datafile
'C:/ORACLE/ORAD
Mon Dec 04 20:48:21 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon Dec 04 20:48:28 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE
'C:/ORACLE/ORADATA/ TESTE/UNDOTBS01. DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT
5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:/ORAC
Mon Dec 04 20:48:32 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/ TESTE/TEMP01. DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:/ORA
Mon Dec 04 20:48:32 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Re: [oracle_br] Erro no Create Database - Ainda continua :(
cara..
veja seu alert.log
abçs..
- Original Message -
From: Diego Nolasco
To: oracle_br@yahoogrupos.com.br
Sent: Tuesday, December 05, 2006 9:28 AM
Subject: Res: [oracle_br] Erro no Create Database - Ainda continua :(
Você esta com o parâmetro
REMOTE_LOGIN_PASSWORDFILE=exclusive
setado no init.ora e seu orapw deve tar corrompido
simplesmente execute o comando abaixo para recriá-lo, a senha que vc bota em
password vai se tornar a nova senha do usuário sys e entries eh igual ao numero
de usuários sysdba que vc tera no seu banco, lembre-se que caso vc estoure esse
número terá que recriar o orapwd, o que fará com que todos os usuários com
sysdba já setados percam seus privilégios de sysdba, ou seja, terá que dar
grant em todos novamente
orapwd file=C:\oracle\ora92\ DATABASE\orapwdRHC.ora password=mypasswd
entries=15
- Mensagem original
De: Alex Ferreira [EMAIL PROTECTED]
Para: oracle_br@yahoogrupos.com.br
Enviadas: Segunda-feira, 4 de Dezembro de 2006 20:50:23
Assunto: Re: [oracle_br] Erro no Create Database - Ainda continua :(
Olá Rodrigo,
Segue o conteúdo:
LICENSE_MAX_ SESSION = 0
LICENSE_SESSIONS_ WARNING = 0
SCN scheme 2
Using log_archive_ dest parameter default value
LICENSE_MAX_ USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_ size = 50331648
large_pool_size = 8388608
java_pool_size = 0
control_files = C:\oracle\oradata\ TESTE\control01. ctl,
C:\oracle\oradata\ TESTE\control02. ctl, C:\oracle\oradata\ TESTE\control03.
ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_ read_count= 16
fast_start_mttr_ target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_ passwordfile= EXCLUSIVE
db_domain =
instance_name = TESTE
hash_join_enabled = TRUE
background_dump_ dest = C:\oracle\admin\ TESTE\bdump
user_dump_dest = C:\oracle\admin\ TESTE\udump
core_dump_dest = C:\oracle\admin\ TESTE\cdump
sort_area_size = 524288
db_name = TESTE
open_cursors = 300
star_transformation _enabled= FALSE
query_rewrite_ enabled = FALSE
pga_aggregate_ target = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Dec 04 20:48:11 2006
CREATE DATABASE TESTE
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *OGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 2
DATAFILE
'C:/ORACLE/ORADATA/ TESTE/SYSTEM01. DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/ TESTE/TEMP01. DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE 'C:/ORACLE/ORADATA/ TESTE/UNDOTBS01. DBF' SIZE 200M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('C:/ORACLE/ ORADATA/TESTE/ REDO01.LOG' ) SIZE 100M,
GROUP 2 ('C:/ORACLE/ ORADATA/TESTE/ REDO02.LOG' ) SIZE 100M,
GROUP 3 ('C:/ORACLE/ ORADATA/TESTE/ REDO03.LOG' ) SIZE 100M
Mon Dec 04 20:48:11 2006
Database mounted in Exclusive Mode.
Mon Dec 04 20:48:18 2006
Successful mount of redo thread 1, with mount id 4201073483
Assigning activation ID 4201073483 (0xfa674b4b)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\ORACLE\ORADATA\ TESTE\REDO01. LOG
Successful open of redo thread 1
Mon Dec 04 20:48:18 2006
SMON: enabling cache recovery
Mon Dec 04 20:48:18 2006
create tablespace SYSTEM datafile
'C:/ORACLE/ORADATA/ TESTE/SYSTEM01. DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Mon Dec 04 20:48:21 2006
Completed: create tablespace SYSTEM datafile
'C:/ORACLE/ORAD
Mon Dec 04 20:48:21 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon Dec 04 20:48:28 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE
'C:/ORACLE/ORADATA/ TESTE/UNDOTBS01. DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT
5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:/ORAC
Mon Dec 04 20:48:32 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/ TESTE/TEMP01. DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:/ORA
Mon Dec 04 20:48:32 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
[oracle_br] Erro no Create Database - Ainda continua :(
Pessoal,
Ainda continua dando erro, porém diferente. Estou tentando criar um BD para
estudos e faço esse procedimento:
1° - Crio os diretórios e variáveis:
MKDIR C:\ORACLE\ADMIN\TESTE
MKDIR C:\ORACLE\ADMIN\TESTE\bdump
MKDIR C:\ORACLE\ADMIN\TESTE\cdump
MKDIR C:\ORACLE\ADMIN\TESTE\create
MKDIR C:\ORACLE\ADMIN\TESTE\pfile
MKDIR C:\ORACLE\ADMIN\TESTE\udump
mkdir C:\oracle\oradata\TESTE
set ORACLE_SID=TESTE
[Ljava.lang.String;@2a966e
[Ljava.lang.String;@2a9683
C:\oracle\ora92\bin\orapwd.exe file=C:\oracle\ora92\database\PWDTESTE.ora
password=change_on_install
2° - Faço um SHUTDOWN no banco:
SQL SHUTDOWN IMMEDIATE
Banco de dados fechado.
Banco de dados desmontado.
Instância ORACLE desativada.
3° - Inicio usando o init.ora já configurado:
SQL STARTUP NOMOUNT PFILE='D:\ORACLE\CRIAR DATABASE RHC\scripts\initTESTE.ora';
Instância ORACLE iniciada.
Total System Global Area 101785284 bytes
Fixed Size 454340 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
4° - Quando eu jogo o script de criação do banco, ele cria os
arquivos(Controlfiles, Redo's e os DBFs), mas dá erro:
SQL CREATE DATABASE TESTE
2 USER SYS IDENTIFIED BY SYS
3 USER SYSTEM IDENTIFIED BY SYSTEM
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 3
6 MAXLOGHISTORY 1
7 MAXDATAFILES 100
8 MAXINSTANCES 2
9 DATAFILE
10 'C:/ORACLE/ORADATA/TESTE/SYSTEM01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
11 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/TESTE/TEMP01.DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
12 UNDO TABLESPACE UNDOTBS1
13 DATAFILE 'C:/ORACLE/ORADATA/TESTE/UNDOTBS01.DBF' SIZE 200M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
14 CHARACTER SET WE8MSWIN1252
15 NATIONAL CHARACTER SET AL16UTF16
16 LOGFILE
17 GROUP 1 ('C:/ORACLE/ORADATA/TESTE/REDO01.LOG') SIZE 100M,
18 GROUP 2 ('C:/ORACLE/ORADATA/TESTE/REDO02.LOG') SIZE 100M,
19 GROUP 3 ('C:/ORACLE/ORADATA/TESTE/REDO03.LOG') SIZE 100M;
CREATE DATABASE TESTE
*
ERRO na linha 1:
ORA-01092: instância ORACLE finalizada. Desconexão forçada
[As partes desta mensagem que não continham texto foram removidas]
Re: [oracle_br] Erro no Create Database - Ainda continua :(
Olá Rodrigo,
Segue o conteúdo:
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 0
control_files= C:\oracle\oradata\TESTE\control01.ctl,
C:\oracle\oradata\TESTE\control02.ctl, C:\oracle\oradata\TESTE\control03.ctl
db_block_size= 8192
db_cache_size= 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain=
instance_name= TESTE
hash_join_enabled= TRUE
background_dump_dest = C:\oracle\admin\TESTE\bdump
user_dump_dest = C:\oracle\admin\TESTE\udump
core_dump_dest = C:\oracle\admin\TESTE\cdump
sort_area_size = 524288
db_name = TESTE
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Dec 04 20:48:11 2006
CREATE DATABASE TESTE
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *OGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 2
DATAFILE
'C:/ORACLE/ORADATA/TESTE/SYSTEM01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/TESTE/TEMP01.DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE 'C:/ORACLE/ORADATA/TESTE/UNDOTBS01.DBF' SIZE 200M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('C:/ORACLE/ORADATA/TESTE/REDO01.LOG') SIZE 100M,
GROUP 2 ('C:/ORACLE/ORADATA/TESTE/REDO02.LOG') SIZE 100M,
GROUP 3 ('C:/ORACLE/ORADATA/TESTE/REDO03.LOG') SIZE 100M
Mon Dec 04 20:48:11 2006
Database mounted in Exclusive Mode.
Mon Dec 04 20:48:18 2006
Successful mount of redo thread 1, with mount id 4201073483
Assigning activation ID 4201073483 (0xfa674b4b)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\ORACLE\ORADATA\TESTE\REDO01.LOG
Successful open of redo thread 1
Mon Dec 04 20:48:18 2006
SMON: enabling cache recovery
Mon Dec 04 20:48:18 2006
create tablespace SYSTEM datafile
'C:/ORACLE/ORADATA/TESTE/SYSTEM01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Mon Dec 04 20:48:21 2006
Completed: create tablespace SYSTEM datafile
'C:/ORACLE/ORAD
Mon Dec 04 20:48:21 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon Dec 04 20:48:28 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE
'C:/ORACLE/ORADATA/TESTE/UNDOTBS01.DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT
5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:/ORAC
Mon Dec 04 20:48:32 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
'C:/ORACLE/ORADATA/TESTE/TEMP01.DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:/ORA
Mon Dec 04 20:48:32 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Mon Dec 04 20:48:33 2006
SMON: enabling tx recovery
Mon Dec 04 20:48:35 2006
Errors in file c:\oracle\admin\teste\udump\rhc_ora_2444.trc:
ORA-01501: CREATE DATABASE falhou
ORA-01991: arquivo 'C:\oracle\ora92\DATABASE\PWDrhc.ORA' de senha invalido
Mon Dec 04 20:48:35 2006
Error 1991 happened during db open, shutting down database
USER: terminating instance due to error 1991
Mon Dec 04 20:48:35 2006
Errors in file c:\oracle\admin\teste\bdump\rhc_pmon_4000.trc:
ORA-01991: invalid password file ''
Instance terminated by USER, pid = 2444
ORA-1092 signalled during: CREATE DATABASE TESTE
USER SYS IDENTIFIED BY *USER...
- Original Message -
From: Rodrigo Almeida
To: oracle_br@yahoogrupos.com.br
Sent: Monday, December 04, 2006 8:06 PM
Subject: Re: [oracle_br] Erro no Create Database - Ainda continua :(
Vá até o alert_RHC.log no dump background (bdump) e veja o motivo que a
instância foi finalizada.
Mostre a menssagem para nós, para podermos ajudar.
Abraços,
Rodrigo Almeida
On 12/4/06, Alex Ferreira [EMAIL PROTECTED] wrote:
Pessoal,
Ainda continua dando erro, porém diferente. Estou tentando criar um BD
para estudos e faço esse
