||I have the same problem trying to create a 10g database and ArcSDE 9.2 on a new server, say A.
I know I have correct environment parameters for oracle_home, nls_lang, tns_admin,ORACLE_BASE, SDEHOME, LD_LIBRARY_PATH, and oracle_sid. The database is up and running, the database has got an entry in tnsnames.ora and with the help of the command "lnsrctl status" I can see that everything is OK. The OS user that owns the database, with dba and oinstall rights, is able to log on, but sde user, which has got dba and oinstall rights, is unable to log on when trying to log on with the command: sqlplus userid/password. It gives me:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied
while sqlplus userid/password@database_name lets me to log on into the database.
I have a GEO-database running in Oracle 9i on another server, say B.
When I add the TWO_TASK parameter in my dbinit.sde or .profile for the sde user on server A, sqlplus userid/password logs on to the database running in Oracle 9i on the server B.
What should I do?