OraFAQ Forum: Windows » Oracle 9i installation problem on Win XP

Home » Infrastructure » Windows » Oracle 9i installation problem on Win XP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i installation problem on Win XP [message #206786]

Fri, 01 December 2006 08:02

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

Report message to a moderator

Re: Oracle 9i installation problem on Win XP [message #206792 is a reply to message #206786]

Fri, 01 December 2006 08:45

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

Report message to a moderator

Re: Oracle 9i installation problem on Win XP [message #206870 is a reply to message #206792]

Fri, 01 December 2006 19:25

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

Report message to a moderator

Re: Oracle 9i installation problem on Win XP [message #206915 is a reply to message #206870]

Sat, 02 December 2006 04:26

Littlefoot
Messages: 21823
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>

Report message to a moderator

Re: Oracle 9i installation problem on Win XP [message #214018 is a reply to message #206786]

Sat, 13 January 2007 11:46

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

Report message to a moderator

Re: Oracle 9i installation problem on Win XP [message #214023 is a reply to message #214018]

Sat, 13 January 2007 12:50

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?

Report message to a moderator

Previous Topic:	ODBC Trace Log File Location Problem
Next Topic:	ORA-12500: TNS listener failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 22:49:54 CST 2025