Hello!

I am transforming a 2-tier BaaN IVc2 installation two 3-tiers.

Originally the BaaN IVc2 Porting Set 6.1c.06.02 was connecting to Oracle 8.1.7.0. in the same server on box AIX 4.3.
The IP of this server is 172.16.10.11

Finally the disk for the database at the server is finished. And the server can not accept more disks.

So, I installed Oracle 9.2.9.0.1 over a Intel Server using XP Professional Version5.1 until Service Pack2. With IP 172.16.9.11

My regular clients use BECS (is this bw?) B40c57.

1) I already set variables ORACLE_SID=centella, TWO_TASK=centella in the .profile of bsp.

2) Change the $BSE/lib/tabledef6.1 to:
*:*:oracle8(ORACLE_HOME=C:\oracle\oracle92,ORACLE_SID=centella):N

3) add to $BSE/lib/defaults/db_resource:
TWO_TASK=centella

3) I manually delete the "bsp" user from $BSE/lib/ora/ora_users and create it again with ora8_admn6.1

Obviously I have been reading other trails in here :D

When I use ba6.1 it works superb, I can enter to tables in 000 company and create, delete transactions in production companies in the new database over Oracle9 in Windows box.

BUT!! :eek:

When I use bw I got the following error:

3004-300: You entered an invalid login name or password
rexec failed host: 172.16.10.11 username bsp command /baan/bse/bin/ipc_boot6.1
error bw failed to connect oto 172.16.10.11!bshell

I am a little confused as far as I know the bw uses the ipc_info to connect to the database Oracle and Oracle8 uses tnsnames.ora to connect directly via SQLNET to oracle9 in the Windows box. Why the bw is reporting a "rexec" error" if the connection was already made to the AIX box? :confused:

ba6.1 is already working I do not know why this error is happenning.

Thank you deeply in advance for your help. ;)

Hi there,

highly unusual to use baan on AIX as application server and Oracle on Windows XP as database server. But at least for a test/development system this should be ok.

The error message realluy does not sound like an oracle error at all. I understand your way of thinking: I changed so many oracle related settings, so the error must be here.

But the error says optherwise. To make sure, check which log files are created in $BSE/log when you log into baan with bw. If there is no log.oracle8 created, then in your case, baan did not even start the oracle driver. and really simply could not connect to aix. So which logfiles are created with which entries?


Regards

Markus

Dear Markus,

I erase all the logs in $BSE/log and recreate the error with BW.

I have these 3 files created: log.bshell, log.ipc_boot6.1 and log.oracle8, so I think at least it is getting a little conection to oracle :)

The contents of the files are:

log.bshell:
2007-11-15[18:49:13]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[18:49:13]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/mir/mir/bdb_fun.c: #1026 keyword: DB error
2007-11-15[18:49:13]:E:bsp: Pid 16556 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[18:49:13]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[18:49:13]:E:bsp: Errno 0 bdb_errno 510 (Database not on)
2007-11-15[18:49:13]:E:bsp: Log_mesg: Error 510 (Database not on) on SELECT
2007-11-15[18:49:13]:E:bsp: ******* E N D of Error message *******
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[18:49:13]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/mir/mir/bdb_fun.c: #1026 keyword: DB error
2007-11-15[18:49:13]:E:bsp: Pid 16556 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[18:49:13]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[18:49:13]:E:bsp: Errno 0 bdb_errno 510 (Database not on)
2007-11-15[18:49:13]:E:bsp: Log_mesg: Error 510 (Database not on) on SELECT
2007-11-15[18:49:13]:E:bsp: ******* E N D of Error message *******
2007-11-15[18:49:25]:E:bsp:
2007-11-15[18:49:25]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[18:49:25]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/mir/ds_link/li_init.c: #351 keyword: ds_close_server
2007-11-15[18:49:25]:E:bsp: Pid 16556 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[18:49:25]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[18:49:25]:E:bsp: Errno 0 bdb_errno 0
2007-11-15[18:49:25]:E:bsp: Log_mesg: Detected Display Server Termination
2007-11-15[18:49:25]:E:bsp: ******* E N D of Error message *******

log.ipc_boot6.1 is empty.

