Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th October 2016, 18:24
JavierElric JavierElric is offline
Junior Member
 
Join Date: Oct 2016
Posts: 5
JavierElric is on a distinguished road
Baan: baan IV - DB: ORACLE - OS: HP-UX
Errno 0 bdb_errno 2045 (database error 1045)
Baan: Baan IVc4
DB: Other/Unknown
OS: HP-UX 11.10
C/S: None/Unknown

Hi guys, any ideas?
I am trying to find out why we are getting this error message at login

Thank you so much!

Errno 0 bdb_errno 2045 (database error 1045)
FATAL ERROR: Error 2045 (database error 1045) on select
Can not continue in ottstpstdlib (<70>)[sql.exec]
Reply With Quote
  #2  
Old 11th October 2016, 18:08
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Problem:
ORA-1045: user lacks CREATE SESSION privilege; log on denied

Solution:
Do not grant create session using role, grant directly to user:

grant create session to myuser;

Refer to -
https://www.techonthenet.com/oracle/errors/ora01045.php
http://support.esri.com/technical-article/000002254
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Sponsored Links
  #3  
Old 12th October 2016, 19:50
JavierElric JavierElric is offline
Junior Member
 
Join Date: Oct 2016
Posts: 5
JavierElric is on a distinguished road
Baan: baan IV - DB: ORACLE - OS: HP-UX
Thank you! it worked. :)

Quote:
Originally Posted by NPRao View Post
Problem:
ORA-1045: user lacks CREATE SESSION privilege; log on denied

Solution:
Do not grant create session using role, grant directly to user:

grant create session to myuser;

Refer to -
https://www.techonthenet.com/oracle/errors/ora01045.php
http://support.esri.com/technical-article/000002254
Thank you! it worked.
Reply With Quote
  #4  
Old 13th October 2016, 14:35
JavierElric JavierElric is offline
Junior Member
 
Join Date: Oct 2016
Posts: 5
JavierElric is on a distinguished road
Baan: baan IV - DB: ORACLE - OS: HP-UX
thank you, you are a pro!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 1308 (database on error 308) touranus Tools Administration & Installation 3 8th December 2015 16:09
Additional ERPLn database for new custom tables VishalMistry Tools Administration & Installation 1 9th September 2010 22:57
How to split Baan Application and Baan Database ? baaniac Operating Systems & Databases 4 2nd June 2009 03:48
Detected database server termination Dwallace Tools Administration & Installation 3 8th November 2006 23:51
What are Baan's recommendations on database logging modes? Caner.B Operating Systems & Databases 3 26th June 2002 13:34


All times are GMT +2. The time now is 16:46.


©2001-2017 - Baanboard.com - Baanforums.com