OraFAQ Forum: Server Administration » sys user not login and giving error ORA-27101

Home » RDBMS Server » Server Administration » sys user not login and giving error ORA-27101 (Oracle Database 8i Enterprise Edition Release 8.1.1.0.1)

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

sys user not login and giving error ORA-27101 [message #521947]

Mon, 05 September 2011 03:07

msol25
Messages: 396
Registered: June 2011

Senior Member

hi,

How we can resolve :


Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521948 is a reply to message #521947]

Mon, 05 September 2011 03:14

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Version 8.1.1.0.1 has never existed.
Please post a CORRECT version number and your OS.

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521950 is a reply to message #521948]

Mon, 05 September 2011 03:18

msol25
Messages: 396
Registered: June 2011

Senior Member

version number : Release 8.1.7.0.0 - Production

O.S : sun solaris

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521951 is a reply to message #521950]

Mon, 05 September 2011 03:24

msol25
Messages: 396
Registered: June 2011

Senior Member

o.s version : SunOS RHEA 5.6 Generic_105181-39 sun4u sparc sun4u

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521952 is a reply to message #521951]

Mon, 05 September 2011 03:29

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post "env | sort" and copy and paste you SQL*Plus session starting from the OS prompt.
Are you on the database server or remote?

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521953 is a reply to message #521952]

Mon, 05 September 2011 03:31

msol25
Messages: 396
Registered: June 2011

Senior Member

Hi Michel,


/home/pirm>env | sort
COLUMNS=79
DEV_LIB=/home/pirm/source/lib
DEV_LOCAL=/home/pirm/phase1
DEV_MAIN=/home/pirm/phase1
DEV_SYSTEM=PIRM
HOME=/home/pirm
LD_LIBRARY_PATH=/oracle/app/product/9ias/lib:/usr/lib/
LINES=24
LOGNAME=pirm
MAIL=/var/mail//pirm
ORACLE_HOME=/oracle/app/product/9ias
ORACLE_SID=pirm
PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/opt/SUNWspro/bin:
/usr/local/bin:/bin:/usr/local/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:
/home/pirm/SCCS:/home/pirm/SCCS:/oracle/app/product/9ias/bin/.
PS1=$PWD>
PWD=/home/pirm
SHELL=/bin/sh
SSH_CLIENT=172.21.53.224 4040 22
SSH_CONNECTION=172.21.53.224 4040 172.24.43.10 22
SSH_TTY=/dev/pts/3
TERM=vt100
TZ=Asia/IST
USER=pirm
_=/usr/bin/env

Working from remote machine using putty

[Updated on: Mon, 05 September 2011 04:04] by Moderator

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521954 is a reply to message #521953]

Mon, 05 September 2011 03:32

msol25
Messages: 396
Registered: June 2011

Senior Member

I have connected with putty to remote machine which is having Database.

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521955 is a reply to message #521954]

Mon, 05 September 2011 03:43

msol25
Messages: 396
Registered: June 2011

Senior Member

Michel please reply me....

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521956 is a reply to message #521955]

Mon, 05 September 2011 04:03

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Wait a little bit. I also have to do my job.
Also you didn't post the sqlplus session as I asked.

If you are remote then you cannot connect with this string, you have to use "sys@<something> as sysdba".

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521957 is a reply to message #521956]

Mon, 05 September 2011 04:06

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Working from remote machine using putty

I don't understand, is your putty session remote to the database server or local to the database server?
Is the "env | sort" you posted from your putty session?

Once again COPY AND PASTE the putty session.

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521965 is a reply to message #521955]

Mon, 05 September 2011 04:39

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

msol25 wrote on Mon, 05 September 2011 10:43

Michel please reply me....

msol25 please reply...

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521967 is a reply to message #521957]

Mon, 05 September 2011 04:47

msol25
Messages: 396
Registered: June 2011

Senior Member

Many thanks Michel,

Problem has been resolved now...

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521968 is a reply to message #521967]

Mon, 05 September 2011 04:50

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How? The problem was?

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521992 is a reply to message #521968]

Mon, 05 September 2011 06:03

msol25
Messages: 396
Registered: June 2011

Senior Member

Thanks Michel for your query,

Please find complete scenario :

I have deleted .log from bdump and .trc files from udump and deleted some unnecessary files.

Step 1: I am accessing remote server using putty and connecting with unix superuser.

Step 2: Then executing sqlplus /nolog like :


            sqlplus /nolog

            SQL*Plus: Release 8.1.7.0.0 - Production on Mon Sep 5 14:52:01 2011

            (c) Copyright 2000 Oracle Corporation.  All rights reserved.

            SQL>

Step 3: then executed :


          SQL> conn sys as sysdba
               Enter password:
               Connected.

Step 5: then startup

Actually this was space related problem,so we have deleted some unnecessary files,then its working fine.

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521995 is a reply to message #521992]

Mon, 05 September 2011 06:07

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Re: sys user not login and giving error ORA-27101 [message #521999 is a reply to message #521995]

Mon, 05 September 2011 06:26

msol25
Messages: 396
Registered: June 2011

Senior Member

Welcome Michel

Regards
Saurabh Mittal
(Mahindra British Telecom)

Report message to a moderator

Previous Topic:	Reclaiming Actual Physical Disk Space
Next Topic:	need to split a partition into multiple partitions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:27:07 CDT 2024