log.oracle8:
2007-11-15[18:49:13]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[18:49:13]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_native.c: #1991 keyword: Oracle Error
2007-11-15[18:49:13]:E:bsp: Pid 20026 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[18:49:13]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[18:49:13]:E:bsp: Errno 0 bdb_errno 0
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: dbs_errno = 0Error 510 occurred:
2007-11-15[18:49:13]:E:bsp: Error ORA-12545 occurred during logon.
2007-11-15[18:49:13]:E:bsp: ORA-12545: Connect failed because target host or object does not exist
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: Error BDB-510 returned.
2007-11-15[18:49:13]:E:bsp: Check the Oracle settings:
2007-11-15[18:49:13]:E:bsp: NLS_LANG = 'american_america.we8iso8859p1'
2007-11-15[18:49:13]:E:bsp: ORACLE_HOME (client) = '/baan/bse/lib/ora/oracle_home' (resource oracle_client_home)
2007-11-15[18:49:13]:E:bsp: ORACLE_HOME (server) = 'C:\oracle\oracle92' (resource oracle_server_home)
2007-11-15[18:49:13]:E:bsp: Oracle Service Name = '' (resource oracle_service_name --> TWO_TASK)
2007-11-15[18:49:13]:E:bsp: ORACLE_SID = 'ricoh2'
2007-11-15[18:49:13]:E:bsp: Connection used oracle_local_template ( ? = oracle_server_home, @ = oracle_sid ):
2007-11-15[18:49:13]:E:bsp: (DESCRIPTION=(SDU=8192)(TDU=8192)(ADDRESS=(PROTOCOL=beq)(PROGRAM=C:\oracle\oracle92/bin/oracle)(ARGV0=oraclericoh2)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=8192)(TDU=8192)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_HOME=C:\oracle\oracle92,ORACLE_SID=ricoh2'))(CONNECT_DATA=(SID=ricoh2)))
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: Logon failed; errno 510
2007-11-15[18:49:13]:E:bsp: Flushed at /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_driver.c : #215.
2007-11-15[18:49:13]:E:bsp: ******* E N D of Error message *******

2007-11-15[18:49:13]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[18:49:13]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_native.c: #1991 keyword: Oracle Error
2007-11-15[18:49:13]:E:bsp: Pid 20028 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[18:49:13]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[18:49:13]:E:bsp: Errno 0 bdb_errno 0
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: dbs_errno = 0Error 510 occurred:
2007-11-15[18:49:13]:E:bsp: Error ORA-12545 occurred during logon.
2007-11-15[18:49:13]:E:bsp: ORA-12545: Connect failed because target host or object does not exist
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: Error BDB-510 returned.
2007-11-15[18:49:13]:E:bsp: Check the Oracle settings:
2007-11-15[18:49:13]:E:bsp: NLS_LANG = 'american_america.we8iso8859p1'
2007-11-15[18:49:13]:E:bsp: ORACLE_HOME (client) = '/baan/bse/lib/ora/oracle_home' (resource oracle_client_home)
2007-11-15[18:49:13]:E:bsp: ORACLE_HOME (server) = 'C:\oracle\oracle92' (resource oracle_server_home)
2007-11-15[18:49:13]:E:bsp: Oracle Service Name = '' (resource oracle_service_name --> TWO_TASK)
2007-11-15[18:49:13]:E:bsp: ORACLE_SID = 'ricoh2'
2007-11-15[18:49:13]:E:bsp: Connection used oracle_local_template ( ? = oracle_server_home, @ = oracle_sid ):
2007-11-15[18:49:13]:E:bsp: (DESCRIPTION=(SDU=8192)(TDU=8192)(ADDRESS=(PROTOCOL=beq)(PROGRAM=C:\oracle\oracle92/bin/oracle)(ARGV0=oraclericoh2)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=8192)(TDU=8192)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_HOME=C:\oracle\oracle92,ORACLE_SID=ricoh2'))(CONNECT_DATA=(SID=ricoh2)))
2007-11-15[18:49:13]:E:bsp:
2007-11-15[18:49:13]:E:bsp: Logon failed; errno 510
2007-11-15[18:49:13]:E:bsp: Flushed at /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_driver.c : #215.
2007-11-15[18:49:13]:E:bsp: ******* E N D of Error message *******


Thank you in advance!

ecorderol

Dear Markus,

I worked over a few variables of oracle and found that "root" on the AIX server has ORACLE_SID poiting to my old database. So I change it.

Also I erase "root" from $BSE/lib/ora/ora_users and add again with ora8_admin6.1 again.

After this changes the failure still going on, but one of the Oracle errors are changing from ORA-12545 to ORA-12154.

The new contents of the files are:


log.bshell:
2007-11-15[23:01:00]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[23:01:00]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/mir/mir/bdb_fun.c: #1026 keyword: DB error
2007-11-15[23:01:00]:E:bsp: Pid 15120 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[23:01:00]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[23:01:00]:E:bsp: Errno 0 bdb_errno 510 (Database not on)
2007-11-15[23:01:00]:E:bsp: Log_mesg: Error 510 (Database not on) on SELECT
2007-11-15[23:01:00]:E:bsp: ******* E N D of Error message *******
2007-11-15[23:01:00]:E:bsp:
2007-11-15[23:01:00]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[23:01:00]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/mir/mir/bdb_fun.c: #1026 keyword: DB error
2007-11-15[23:01:00]:E:bsp: Pid 15120 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[23:01:00]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[23:01:00]:E:bsp: Errno 0 bdb_errno 510 (Database not on)
2007-11-15[23:01:00]:E:bsp: Log_mesg: Error 510 (Database not on) on SELECT
2007-11-15[23:01:00]:E:bsp: ******* E N D of Error message *******
2007-11-15[23:01:19]:E:bsp:
2007-11-15[23:01:19]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[23:01:19]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/mir/ds_link/li_init.c: #351 keyword: ds_close_server
2007-11-15[23:01:19]:E:bsp: Pid 15120 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[23:01:19]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[23:01:19]:E:bsp: Errno 0 bdb_errno 0
2007-11-15[23:01:19]:E:bsp: Log_mesg: Detected Display Server Termination
2007-11-15[23:01:19]:E:bsp: ******* E N D of Error message *******

log.ipc_boot6.1 is still empty

log.bshell6.8:
2007-11-15[23:01:00]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[23:01:00]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_native.c: #1991 keyword: Oracle Error
2007-11-15[23:01:00]:E:bsp: Pid 13808 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[23:01:00]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[23:01:00]:E:bsp: Errno 0 bdb_errno 0
2007-11-15[23:01:00]:E:bsp:
2007-11-15[23:01:00]:E:bsp: dbs_errno = 0Error 510 occurred:
2007-11-15[23:01:00]:E:bsp: Error ORA-12154 occurred during logon.
2007-11-15[23:01:00]:E:bsp: ORA-12154: TNS:could not resolve service name
2007-11-15[23:01:00]:E:bsp:
2007-11-15[23:01:00]:E:bsp: Error BDB-510 returned.
2007-11-15[23:01:00]:E:bsp: Check the Oracle settings:
2007-11-15[23:01:00]:E:bsp: NLS_LANG = 'american_america.we8iso8859p1'
2007-11-15[23:01:00]:E:bsp: ORACLE_HOME (client) = '/baan/bse/lib/ora/oracle_home' (resource oracle_client_home)
2007-11-15[23:01:00]:E:bsp: ORACLE_HOME (server) = 'C:\oracle\oracle92' (resource oracle_server_home)
2007-11-15[23:01:00]:E:bsp: Oracle Service Name = 'ricoh2' (resource oracle_service_name --> TWO_TASK)
2007-11-15[23:01:00]:E:bsp: TWO_TASK = 'ricoh2'
2007-11-15[23:01:00]:E:bsp: ORACLE_SID = 'ricoh2' (ignored)
2007-11-15[23:01:00]:E:bsp: Logon failed; errno 510
2007-11-15[23:01:00]:E:bsp: Flushed at /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_driver.c : #215.
2007-11-15[23:01:00]:E:bsp: ******* E N D of Error message *******

2007-11-15[23:01:00]:E:bsp: ******* S T A R T of Error message *******
2007-11-15[23:01:00]:E:bsp: Log message called from /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_native.c: #1991 keyword: Oracle Error
2007-11-15[23:01:00]:E:bsp: Pid 13810 Uid 125 Euid 125 Gid 125 Egid 125
2007-11-15[23:01:00]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2007-11-15[23:01:00]:E:bsp: Errno 0 bdb_errno 0
2007-11-15[23:01:00]:E:bsp:
2007-11-15[23:01:00]:E:bsp: dbs_errno = 0Error 510 occurred:
2007-11-15[23:01:00]:E:bsp: Error ORA-12154 occurred during logon.
2007-11-15[23:01:00]:E:bsp: ORA-12154: TNS:could not resolve service name
2007-11-15[23:01:00]:E:bsp:
2007-11-15[23:01:00]:E:bsp: Error BDB-510 returned.
2007-11-15[23:01:00]:E:bsp: Check the Oracle settings:
2007-11-15[23:01:00]:E:bsp: NLS_LANG = 'american_america.we8iso8859p1'
2007-11-15[23:01:00]:E:bsp: ORACLE_HOME (client) = '/baan/bse/lib/ora/oracle_home' (resource oracle_client_home)
2007-11-15[23:01:00]:E:bsp: ORACLE_HOME (server) = 'C:\oracle\oracle92' (resource oracle_server_home)
2007-11-15[23:01:00]:E:bsp: Oracle Service Name = 'ricoh2' (resource oracle_service_name --> TWO_TASK)
2007-11-15[23:01:00]:E:bsp: TWO_TASK = 'ricoh2'
2007-11-15[23:01:00]:E:bsp: ORACLE_SID = 'ricoh2' (ignored)
2007-11-15[23:01:00]:E:bsp: Logon failed; errno 510
2007-11-15[23:01:00]:E:bsp: Flushed at /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_driver.c : #215.
2007-11-15[23:01:00]:E:bsp: ******* E N D of Error message *******


Also my bw gives two different kind of errors: I close the first error message, change nothing and the second error is different:

1st:
1: process 1 Fatal error : 510 (Database not on ) on Select
2: process 1 Fatal error : Can not continue in ottstpstdlib (mess)
3: process 3 Fatal error : 510 (Database not on ) on Select
4: process 3 Fatal error : Can not continue in ottstpstdlib (mess)

2nd:
1: 3004-300 You entered an invalid login name or password
2: rexec failed host '172.16.10.11' username 'bsp' command '/baan/bse/bin/ipc_boot6.1'
3: Error : bw failed to connect to 172.16.10.11!bshell

Also I tried to create a warp script but get the same 2nd error:

1: 3004-300 You entered an invalid login name or password
2: rexec failed host '172.16.10.11' username 'bsp' command '/baan/bse/bin/ipc_boot6.1'
3: Error : bw failed to connect to 172.16.10.11!wrap.script

Thank you in advance

ecorderol

I think the following is the case:

At some stage, baan made a funny/strange change to their portingset to default the oracle home to $BSE/lib/oracle_home (see you rlog files).

So it also expects your tnsnames.ora to ly somewhere there. intotal it is important to get your variables rights. So:

a) ORACLE_HOME in tabledef6.1 should be pointing to your oracle (client) installation on the application server. As this seems to be AIX, I do not think this is something like C:\...

b) Set all variables in one place (e.g. $BSE/lib/tabledef6), including TWO_TASK. It is not a good idea to spread this in many files (tabledef6.1 , bse_vars, defaults, ...). Actually my preference to set them only as environment variables in something called my_bshell (search on the forum), which replaces the bshell in ipc_info.

