Hi
I was trying to do post installation for ArcSDE for oracle 11g and the first step asked for creation of sde user environment.
The first step failed as the oracle user is shown as sys and it was unable to create tablespace.
By default the user 'sys' is disabled.
We created tablespace and user (sde) by manually running the createsdeoracle sql script in \tools\oracle.
The script was successful and it created the user 'sde' and tablespace and was able to connect this user through oracle client.
The dbf file is created in my c:directory.
Now when i use GUI post installation for second step (Repository set up) and selecting the configurations as default for all the three options(giomgr,dbinit, dbtune) and clicking on 'Next' leads to repository set up for user name , password and net service name.
I gave user: sde, passowrd: sde and net service name as my service name (orcl) and clicking on next throws an exception
Connection to sde failed(0)
Extended error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
Do i need to set any variables or any jars missing to set.
variables set:
oracle_home:C:\oracle\product\11.2.0\dbhome_1
TNS_ADMIN:C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
my tnsnames.ora file
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listner.ora file
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = yyy))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
)
)
How to resolve the below problem
Connection to sde failed(0)
Extended error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
