OBIEE can not connect to the database.
ORA-12154: TNS:could not resolve the connect identifier specified
This method (and also the connect descriptor) by pass the tnsnames.ora. You don't need it.
Check here an example
This message says that the instance of the database is not started. Problem with the database ?
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
It doesn't mean that you didn't have any access to your database. I understand, I don't have installed a database on my latptop, it's on a remote computer on the local network.
The database doesn't exist on my local machine. First I have to import the remote database.
Then to be able to test your repository, of course you have:
The remote machine belongs to the customer company and is located at the customer company. I don't have any data, any database of them in my local.