URGENT

[cravi]

Hi Guys


I have the Test & Production databases on WINDOWS-NT (ORACLE734).
Whenever i am trying to connect to the Test
Database an Error Message is Popping up Like:

ORA-01034 ORACLE NOT AVAILABLE
ORA-09243 smsget error attaching to SGA
OSD-04101 Invalid SGA:SGA not initialized.

I TRIED LIKE:


1) I checked the services ORACLESERVICE ORCL & ORACLESTART ORCL.
They are running.Even i stopped and started the services.But
the same Error message is popping up.

2) I guess the database is not running so i tried

d:set ORACLE_SID=orcl

d:/orant/bin/svrmgr23

svrmgr>startup pfile= i:/orant/database/initorcl.ora

It is giving the error message :
LCC-00161 ORACLE ERROR<possible syntax error> parameter[null]
ORA-01031 Insufficient privileges.

3) set ORACLE_SID=orcl
svrmgr>connect internal/oracle@orcl3g;
ERROR:INSUFFICIENT PRIVILEGES
WHEN I TRIED TO CONNECT FROM SQLPLUS WITH INTERNAL
THE ERROR MESSAGE IS 0RA-01034,09243&OSD-04101
AS MENTIONED ABOVE.
BUT i could able to connect with internal in the past.

4)Nothing was written to the orclALRT.LOG since Dec 9th.The last line
is: completed:alter database "oracle" open.

Now i didn't left with any option to get it work.Can any one of you guide me
to get my TEST database up.I have some tasks to do here immediately.

Thanks
Ravi

[st2000]

reboot the server
check the environment variables correctly
startup pfile=....... (path correctly)

Give it a shot..

[gsprince]

Try reducing the size of db_block_buffers and/or shared_pool_size init parameters and restart it. It could be due to insufficient memory (not very sure).

[cravi]

is there any other possible way.Because i can't reboot the server it's a 24*7 database accessing by 5 different countries.

Thanks
Ravi

[goodhealth]

Double check your oracle user, group etc. Verify current DBA user by reading/execute some Oracle owned objects(config files, ora.init etc.). Also check owner&permissions on your oracle datafiles. Sound like someone or something changed your environment. Since I work on Unix mostly, I hope this can apply to NT as well.

[cravi]

the shared pool size is 6.5 mb

and db_block_buffers= 200

Have i to reduce these figures if there is any memory problem. if so by what values.

The physical memory on server is 785 mb

[mbaliga]

Hi,

If you can not reboot the server, stop and start the oracle service and see if the database starts up.

Baliga

[gsprince]

It could be possible there is corruptions on the OracleService.

You may be able to drop and recreate the service without affecting the data.

Stop the service if its already running

remove the service
oradimXX -delete -sid <SID>

Delete the <path\pwd<SID>.ora> file

Add the service back
oradimXX -new -sid <SID> -intpwd <password> -startmode auto -pfile <path\init<SID>.ora>


Note: XX stands for the version (ex 73). Also make sure the syntax is correct and run the command from DOS promt.

[cravi]

hi

1)stop the service

2)oradim73 -delete -sid -orcl

3)why should i delete the initorcl.ora i need that when i use the oradim command again :

oradim73 -new -sid orcl -intpwd internal -startmode auto -pfile i:\orant\database\initorcl.ora

can u clarify it


thanks
ravi

[gsprince]

Sorry, The posting messed up.

Do not delete the initSID.ora, instead delete the pwdSID.ora file (the password file, probably it is a hidden file)

Note: I used the "less than", "greater than" symbo in the prev posting which got messed up.