Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 28th, 2004, 07:14 PM
Registered User
 
Join Date: Sep 2004
Location: Calumet City, Illinois, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ora-01034 error

After entering my username and password, while accessing Sql/plus, I get the error code "Ora-01034" and message "Oracle Not Available"

This happens about 95% of the time I try to signon. I am running Oracle 81 and Developer 9I.

  #2 (permalink)  
Old September 28th, 2004, 09:22 PM
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here is one discussion on resolving the ORA-01034 error on 8i. Most likely, either your ORACLE_SID or ORACLE_HOME environment variable is set improperly. What are these environment variables set to on your system?



Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
  #3 (permalink)  
Old September 30th, 2004, 03:30 PM
Registered User
 
Join Date: Sep 2003
Location: dammam, ad, Saudi Arabia.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This error means that SGA parameters in your database need more space than it allocated.
Thank you and with best regards

Waheed rashwan
  #4 (permalink)  
Old September 30th, 2004, 05:22 PM
Registered User
 
Join Date: Sep 2004
Location: Calumet City, Illinois, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Justin thanks for responding to my problem. I am somewhat new to Oracle and could not locate the Oracle_Sid or Oracle_Home to check what they are set at. If you could point in the right direction, it would be appreciated
Quote:
quote:Originally posted by Justin Cave
 Here is one discussion on resolving the ORA-01034 error on 8i. Most likely, either your ORACLE_SID or ORACLE_HOME environment variable is set improperly. What are these environment variables set to on your system?



Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
  #5 (permalink)  
Old September 30th, 2004, 05:26 PM
Registered User
 
Join Date: Sep 2004
Location: Calumet City, Illinois, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

[Thank you Waheed. I am new to Oracle. Could you give me some directions on where to locate the SGA parameters. Thank you again]Originally posted by wahras
 This error means that SGA parameters in your database need more space than it allocated.
Thank you and with best regards

Waheed rashwan
[/quote]

  #6 (permalink)  
Old September 30th, 2004, 08:40 PM
Registered User
 
Join Date: Sep 2004
Location: Calumet City, Illinois, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for assisting me in solving this problem. I increased the SGA and the problem is now gone.

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ORA-0134 db009 Oracle 0 February 23rd, 2007 06:04 AM
[Oracle][ODBC][Ora][ORA-01013 Corey Access 1 December 15th, 2006 10:29 AM
Error ORA-27101: shared memory realm does not exis rajan_sood Oracle 0 October 17th, 2005 12:53 PM
Need help to Resolve Error ORA-00933 sandeepshivathaya Oracle 0 August 19th, 2004 07:15 AM
ORA-01006 ahrv Java Databases 1 September 20th, 2003 05:45 PM



All times are GMT -4. The time now is 12:23 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.