OraFAQ Forum: Client Tools » ORA-01034:Oracle not available

Home » Other » Client Tools » ORA-01034:Oracle not available (SQLPLUS for 10g)

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

ORA-01034:Oracle not available [message #590011]

Sat, 13 July 2013 11:44

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Hi All,
I am trying to login to 10g sqlplus ,
gives below error:

ORA-01034:Oracle not available
ORA-27101-shared memory does not exist

Need assistance and resolution for this .Please let me know the steps to resolve .

Thanks,
Bhanu

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590013 is a reply to message #590011]

Sat, 13 July 2013 11:49

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Before connecting to a database, you must start it up. Did you do that?

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590014 is a reply to message #590013]

Sat, 13 July 2013 11:55

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

can you help me do that aswell ? and will that resolve? Iam using windows vista

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590016 is a reply to message #590014]

Sat, 13 July 2013 12:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is the database installed on your computer? If so, go to Control Panel, Administrative Tools, choose Services. Start Listener and OracleService.

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590017 is a reply to message #590016]

Sat, 13 July 2013 12:02

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Ok let me try and get back to you , much appreciate for help.

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590018 is a reply to message #590017]

Sat, 13 July 2013 12:09

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

tried that , no joy !! it doesn't take my usn password aswell , anyway to login with system usn n password , and can change my user(password)?

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590019 is a reply to message #590018]

Sat, 13 July 2013 12:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure what is your current status. Is Oracle available now, or not?

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590020 is a reply to message #590019]

Sat, 13 July 2013 12:18

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Nopes its not working .do you need me to provide some more details , please let me know .

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590021 is a reply to message #590020]

Sat, 13 July 2013 12:20

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Pasting the logs :

07/13/13 14:47:53 Waiting a further 5 secs...
07/13/13 14:47:57 Received exitCode 3 from emctl istatus
07/13/13 14:47:57 dbconsole started

-------------- [OracleDBConsoleorcl] ------------
EMDROOT=F:\oracle\product\10.2.0\db_1
ORACLE_HOME=F:\oracle\product\10.2.0\db_1
EMDSTATE=F:\oracle\product\10.2.0\db_1\Bhavana-PC_orcl
CONSOLE_CFG=dbconsole
TRACE_LEVEL=16
TIMEOUT=15
07/13/13 20:58:13 Start pending...
07/13/13 20:58:13 Verifying dbconsole is not started already. Command line "F:\oracle\product\10.2.0\db_1\bin\emctl.bat" istatus dbconsole
07/13/13 20:58:45 dbconsole launch commandline is "F:\oracle\product\10.2.0\db_1\bin\emctl.bat" istart dbconsole
07/13/13 20:58:45 Tracking process launch...
07/13/13 20:59:19 Received exitCode 3 from emctl istatus
07/13/13 20:59:19 dbconsole started

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590024 is a reply to message #590021]

Sat, 13 July 2013 12:26

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How did you start these services? Right-click + Start should do it, and both should be "Started", then. Here's how it looks for me:

/forum/fa/10971/0/

Attachment: oracle_started.jpg
(Size: 38.87KB, Downloaded 3831 times)

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590032 is a reply to message #590024]

Sat, 13 July 2013 12:54

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Please find attached

Attachment: services oracle started.jpg
(Size: 75.83KB, Downloaded 2041 times)

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590036 is a reply to message #590032]

Sat, 13 July 2013 13:03

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Can you tell me if services are fine ? and what next can be done

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590044 is a reply to message #590036]

Sat, 13 July 2013 13:10

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Services are OK, but are you connecting to this database (ORCL)?

Regards
Michel

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590046 is a reply to message #590044]

Sat, 13 July 2013 13:13

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

I am not sure this is a local system-laptop with vista os , once I open sqlplus and typing my usn pass there is an error .

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590049 is a reply to message #590046]

Sat, 13 July 2013 13:21

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your usn?

Regards
Michel

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590051 is a reply to message #590049]

Sat, 13 July 2013 13:25

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

iam using generic username scott , even hr,sysdba none work .

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590052 is a reply to message #590051]

Sat, 13 July 2013 13:46

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your EXACT connection string?
Use SQL*Plus and copy and paste your session, the WHOLE session.

Regards
Michel

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590061 is a reply to message #590052]

Sat, 13 July 2013 22:41

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

can you send me link to uninstall /clean 10g oracle on vista system.
please also send me link to install lates 11g version on vista . Its bit urgent .

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590063 is a reply to message #590061]

Sat, 13 July 2013 23:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://forums.oracle.com/thread/2559853

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590067 is a reply to message #590061]

Sun, 14 July 2013 01:39

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

bhanu6us wrote on Sun, 14 July 2013 05:41

can you send me link to uninstall /clean 10g oracle on vista system.
please also send me link to install lates 11g version on vista . Its bit urgent .

As you chose to not answer to my questions, I choose to not answer to yours.

Regards
Michel

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590074 is a reply to message #590067]

Sun, 14 July 2013 04:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Michel, unless I'm wrong, is trying to find out whether you are connecting to the database you have installed on your computer, i.e. whose name is ORCL. Therefore, your connect string should look like "scott/tiger@orcl" or similar. So, could you provide that (possibly the whole session, starting with operating system's command prompt).

As of uninstalling Oracle: Oracle Universal Installer offers that, but you'll probably need to do some manual labor. Have a look a t this John's message (posted recently; disregard the fact that topic regards mainly Apex issues).

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590119 is a reply to message #590074]

Mon, 15 July 2013 01:04

bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore

Junior Member

Iam sorry I missed out in answering regarding the session details , Yesterday I deleted Oracle on my laptop and installed 11g R2 from oracle site :

I tried to download 11g r2 set up file from oracle site,
but few files were missing while installing and at the final installation it had given lot of errors like missiing files on
D rive etc , n not I get error while using usn password

ora-12560 tns protpcol adapter error , Please advise what can be done now to fix this please !!!!!

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590120 is a reply to message #590119]

Mon, 15 July 2013 01:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Missing files? Download the setup again, I'd say (did you download the right file, for your operating system?).

Report message to a moderator

Re: ORA-01034:Oracle not available [message #590130 is a reply to message #590120]

Mon, 15 July 2013 01:41

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Oracle 11g has 2 installation files ..you need to unzip them into a single drive or directory from where you can start your installation with administration privileges....

You need to download two files and merge them into a single directory.....

Oracle 11g zip files have these known issues...you can download them separately...
Missing files search here

Or another option will be If you are trying to practice on a small DB then you can go with express edition which is a small and very useful for students.....

This Installation can be installed without any issues ....

You can download it from here Oracle Database Express Edition 11g Release 2

Thanks
Sriram Sanka

Report message to a moderator

Previous Topic:	SPA comparison report
Next Topic:	Spool 32k+ Clob to a flat file (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:19:58 CST 2025