This is the error that my client receives when try to connect to the database. It used to work OK before. I tried to reboot the machine because tha database was supposed to start automatically but I got the same message.
The documentation for this type of error suggests that I should wait until the database is completely started, but I gor this message for about 3 days.
Here is a thread from oracle metalink that talks about a similar issue:
This is only an opinion.
Posting from oracle metalink:
We used on platform Wintel, NT 4 Server and Workstations,
Oracle Server 7.3.4.
We used database instance.
We recreate this database with some changes.
And here start our trouble.
When Oracle service and instance is startup through Control
panel, we are not to able connect to database
(for example: SqlPlus -> ORA-01034 ORACLE not available,
ORA-09243 smsget attaching to SGA, OSD-04101 invalid SGA:
SGA not initialized; this message we took after one hour
When I start SVRMGR in this point, I get this result:
Connect ... -> Connects to an idle instance.
Shutdown ... -> ORA-01012 not loged on
Startup ... -> LCC-00161 Oracle error parameter [NULL]
ORA-01031 Insufficient privileges
When Oracle instance is startup through Instance manager,
all is right, executing same command with same parameters
Here is InitSEPS.ORA
db_name = SEPS
db_files = 100
rollback_segments = (RBS1,RBS2,RBS3,RBS4,RBS5,RBS6)
compatible = 126.96.36.199.0
db_file_multiblock_read_count = 32
db_block_buffers = 20000
shared_pool_size = 50000000
log_checkpoint_interval = 10000
processes = 100
dml_locks = 400
log_buffer = 32768
sequence_cache_entries = 30
sequence_cache_hash_buckets = 23
SORT_AREA_SIZE = 120000
distributed_transactions = 0
OPEN_CURSORS = 100
unlimited_rollback_segments = true
# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed
max_dump_file_size = 10240 # limit trace file size to
5 Meg each
# log_archive_start = true # if you want automatic
# define directories to store trace and alert files
# core_dump_dest =
db_block_size = 4096
nls_language = SLOVAK
nls_territory = SLOVAKIA
nls_sort = XCZECH
#remote_login_passwordfile = exclusive
text_enable = true
I dont find alert, message, error or nothing else in
What we can do ?????????
Change the SID in the Registry:
1. Run REGEDT32 and go to HKEY_Local_Machine on Local_Machine.
2. Go to Software.
3. Go to Oracle.
4. Look for ORACLE_SID and verify it is set to the SID to which the you are trying to connect. If not, double click on ORACLE_SID and modify the string.
With the wrong value in the registry, and not specifying the
right one during connect, the software was trying to start up an SGA for a database which does not exist. You may want to try recreating the password file. Connect as
internal and issue a startup with complete path to the PFILE.
from the command prompt:
svrmgr23> connect internal/password
svrmgr23> startup pfile=
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width