Problem Connect to Oracle
Posted 07 July 2003 - 09:26 AM
Both of the software i have install in my laptop ( OS = Windows 2000 ) .
The VIP version is 5.5r303 Build 218 and the Kernel version is 3.03.
I keep hitting the error "Ora 12203 : TNS Unable to connect to Destination".
I have create a TNS in my local PC and tested the connections and it's working.
I not very sure how to set the Pro4.ini . It's would be great if there is a sample .
Is there anything else that i need to set ?
Posted 08 July 2003 - 07:37 AM
Dont know if it works with Oracle 9i, but this is what we use of version 8i....
You will obviously have to changfe the ORACLE_DLLNAME to where 9i's DLL is and also supply the instance/password@sid bit....
[ENVIRONMENT] SQL_NOSIG=Y SYBASE_SELECT_FOR_UPDATE=TRUE SQL_DBNAME=z ORACLE_DLLNAME=d:\Proiv.53\PROORA815.DLL SQL_CURSORS=32 [Database - SQLDEFAULT] FILETYPE=ORACLE CONNECTION=user/password@sid
Posted 09 July 2003 - 01:10 AM
However i still encounter the same problem where it can't connect to the database.
Here i list the pro4.ini i have set :
Where the SID = PRODEMOS and DB Name = PRODEMOS
[Serial - 5.0] Customer=QR RETAIL Installation0=5AGF 5HED 5G54 B822 3E35 25HA [Serial Info - 5.0] Installation0=Evaluation mode for SiteId 180010, valid through Thu Aug 07 2003 [ENVIRONMENT] PROPATH=C:\PRO55\BOOTS ;PRODATA=C:\PRO55\BOOTS PRODATA=d:\vipdemo\data PRORUNTYPE=DEV GUI=Y PROTERM=GUIDEV STARTCLIENT=C:\PRO55\PROGUI.EXE /INI:C:\PRO55\LOOPBACK.INI FSIDEFAULT=PRO-ISAM ORACLE_SID=PRODEMOS ORACLE_HOME=d:\oracle8idb SQL_DBTYPE=ORACLE SQL_USERNAME=PROFIT SQL_PASSWORD=PROFIT1888 ORACLE_DLLNAME=C:\PRO55\PROORA815.DLL SQL_CURSORS=40 P2000_SELECT_FOR_UPDATE=TRUE DB2_SELECT_FOR_UPDATE=TRUE [USER DEFAULT] PROIVOPER=SYS PROIVCODIV=PTI [Database - SQLDEFAULT] FILETYPE=ORACLE CONNECTION=PROFIT/PROFIT1888/PRODEMOS [CLIENT32] INSTALLDIR=C:\PRO55 Command1=PROIV.EXE
Really appreciate someone who can help. We need to set up this environment for our demo coming next week.
Posted 09 July 2003 - 02:26 AM
Have try CONNECTION=PROFIT/PROFIT1888@PRODEMOS
But now it giving another error messge :
Ora 12154 TNS could not resolve service name
When we try CONNECTION=PROFIT/PROFIT1888/PRODEMOS
it giving error msg Ora 12203 TNS Unable to connect to destination.
Is there anything i need to set besides this ini files ?
I have try to connect to the databases using the TNS Prodemos and it's working fine.
Posted 09 July 2003 - 05:47 AM
Posted 09 July 2003 - 06:00 AM
Just because the service name shows up when you run "lsnrctl status" does not always mean the LISTERNER is correctly set up.
Tell me about it!!!
I've had to spend a bit of time trying to get the listner to work correctly.
A DB I setup would work fine locally, but would not connect from a remote PC.
If I stoped the listner, then started it again, it would allow remote connections for 60 seconds, then another listener service would auto start (from somewhere??) and then all remote connections would fail to connect??
Very strange, but its the first time I've installed and setup Oracle, so I had probably done something stupid
Posted 09 July 2003 - 07:47 AM
Do you mean pro4.ini and not ProIV.ini?
These settings should be in pro4.ini, there is nothing in proiv.ini that is to do with connections....
This is my pro4.ini...
[CLIENT32] INSTALLDIR=D:\ProIV\5.5\220 Command1=PROIV.EXE [ENVIRONMENT] ;TRACEALL=15 ;TR_PATH=D:\TRACE.TRC PROPATH=D:\ProIV\5.5\220\BOOTS PRODATA=D:\ProIV\5.5\220\BOOTS PRORUNTYPE=DEV GUI=Y PROTERM=GUIDEV STARTCLIENT=D:\ProIV\5.5\220\PROGUI.EXE /INI:D:\ProIV\5.5\220\LOOPBACK.INI FSIDEFAULT=PRO-ISAM USERNAME_VALIDATE=N SQL_NOSIG=Y SYBASE_SELECT_FOR_UPDATE=TRUE SQL_DBNAME=z CDATE_50=Y DATE_SC_50=Y ORACLE_DLLNAME=d:\Proiv\5.5\220\PROORA815.DLL SQL_CURSORS=32 [Database - SQLDEFAULT] FILETYPE=ORACLE CONNECTION=user/password@sid [Serial - 5.0] Customer=robdon Installation0=A42E 5HED 5G5A HFAD 3EAD 44CF [Serial Info - 5.0] Installation0=Evaluation mode for SiteId 501781, valid through Thu Jul 24 2003
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users