We have just copied a snapshot of our production system on to our pre-production server. When I've gone to use the ttdba0115m000 session to change the Oracle passwords in the ora_users file and the rdbms I keep getting an error saying program cannot be started.

When I check in the log.ora8_maint6.1 log I can see errors saying the Oracle_home does not exist which then leads onto errors saying could not load shared Oracle library. Which I'm presuming is down to the fact that the oracle _home cannot be found. However $ORACLE_HOME, at the OS level, is set and can be verified by running echo $ORACLE_HOME -

[bsp@baan02 log]$ echo $ORACLE_HOME
/ora/app/oracle/product/10.2.0/db_1

I do not encounter this issue on our production server and both have the same environment. What else can I check?

I've attached the log for reference.

Thanks

PJ

try this,

1. run create and dump using session ttdba0120m000
2.Then run session ttdba0115m000.

Hello Sushil,

I get the same errors when trying to use ttdba0120m000 session

seems, that is an problem with your permissions on the Oracle directory. (shared client libs could not loaded).
Ckeck permission on the new server or run $ORACLE_HOME/install/changePerm.sh as user root

greetz
Martin

I had already considered but ran the script anyway but still the same issue and errors

Hi,

Did you check if there is an entry for ORACLE_HOME in $BSE/lib/defaults/db_resource and/or $BSE/lib/tabledef6.1?

Regards,

Nick

Points to check.

1.is Sqlplus Connectiong from another client ?
2.TNSping working ?
3.Is $BSE/lib/ora/ora_users and $BSE/lib/ora/ora_groups files copied from Baan production instance to the test instance.
4.is BSP and baan user created in oracle db with the following roles:
connect, r_baan, sysdba.Is the password is the same as the production instance.
5.Is Variables set in $BSE/lib/defaults/db_resource

#db_resource file
db2_minmem:
db2_bidi:
dbsinit:
oracle_service_name:
tns_admin:
oracle_client_home:

Oracle in general is okay I can sqlplus across servers, tnsping etc.

I've also manged to replicate the issue, be it in a slightly different way, on our live server. Seeing exactly the same errors.

The problem only seems to be specific to this particular session. If it were more of a general Oracle issue you would see errors during Baan start-up etc. So I know ora_users, ora_groups and users in Oracle db are okay.

You shouldn't need to set oracle_home on db_resource, we never have done. I did try it but it made no difference.

I think the Baan client is not picking up the ORACLE_HOME enviroment setting from OS, maybe?? Unfortunatley I cannot remember the last time I used the ttdba0115m000 session so I can't back-track on what's been changed.

try "lsnrctl status" .

1.check if the status shows ready .

2. try ipaddress instead of host name in tnsnames.ora.
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=< try ip here >)(PORT=1521)))

3.if it is windows - i shall had suggested to enter "<server ip> <oracle_sid>" in hosts file.

Try alternative for the same in Linux. so that if you "ping baan " then it should reply.
(i had once faced this at the Dev server)

your oracle_home environment variable is getting overridden in baan.


2009-06-02[07:56:17]:E:bsp: Could not load shared Oracle library
2009-06-02[07:56:17]:E:bsp: path = /lib


that should be $ORACLE_HOME/lib. ORACLE_HOME is null in your case so it's looking in /lib

