Home » Infrastructure » Windows » Oracle 9i installation problem on Win XP
icon7.gif  Oracle 9i installation problem on Win XP [message #206786] Fri, 01 December 2006 08:02 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Hi

I installed Oracle 9i on XP with some files missing during the process of installation, nevertheless it is installed.
Now when I try to run SQL* Plus it generates following errors


Ora-01034 Oracle not available
Ora-27101 Shared memory realm does not exists

Can any body suggest me solutions.
As i am installing oracle first time but i know about the configurations .

any suggestion would be appreciate.
Thanks in advance
Re: Oracle 9i installation problem on Win XP [message #206792 is a reply to message #206786] Fri, 01 December 2006 08:45 Go to previous messageGo to next message
hrforafaq
Messages: 8
Registered: July 2005
Junior Member
Salam
First of all look at windows services to see if main oracle services ara running (like the listener, database service)
then :
Open Sql plus
Try to login as : connect sys/password@yourdatabase as sysdba
type : 'startup open' to open the database
select status from v$instance; -- to see the status of the database.
Bye
Re: Oracle 9i installation problem on Win XP [message #206870 is a reply to message #206792] Fri, 01 December 2006 19:25 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Thankyou Salam,

I got it , the problem was as you expected that i did not started the instance , now i started by connecting as sysdba.
But when i quit the session and tried to relogin as scott/tiger
it is giving me error: Oracle initialization and shutdown in progress. will it come after some time or is it a serious problem.
Thankyou
Re: Oracle 9i installation problem on Win XP [message #206915 is a reply to message #206870] Sat, 02 December 2006 04:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is how it is supposed to look like if everything is OK:
C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sub Pro 2 11:23:01 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.


SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              75498852 bytes
Database Buffers           88080384 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.


SQL> connect scott/tiger
Connected.
SQL>
icon6.gif  Re: Oracle 9i installation problem on Win XP [message #214018 is a reply to message #206786] Sat, 13 January 2007 11:46 Go to previous messageGo to next message
Satish3k
Messages: 1
Registered: January 2007
Location: India
Junior Member

Hi,

I am getting the same problem stating that Oracle Error: ORA-01034: Oracle Not Available.

The TNS Listener is not starting.

Satish
Re: Oracle 9i installation problem on Win XP [message #214023 is a reply to message #214018] Sat, 13 January 2007 12:50 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you tried what Littlefoot posted above? You could try this locally on the database server without having to start the listener. You don't mention it, but if you are on Windows, then ensure that the Oracle Window's service is started prior to connecting to the database.

For the listener not starting, do you see any errors in the listener.log file? Has the listener ever started?
Previous Topic: ODBC Trace Log File Location Problem
Next Topic: ORA-12500: TNS listener failed
Goto Forum:
  


Current Time: Thu Mar 28 19:22:41 CDT 2024