Recent content by techstar

Marco- Oracle permits you to develop applications with Instant Client built in. Will you consider a DOA option with Instant Client incorporated so that there is no need for the user to install Instant Client separately? We really need this

No firewall.

Marco- I could buy this, except notice the 1521 in the port, where I am specifying 1522.

Marco- Here is the sqlnet.log from a delphi program using doa. Same problem: *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=tsidb4.tsisports.com)(CID=(PROGRAM=C:\Documents and...

CTzen - Thanks, but the problem is also happening in DOA, so I think it needs some resolution.

As far as I know, Instant Client does not have tracing. Here is the entry in sqlnet.log. Note that it is changing the port to 1521 from 1522: Fatal NI connect error 12541, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=tsidb4.tsisports.com)(CID=(PROGRAM=C:\Program Files\PLSQL...

Marco - are you assuming Port 1521 when using instant client?

ORA-12541 TNS:No Listener

1. I installed instant client and verified that it works. 2. I can log on using the database string: (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = TSIDB4)(PORT = 1522))) (CONNECT_DATA =(SERVICE_NAME = TSIDB4))) 3. That exact same string (without cr) exists in the tnsnames.ora...

The ORA-28011 Grace Period Warning seems to be handled poorly by DOA. It seems that the TOracleLogon component fails entirely and the TOracleSession component requires that the password be changed although it has not yet expired. Is this is recognized bug and is a fix planned?

Yes, we have run into this problem on numerous occasions. Here are some things you need to do. 1- Get the open_cursors parameter in the init file set as high as possible. 2- Use .closeAll instead of close to close your data queries. 3- Right after establishing your Oracle session(s), issue...

Yes, we have run into this problem on numerous occasions using DOA and Java (SQLJ and JDBC). There are clearly some Oracle problems and memory leaks in the various verions. Plus, SQL*NET tries to keep cursors cached to improve performance. Here are some things you need to do. 1- Get the...

I would like to create an Oracle report and then "send" it to MS Word or Excel. The idea is to eliminate the need for a client report writer while using the power of Oracle to get the job done. I know that Office Partner from TurboPower offers a package that has objects that do some of this...

You can also run a useful test bypassing tnsnames.ora by using the right side of the tnsnames.ora entry as the database identifier. For example to connect to: TESTDB= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = TEST.ORG.COM)(PORT = 1521)) ) (CONNECT_DATA...

Martin- I have experienced the same problem. I found that this only occurs when using static TOracleDataSet and TOraclePackage components. That is, when using packages "physically" placed on a data module or form. To avoid this problem, I dynamically create and then free TOraclePackages. Perry