Hi experts,

I am facing error 2116 when login to Baan. This error gives ORA-1116.
Does anyone know how to solve this?

This funny thing is I can enter using the root password but only face this error when using bsp login.

Please help

Thanks and regards,

Hi there,

The error says, that the user can not open the datafile. This is consistent with your observation, that the root user can work (because he can obviously open any file on a unix system).

The cause for this is most likely the following:

When the user logins, the oracle user process is started by executing the "oracle" binary in $ORACLE_HOME/bin. Check the following for this binary:

a) It should by owned by user "oracle"
b) it should have the "setuid" bit set.
c) All datafiles, redologs, controlfiles etc. should be owned by oracle and read/writeable by oracle.

On my system "ls -l $ORACLE_HOME/bin/oracle" returns:

-rwsr-s--x 1 oracle dba /oracle/product/9.2.0/bin/oracle

Regards

Markus

Hi Markus or anyone

My oracle file already has the above mode/permissions
Is there any other suggestion for me to try?

Appreciate your help in advance.

Thanks and regards

if the oracle binary itself is ok, what about the datafiles, controlfiles, redologs, ...?

If you are lucky, you will also find in one of the dump directories (bdump/cdump/udump) and in alert.log in indicator, which specific file oracle can not open.

Regards

Markus

My datafiles, controlfiles ,redofiles has oracle:dba ownership
what should be there permission/modes?

And where can i find the bdump/cdump/udump and alert.log? which directories?
I am on 10.2.0 version

thanks

if you are not security paranoid, then just set them to 775. Origionally it should be wnough to be read/writable for user oracle and that's it.

The locations of the diverse directories depends on your parameter settings. The web interface of Oracle will tell you or connect as sysdba to the database and issue a:

show parameter dump

The alert log is in the background dump destination.


Regards

Markus

BY default, the Oracle dump directories should be under the /<Your Oracle FS>/apps/oracle/admin/<$ORACLE_SID>/ and the oracle alert file should be like alert_<$ORACLE_SID>.log under the bdump. Use the "find" command, if UNIX, to find the alert file.

Hello markus or anyone

I have changed the baan/bse directory to bsp:bsp owner and with chmod 777.
also changed all oracle directory with owner oracle:dba and chmod 775
also changed ../bin/oracle with chmod 6755
also changed /baandata with chmod 777 and owner oracle:dba
also checked ../admin/bdump, adump etc all is 777 with oracle:dba

still cannot get bsp to login.
still can login with root

Why?

Frustrated

regards,

Permission Problem ? Don't look like.
May be the permission on the Datafiles are not ok.

Problem Description:
====================

An ORA-01116 is issued whenever Oracle is unable to open a datafile with the
database up and running:

ORA-01116: "error in opening database file %s"
Cause: Usually the file is not accessible.
Action: Restore the database file.

ORA-01116 errors are usually followed by an ORA-01110 and possibly an Oracle
operating system layer error such as ORA-07368.


Problem Explanation:
====================

During regular database operation, Oracle is constantly accessing the various
datafiles for reads and writes. If at any time when the database is open
Oracle cannot open a datafile, an ORA-01116 results. This error implies that
the existence of the datafile is recorded in the data dictionary and the
controlfile, but Oracle cannot locate it physically, at the operating system
level.

When a datafile is missing, events that typically trigger an ORA-01116 include:

- Shutdown normal or immediate

- Log switches

- Database checkpoints

There are two main possible causes for an ORA-01116:

1. The datafile does exist, but Oracle cannot find it.

1.A) It may have been renamed at the operating system level, moved to a
different directory, disk drive, etc. In this case, simply restoring the
datafile to its original name and location will solve the problem.

1.B) You intentionally moved the datafile to a different location, but forgot
to rename it at Oracle level. For example, you may have decided to move
the index tablespace datafiles to another disk to improve performance, but
forgot to rename them inside Oracle. In this case, you must rename the
datafile(s) from within Oracle. Look for the Solution Reference on
renaming datafiles.

2. The datafile has been physically removed or damaged to an extent that
Oracle cannot recognize it anymore.

In this case, the datafile is lost and the solution depends on the type of
datafile involved, i.e., on the tablespace to which the datafile belongs.
Look for Solution References on recovering from the loss of datafiles in the
various types of tablespaces.


Solution Description:
=====================

There are two types of solutions for an ORA-01116:


I. THE DATAFILE IS LOST OR TOO DAMAGED
--------------------------------------

In this case, the solution depends on the tablespace to which the datafile
belongs. Look for a Solution Reference matching the type of datafile lost.


II. THE DATAFILE HAS SIMPLY BEEN MOVED OR RENAMED
-------------------------------------------------

If you originally wanted to change the name/location of the file, look for the
Solution Reference on how to rename datafiles inside Oracle. If the file had
been moved or renamed by mistake, simply restore it to its original
name/location.

Hi Martin,

if a file would actually be missing, how would you explain the fact, that root can login, but nobody else?

Regards

Markus

Hi Martin,

if a file would actually be missing, how would you explain the fact, that root can login, but nobody else?

Regards

Markus

See my post :

Permission Problem ? Don't look like.
May be the permission on the Datafiles are not ok.

When you login into Oracle you are using the Oracle binaries permissions, not the user that is logging in, check first you alert.log, you should have more information there regarding possible problems that may exist.

i had once on AIX an ulimit problem,
datafiles > 4 GB and ulimit for files 2 GB ?

Hi all

We solved this by going to Smitty in Aix
and then we set the Soft Files settings to -1.

don't know why this setting should be set that way but it works now.

Regards,