I know the title shows an "obvious" ORA error, but I tried to connect to the db I just created, under oracle dba user (I'm sure about the group and user, I've done the database creation more than 100 times here) and it gives "Insufficient Privileges" error. We use a script for our database creation, which does not create sqlnet.ora file at all (there is none under $ORACLE_HOME/network/admin, listener and tnsnames are there).
Can someone give some tips and hints over the issue? I'm totally frustrated with this problem.
Actually I found a workaround for the problem. I've changed the places of some database files (for backup and recovery reasons) and they cause the oracle to throw insufficient privileges error.
Now its working fine, I should look deeper inside the file system. Maybe some problem with read/write/execute permissions on database files.
BTW, though its off-topic here, but I'm trying to run some scripts from another remote server on this database and it throws an "invalid username/password" error. Any hints?