oracle error 08001 re: user_sequences

Posted on 2006-05-23
Last Modified: 2008-01-09
We have a client attempting to connect to 10g using crystal reports. They are getting ora-08001 as an error reported to them.  accorning to :
we have to increase a parameter called USER_SEQUENCES but that does'nt sound right!

Can anyone tell me what the real problem might be?
Question by:mervifwdc
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    select * from v$parameter where name = 'user_sequences'

    change that value in the init.ora file resp the spfile
    LVL 6

    Accepted Solution

    If it's nothing to do with USER_SEQUENCES, and I think you may be right here, here is another suggestion.  I have had a quick surf regarding this and it could be that there are multiple oracle products installed on the desktop.   Each oracle product has its own tnsnames.ora and it may that the wrong tnsnames.ora is being used.  I will try and get some more info on this if you need.

    LVL 6

    Assisted Solution

    Check the directions located in the Crystal Reports Help files to ensure correct configuration of the Crystal Reports system Data Source Names (DSN)

    Author Comment

    Thanks for the hints. I'll be on-site in a couple of hours and this gives me somewhere to start from. I have had them confirm that they have multiple connections from their machines, but they claim to only have 1 oracle home. Until I see it I cannot be too sure.

    They did state that the tnsping was failling, but it was giving a 12545 error, which says it cannot see the service.

    I think I'm getting duff info from my client, so I'll update this when I get some facts.
    Thanks guys!

    Author Comment

    It turns out that on the client with Crystal reports, the oracle client was configured incorrectly. It had a service ID, which was fine, but only had 1 IP address listed. The server is 10g Grid, and therefore it needed 2 IP addresses and not 1. Every second "test" of the connection failed, and every second one succeeded. Once I added the 2nd IP address, it worked perfectly.

    So, it was TNS related and that's what got me to start there. Also the comment about crystal reports error messages (which sent us WAY down the wrong path) was useful.

    Thanks folks!

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now