Hi,
I'm getting the following errors when I try to connect :
ORA-01034 : ORACLE not available
Ora-27101 : shared memory realm does not exist
When I start my pc oracle does not start up by itself so I go to run -> cmd and type in :
set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup
The database then starts up.
Problem is I still get the error if I try to connect through Toad or sql*plus.
My tnsnames is correct. I checked it a few times.
The funny thing is that if I plug my network cable out, and restart my pc, my oracle starts up by itself and I don't have any problems.
So that let me think that maybe it is some sort of network problem or security setting. I know an outside contractor came to our company and changed some of the security settings on our network. Closed some of the ports etc. Don't know exactly what. My user belongs to the ORA_DBA group on my pc. Can't find ORA_DBA on the domain. So if I have to add it to the domain - how ?
My listener is started.
Do you think this can be the problem? Or am I totally looking at the wrong place? I don't have a lot of network/security knowledge. Does anybody have some suggestions what I must look for. I can contact the guy who changed our security setting, but at this stage I don't even know what to ask him.
Thanks
Karen
I'm getting the following errors when I try to connect :
ORA-01034 : ORACLE not available
Ora-27101 : shared memory realm does not exist
When I start my pc oracle does not start up by itself so I go to run -> cmd and type in :
set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup
The database then starts up.
Problem is I still get the error if I try to connect through Toad or sql*plus.
My tnsnames is correct. I checked it a few times.
The funny thing is that if I plug my network cable out, and restart my pc, my oracle starts up by itself and I don't have any problems.
So that let me think that maybe it is some sort of network problem or security setting. I know an outside contractor came to our company and changed some of the security settings on our network. Closed some of the ports etc. Don't know exactly what. My user belongs to the ORA_DBA group on my pc. Can't find ORA_DBA on the domain. So if I have to add it to the domain - how ?
My listener is started.
Do you think this can be the problem? Or am I totally looking at the wrong place? I don't have a lot of network/security knowledge. Does anybody have some suggestions what I must look for. I can contact the guy who changed our security setting, but at this stage I don't even know what to ask him.
Thanks
Karen