c) Specify TNS_ADMIn to point to $ORACLE_HOME/network/admin. Starting from a specific portingset, Baan changed the default to $BSE/lib/oracle_home, unfortunately next to nobody has the tnsnames.ora lying there.

Regards

markus

Dear Markus,

I concentrate all the variables in tabledef6.1 :TWO_TASK, ORACLE_SID, ORACLE_HOME.

Change 'C:\...' stuff for '/baan/bse...' in the ORACLE_HOME as you suggested.

I add the "tnsnames.ora" to the directory $BSE/lib/ora/oracle_home/admin

I erase all users from $BSE/lib/ora_users and add them again with ora8_admin6.1

And it worked perfectly! :cool:

Thank you very much Markuz!! :D

Best regards!! :D

Hi
i am also getting a similar message in my case i am moving from 2 tier AIX box to 3 tier Linux box.

2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ******* S T A R T of Error message *******
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Log message called from /view/port.9.0a/vobs/tt/servers/ORACLE_2/ora_native.c: #2339 keyword: Oracle Error
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Pid 12879 Uid 400 Euid 400 Gid 103 Egid 103 Pset jsingh@VDIOSDEVMS011.DEV.LOCAL:3544
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: user_type S language 2 user_name bsp locale ISO88591/NULL
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Errno 13 (Permission denied) bdb_errno 0
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: dbs_errno = 0, Error 510 occurred:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Error ORA-12545 occurred during logon.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORA-12545: Connect failed because target host or object does not exist
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Error BDB-510 returned.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Check the Oracle settings:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: NLS_LANG = 'american_america.us7ascii'
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_HOME = '/u01/app/oracle/product/12.1.0'
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_SID = ''
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Connection used oracle_local_template ( ? = oracle_home, @ = oracle_sid ):
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: (DESCRIPTION=(SDU=32768)(TDU=32768)(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/12.1.0/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=32768)(TDU=32768)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_SID='))(CONNECT_DATA=(SID=)))
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Logon failed; database user bsp; errno 510
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Flushed at /view/port.9.0a/vobs/tt/servers/ORACLE_2/ora_driver.c : #318.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ******* E N D of Error message *******

2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ******* S T A R T of Error message *******
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Log message called from /view/port.9.0a/vobs/tt/servers/ORACLE_2/ora_native.c: #2339 keyword: Oracle Error
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Pid 12882 Uid 400 Euid 400 Gid 103 Egid 103 Pset jsingh@VDIOSDEVMS011.DEV.LOCAL:3544
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: user_type S language 2 user_name bsp locale ISO88591/NULL
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Errno 13 (Permission denied) bdb_errno 0
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: dbs_errno = 0, Error 510 occurred:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Error ORA-12545 occurred during logon.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORA-12545: Connect failed because target host or object does not exist
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Error BDB-510 returned.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Check the Oracle settings:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: NLS_LANG = 'american_america.us7ascii'
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_HOME = '/u01/app/oracle/product/12.1.0'
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_SID = ''
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Connection used oracle_local_template ( ? = oracle_home, @ = oracle_sid ):
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: (DESCRIPTION=(SDU=32768)(TDU=32768)(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/12.1.0/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=32768)(TDU=32768)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_SID='))(CONNECT_DATA=(SID=)))
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Logon failed; database user bsp; errno 510
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Flushed at /view/port.9.0a/vobs/tt/servers/ORACLE_2/ora_driver.c : #318.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ******* E N D of Error message *******

2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ******* S T A R T of Error message *******
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Log message called from /view/port.9.0a/vobs/tt/servers/ORACLE_2/ora_native.c: #2339 keyword: Oracle Error
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Pid 12885 Uid 400 Euid 400 Gid 103 Egid 103 Pset jsingh@VDIOSDEVMS011.DEV.LOCAL:3544
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: user_type S language 2 user_name bsp locale ISO88591/NULL
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Errno 13 (Permission denied) bdb_errno 0
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: dbs_errno = 0, Error 510 occurred:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Error ORA-12545 occurred during logon.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORA-12545: Connect failed because target host or object does not exist
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Error BDB-510 returned.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Check the Oracle settings:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: NLS_LANG = 'american_america.us7ascii'
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_HOME = '/u01/app/oracle/product/12.1.0'
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_SID = ''
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Connection used oracle_local_template ( ? = oracle_home, @ = oracle_sid ):
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: (DESCRIPTION=(SDU=32768)(TDU=32768)(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/12.1.0/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=32768)(TDU=32768)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_SID='))(CONNECT_DATA=(SID=)))
2016-08-11[10:21:08(UTC+05:00)]:E:bsp:
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Logon failed; database user bsp; errno 510
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Flushed at /view/port.9.0a/vobs/tt/servers/ORACLE_2/ora_driver.c : #318.
2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ******* E N D of Error message *******

Jaskirat,

You have more than 1 problem to fix.

2016-08-11[10:21:08(UTC+05:00)]:E:bsp: Errno 13 (Permission denied) bdb_errno 0
Check the permissions to the file system and also for the tnsnames.ora file and Oracle client binaries.

2016-08-11[10:21:08(UTC+05:00)]:E:bsp: ORACLE_SID = ''
The ORACLE_SID environment variable has not been defined.

2016-08-11[10:21:08(UTC+05:00)]:E:bsp: NLS_LANG = 'american_america.us7ascii'
I think its incorrect too.
Refer to - http://www.baanboard.com/baanboard/showthread.php?t=62085&highlight=NLS_LANG