Home » Infrastructure » Windows » ORA-01034,ORA-27101 (10.2.0.1.0 , windows 7)
ORA-01034,ORA-27101 [message #619889] Fri, 25 July 2014 14:31 Go to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
SQL> connect system/Manager;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Am getting above error after installing the Oracle Release 10.2.0.1.0.

Please suggest me on this issue
Re: ORA-01034,ORA-27101 [message #619890 is a reply to message #619889] Fri, 25 July 2014 14:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ask you DBA to start the database.

Re: ORA-01034,ORA-27101 [message #619892 is a reply to message #619890] Fri, 25 July 2014 14:59 Go to previous messageGo to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
I installed 10g Express Edition in my domain PC.
Re: ORA-01034,ORA-27101 [message #619894 is a reply to message #619892] Fri, 25 July 2014 15:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So execute
connect / as sysdba
startup

Re: ORA-01034,ORA-27101 [message #619895 is a reply to message #619894] Fri, 25 July 2014 15:02 Go to previous messageGo to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
ERROR:
ORA-01031: insufficient privileges
Re: ORA-01034,ORA-27101 [message #619896 is a reply to message #619895] Fri, 25 July 2014 15:16 Go to previous messageGo to next message
EdStevens
Messages: 1350
Registered: September 2013
Senior Member
thelearner wrote on Fri, 25 July 2014 15:02
ERROR:
ORA-01031: insufficient privileges


Your current OS account is not a member of the local group ORA_DBA.
Re: ORA-01034,ORA-27101 [message #619898 is a reply to message #619896] Fri, 25 July 2014 15:27 Go to previous messageGo to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
I checked in my system
My Computer -> Manage -> Local User and Groups -> ORA_DBA ->
My account is there.
Re: ORA-01034,ORA-27101 [message #619919 is a reply to message #619898] Sat, 26 July 2014 00:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post sqlnet.ora content.

Re: ORA-01034,ORA-27101 [message #620063 is a reply to message #619919] Mon, 28 July 2014 09:17 Go to previous messageGo to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.AUTHENTICATION_SERVICES = (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Re: ORA-01034,ORA-27101 [message #620068 is a reply to message #620063] Mon, 28 July 2014 10:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Uncomment first line, comment second one.

Re: ORA-01034,ORA-27101 [message #620074 is a reply to message #620068] Mon, 28 July 2014 10:53 Go to previous message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
Its working....
SQLNET.AUTHENTICATION_SERVICES = (NTS)
#SQLNET.AUTHENTICATION_SERVICES = (NONE)

Thank you.

[Updated on: Mon, 28 July 2014 10:53]

Report message to a moderator

Previous Topic: TNSLSNR.exe TCP Connection Latency
Next Topic: oracle forms and reports software required for Oracle 12c
Goto Forum:
  


Current Time: Tue Nov 30 05:13:04 CST 2021