Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved connection to oracle

  1. How-to
0
Votes
Undo
  1. Jan Krahulik
    Jan Krahulik
  2. PowerBuilder
  3. Wednesday, 14 April 2021 13:31 PM UTC 
I have a problem connecting to the Oracle database 12. Version PB 2019.R3.
Error: ORA-01035 ORACLE not available to users with RESTRICTED SESSION privilege.

You can help me?

Gabriel Kasic
Theme on datawindow with expressions
Need a no/low cost database recommendation
Responses (2)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 14 April 2021 14:37 PM UTC
  2. PowerBuilder
  3. # 1

What Benjamin said.

Your DBA should always let people know when the database will be in restricted mode. Perhaps establishing some kind of protocol will prevent this from occuring in the future.

Comment
There are no comments made yet.
Benjamin Gaesslein
Benjamin Gaesslein Accepted Answer Pending Moderation
  1. Wednesday, 14 April 2021 13:58 PM UTC
  2. PowerBuilder
  3. # 2

The wording of ORA-01035 should be "ORACLE only available to users with RESTRICTED SESSION privilege" and this happens when the database is in restricted mode and you're trying to connect with a user that is not a database administrator. From what I've read, Oracle needs to be restarted in unrestricted mode to allow connections from standard users.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.