some places to look for $ORACLE_HOME getting over-ridden (as mentioned above are)
$BSE/lib/defaults/*
$BSE/lib/tabledef6.x

if you're on windows it could be in the registry.

If you're using blogind it could be in blogin's environment.

If you have a bshell wrapper script it could be getting over-written there.

The order of precedence is
Environment > tabledef > db_resource

Dave

#db_resource file
db2_minmem:
db2_bidi:
dbsinit:
oracle_service_name:
tns_admin:
oracle_client_home:

you're using both db2 and oracle?

Hi Dave,

I'm only using oracle.

Have checked tabledef6.1 and db_resource files and oracle_home is not being overridden here. I don't think we have a wrapper script in place how would I confirm this?

Thanks

PJ

the db2 thing was for sushil.

is it being set at all in those files?

because it should be set in $BSE/lib/default/db_resource

Is the database on the baan server or is it on a separate server?

Dave

The db is on the same server.

Oracle_home is set correctly in tabledef6.1

It isn't set in db_resource although I've tried it and it makes no difference.

then it's being overriden in your environment.

are you using blogin to connect?

Dave

using rexec
oracle_home is set okay when I connect via the command lin

lower case?

try this from the commandline:
ORACLE_HOME=/path/to/oracle/home ba6.1

Dave

also try

qptool6.1 -q"select * from ttaad200" -c0

if that doesn't return data then do:
ORACLE_HOME=/path/to/oracle/home qptool6.1 -q"select * from ttaad200" -c0

Also, post your tabledef6.1 / db_resource please.

Dave

Hi dave,

I just quoted some example parameters of db_resource file.

Hi dave,

I just quoted some example parameters of db_resource file.

Ah ok =)

Dave

Hello Dave,

oracle_home should be $ORACLE_HOME (just me being lasy!)

"ORACLE_HOME=/path/to/oracle/home ba6.1" opened up ba6.1 okay, can navigate through menus, tried to run the ttdba0115m000 session but I can't remember the ascii keystrokes to amend and save a record.

I had already ran the qptool and this returned data from tccom010 in one of our Baan companies without issue.

Please see attached for db_resource and tabledef

try adding:
oracle_home:/ora/app/oracle/product/10.2.0/db_1
oracle_sid:baan

to your db_resource, it's case sensitive so make sure you put it in exactly as i have it.

There is an old bug where the ttdba sessions wouldn't pick up ORACLE_HOME from the environment or tabledef, it HAD to be in db_resource.

Dave

Thanks Dave,

Entering this in to db_resource resolved the initial error however, I now get a new one.

2009-06-03[09:03:28]:E:bsp: ******* S T A R T of Error message *******
2009-06-03[09:03:28]:E:bsp: Log message called from /BAAN/view/port.6.1c.07.21/vobs/tt/servers/ORACLE_2/ora_maint.c: #2694 keyword: Execute
2009-06-03[09:03:28]:E:bsp: Pid 14455 Uid 125 Euid 125 Gid 125 Egid 125
2009-06-03[09:03:28]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2009-06-03[09:03:28]:E:bsp: Errno 0 bdb_errno 0
2009-06-03[09:03:28]:E:bsp:
2009-06-03[09:03:28]:E:bsp: dbs_errno = 922, Error 922 occurred:
2009-06-03[09:03:28]:E:bsp: Error ORA-922 occurred during execute.
2009-06-03[09:03:28]:E:bsp: ORA-00922: missing or invalid option
2009-06-03[09:03:28]:E:bsp:
2009-06-03[09:03:28]:E:bsp: Flushed at /BAAN/view/port.6.1c.07.21/vobs/tt/servers/ORACLE_2/ora_maint.c : #2697.
2009-06-03[09:03:28]:E:bsp: ******* E N D of Error message *******

I'm presuming I can run ttdba0115m000 as bsp?

what's your db_resource look like right now?

that's usually the result of a typo somewhere or something.

Dave

Hi Dave,

db_resource =

rds_full:2
dbsinit:021
ora_init:0111000
ora_max_array_insert:2
ora_max_array_fetch:2
ssts_set_rows:3
oracle_home:/ora/app/oracle/product/10.2.0/db_1
oracle_sid:baan
#first_rows_hint:2
first_rows_hint:1
nls_lang:american_america.we8iso8859p1
# Line added on Infor supports request#
ansi_outer_join:0

hmm. nothing obvious.

you could try DBSLOG=1570 and then look for 922 in the log file.

Dave

couldn't find anything with regards to the 922 error.

Yeah, i don't see anything either.

Just a guess but what is your real ORACLE_SID?

if you set ORACLE_SID=baan or ORACLE_SID=BAAN which allows you to connect via sqlplus?

Dave

Hi,

Can you Just post your tnsnames.ora and listener.ora file.

Rgds,
sushil

Sorry for the delay in replying to you on this.

In the end I asked Baan support and they came back and told me that tye ttdba0115m000 does not work very well with Oracle and gave me the following solution to changing passwords.

===========================================
1. Enter SQL*Plus
2. Supply a DBA user ID
3. Enter the DBA user's password.
2. Use the Oracle Alter User command to change the password of user baan in Oracle:

ALTER USER <username> IDENTIFIED BY <password>;

4. Log into Baan Tools-> Database Management-> RDBMS->Maintenance->Maintain Database Users (ttdba0115m000).
From the 'Database User' form select the user then click the 'Database User Data' form and change the password.
5. Make sure the 'Create User' field has "By Baan" selected (Do Not select "Externally").
6. Then select the 'Convert User' button on the 'Database users' form.
7. (With your Super User still log into Baan) Now try to log in as user with the new password.
==================================================

Thanks for your help and advice on this. I'll follow the Infor way in future.

Cheers

PJ

Well, that's not much of a solution =)

another option would be to call ora8_maint6.x directly.

See solution 159165


Dave

ttdba0115m000 does not work very well with Oracle .

I have noticed Baan4c4 consistantly with Oracle for many installations - it holds very good .

Their might be some other problem.

Dear pjohns,

is the live and test system structur 100 % the same, e.g. is baan and oracle running on one server or is live system on 2 servers (one for baan, on for oracle), testsystem is on one server (baan and oracle).

Regards,

Kozure