Home » Infrastructure » Windows » Oracle 9i execution in W2K
Oracle 9i execution in W2K [message #100821] Mon, 10 November 2003 01:59 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.

Previous Topic: Oralce 8.0.6 on Win2K
Next Topic: Extract oracel data to an excel thur ODBC
Goto Forum:
  


Current Time: Wed Apr 24 12:38:29 CDT 2024