Oracle 9i execution in W2K [message #100821] |
Mon, 10 November 2003 01:59 |
Prahalad
Messages: 8 Registered: November 2003
|
Junior Member |
|
|
Hi
Can u plz solve my problem of oracle 9i startup.
I have loaded oralce9i on Win 2000 OS with ora9i as database name (Host String),
for the very first time i was able to connect to database with username 'system' and
host string 'ora9i', but everytime when i restart the system and try connecting database
as normal user(windows login) it gives an error saying
'ORA-03113 - end-of-file on communication channel'.
when i try connecting database as administrative user(window login) it gives an error saying
'ORA-01034 - ORACLE not found'
'ORA-27101 - shared memory realm does not exist
I would be thankful to all of you for giving me correct solution.
thanks
Prahalad
|
|
|
Re: Oracle 9i execution in W2K [message #100823 is a reply to message #100821] |
Mon, 10 November 2003 10:19 |
Fermín Martínez
Messages: 7 Registered: November 2003
|
Junior Member |
|
|
I was with the same problem.
I solucionated starting the Oracle Service in the Services of W2K.
Go to the start button, settings, control panel administrative tools and then Services. You need to find the OracleServiceOracle and look for the status. You need to change the status to Started.
|
|
|
Re: Oracle 9i execution in W2K [message #100824 is a reply to message #100823] |
Mon, 10 November 2003 23:06 |
Prahalad
Messages: 8 Registered: November 2003
|
Junior Member |
|
|
Those services are started but still i am not able to connect to database, Is there anything further that I should do to get connected to database. I await for early help.
Thanks
Prahalad
|
|
|
Re: Oracle 9i execution in W2K [message #100826 is a reply to message #100824] |
Tue, 11 November 2003 05:18 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
did u start the database?
the following will start the database.
sqlplus "sys/password_for_sys"
startup;
----------------------------------------------------------------------
if there are multiple databases, set your ORACLE_SID.
also start the listener.
lsnrctl start -- will start the default listener.
lsnrctl start LISTENER_NAME -- will start the specified listener.
|
|
|