› Fóruns › Banco de dados Oracle › Oracle 10 g. Após a instalação estou sem acesso ao banco. › Oracle 10 g. Após a instalação estou sem acesso ao banco.
Segue abaixo a configuração que obtive no final da instalação:
General Purpose
Use this database template to create a pre-configured database optimized for general purpose usage.
Common Options
Option Selected
Oracle JVM true
Oracle Data Mining true
Oracle Text true
Oracle XML DB true
Oracle Intermedia true
Oracle OLAP true
Oracle Spatial true
Oracle Ultra Search false
Oracle Label Security false
Sample Schemas false
Enterprise Manager Repository true
Oracle Database Extensions for .NET false
Initialization Parameters
Name Value
audit_file_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump
background_dump_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/bdump
compatible 10.2.0.1.0
control_files (“{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl”, “{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl”, “{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl”)
core_dump_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/cdump
db_block_size 8KB
db_domain
db_file_multiblock_read_count 16
db_name MyDataBa
db_recovery_file_dest {ORACLE_BASE}/flash_recovery_area
db_recovery_file_dest_size 2048MB
db_unique_name MyDataBase
dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
job_queue_processes 10
open_cursors 300
pga_aggregate_target 395MB
processes 150
remote_login_passwordfile EXCLUSIVE
sga_target 1187MB
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/udump
Character Sets
Name Value
Database Character Set WE8MSWIN1252
National Character Set AL16UTF16
Data Files
Name Tablespace Size(M)
{ORACLE_BASE}oradata{DB_UNIQUE_NAME}SYSTEM01.DBF SYSTEM 470
{ORACLE_BASE}oradata{DB_UNIQUE_NAME}UNDOTBS01.DBF UNDOTBS1 25
{ORACLE_BASE}oradata{DB_UNIQUE_NAME}SYSAUX01.DBF SYSAUX 230
{ORACLE_BASE}oradata{DB_UNIQUE_NAME}USERS01.DBF USERS 5
{ORACLE_BASE}oradata{DB_UNIQUE_NAME}TEMP01.DBF TEMP 20
Control Files
Name
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl
Redo Log Groups
Group Size(K)
1 51200
2 51200
3 51200