Thanks for taking the time to help out
I have setup similar configurations several times but this one has me stumped
+ What is your ORACLE_HOME?
C:\app\jhollingsworth\product\11.1.0\db_1
+ What is your ORACLE_SID?
gisdata
+ What does listener.ora contain?
# listener.ora Network Configuration File: C:\app\jhollingsworth\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = anvik)(PORT = 1521))
)
)
+ What does tnsnames.ora contain?
# tnsnames.ora Network Configuration File: C:\app\jhollingsworth\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
GISDATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = anvik)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gisdata)
)
)
+ What is your SDEHOME?
C:\Program Files\ArcGIS\ArcSDE\ora11gexe
+ What is in your PATH?
C:\app\jhollingsworth\product\11.1.0\client_1\bin;C:\app\jhollingsworth\product\11.1.0\db_1\bin;C:\WINDOWS\System32;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\system32\WBEM;C:\WINDOWS\system32\WindowsPowerShell\v1.0;c:\Program Files\Microsoft SQL Server\90\Tools\binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\app\jhollingsworth\product\11.1.0\db_1\OPatch;C:\Program Files\ArcGIS\ArcSDE\ora11gexe\bin
+ Are you using the post-install GUI? If so, what values have you plugged in?
yes and have not been able to get past entering the sys password -error contains an incorrect path.
+ Have you tried using the manual post-install proceess?
no
+ Have you tried executing 'sdesetup -o prerequisite_check'?
connection to sde failed(0)
Extended error: ORA 12560: TNS:protocol adapter error
error: underlying BDBMS error (-51).
Error checking geodatabase setup prerequisities.
so then i set ORACLE_SID=gisdata
then i get bad login user(-9)
+ What is in your dbinit.sde and services.sde files?
dbinit is empty
/* $Id: services.sde,v 1.2 1999/01/22 01:01:35 donna Exp $ */
#
# ESRI SDE Remote Protocol
# Note: uncomment the line below to use ESRI's default port
#
#esri_sde 5151/tcp
#
+ What is in your sde_setup.log?
no setup log can not get past step one of post install
It generally takes me five minutes after Oracle install completes to have ArcSDE running.
My process does have some quirks:
i agree it is very simple most of the time but this time not even sure where to start other than over.
+ I *never* install software in a directory with spaces or special characters (e.g., D:\Esri)
will try but has not been a problem in the past
+ I copy the install directory to an alternate directory, uniquely named for each instance
(e.g., C:\Esri\sdeora10sp1_mysid) and manually set the SDEHOME, ORACLE_HOME, PATH
and ORACLE_SID appropriately
+ I manually create the SDE tablespace and SDE user, edit the services table with Notepad,
and use the command-line 'sdesetup' and 'sdeservice' utilities to configure ArcSDE in a
command window.
have always used the GUI
thanks
jamie