Home » SQL & PL/SQL » Client Tools » ORA-01034:Oracle not available (SQLPLUS for 10g)
ORA-01034:Oracle not available [message #590011] Sat, 13 July 2013 11:44 Go to next message
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
Re: ORA-01034:Oracle not available [message #590013 is a reply to message #590011] Sat, 13 July 2013 11:49 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Before connecting to a database, you must start it up. Did you do that?
Re: ORA-01034:Oracle not available [message #590014 is a reply to message #590013] Sat, 13 July 2013 11:55 Go to previous messageGo to next message
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
Re: ORA-01034:Oracle not available [message #590016 is a reply to message #590014] Sat, 13 July 2013 12:02 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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.
Re: ORA-01034:Oracle not available [message #590017 is a reply to message #590016] Sat, 13 July 2013 12:02 Go to previous messageGo to next message
bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore
Junior Member

Ok let me try and get back to you , much appreciate for help.
Re: ORA-01034:Oracle not available [message #590018 is a reply to message #590017] Sat, 13 July 2013 12:09 Go to previous messageGo to next message
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)?
Re: ORA-01034:Oracle not available [message #590019 is a reply to message #590018] Sat, 13 July 2013 12:16 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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?
Re: ORA-01034:Oracle not available [message #590020 is a reply to message #590019] Sat, 13 July 2013 12:18 Go to previous messageGo to next message
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 .
Re: ORA-01034:Oracle not available [message #590021 is a reply to message #590020] Sat, 13 July 2013 12:20 Go to previous messageGo to next message
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
Re: ORA-01034:Oracle not available [message #590024 is a reply to message #590021] Sat, 13 July 2013 12:26 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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:

./fa/10971/0/

Re: ORA-01034:Oracle not available [message #590032 is a reply to message #590024] Sat, 13 July 2013 12:54 Go to previous messageGo to next message
bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore
Junior Member

Please find attached
Re: ORA-01034:Oracle not available [message #590036 is a reply to message #590032] Sat, 13 July 2013 13:03 Go to previous messageGo to next message
bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore
Junior Member

Can you tell me if services are fine ? and what next can be done
Re: ORA-01034:Oracle not available [message #590044 is a reply to message #590036] Sat, 13 July 2013 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Services are OK, but are you connecting to this database (ORCL)?

Regards
Michel
Re: ORA-01034:Oracle not available [message #590046 is a reply to message #590044] Sat, 13 July 2013 13:13 Go to previous messageGo to next message
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 .
Re: ORA-01034:Oracle not available [message #590049 is a reply to message #590046] Sat, 13 July 2013 13:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your usn?

Regards
Michel
Re: ORA-01034:Oracle not available [message #590051 is a reply to message #590049] Sat, 13 July 2013 13:25 Go to previous messageGo to next message
bhanu6us
Messages: 15
Registered: November 2007
Location: bangalore
Junior Member

iam using generic username scott , even hr,sysdba none work .
Re: ORA-01034:Oracle not available [message #590052 is a reply to message #590051] Sat, 13 July 2013 13:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your EXACT connection string?
Use SQL*Plus and copy and paste your session, the WHOLE session.

Regards
Michel
Re: ORA-01034:Oracle not available [message #590061 is a reply to message #590052] Sat, 13 July 2013 22:41 Go to previous messageGo to next message
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 .
Re: ORA-01034:Oracle not available [message #590063 is a reply to message #590061] Sat, 13 July 2013 23:20 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
https://forums.oracle.com/thread/2559853
Re: ORA-01034:Oracle not available [message #590067 is a reply to message #590061] Sun, 14 July 2013 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01034:Oracle not available [message #590074 is a reply to message #590067] Sun, 14 July 2013 04:11 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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).
Re: ORA-01034:Oracle not available [message #590119 is a reply to message #590074] Mon, 15 July 2013 01:04 Go to previous messageGo to next message
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 !!!!!


Re: ORA-01034:Oracle not available [message #590120 is a reply to message #590119] Mon, 15 July 2013 01:05 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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?).
Re: ORA-01034:Oracle not available [message #590130 is a reply to message #590120] Mon, 15 July 2013 01:41 Go to previous message
ramoradba
Messages: 2452
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
Previous Topic: SPA comparison report
Next Topic: Spool 32k+ Clob to a flat file (2 Merged)
Goto Forum:
  


Current Time: Tue Sep 02 00:29:51 CDT 2014

Total time taken to generate the page: 0.22171 seconds