Oracle - Error in OCIDateSysDate

Re: Error in OCIDateSysDate

From:

Date:

Time:

Hi

First of all do tnsping "YOUR DB NAME". If the response time is
specified your Database is running.

If no, search for tnsnames.ora file on your machine. [It would
usually be in the folder "C:\ora90\network\admin" (if its for Oracle
9i database)].
Open it and add the entry for your database. This is a sample (if its
oracle 9i that you are using). Add this entry to the tnsnames.ora
file, replacing the NDL4 with your DB-Name and HOST = twdpc033 with
HOST = IPADDRESS of the machine hosting the database.

NDL4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = twdpc033)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = NDL4)
)
)

Hope this helps you.

Cheers

Sriram

Muzammil Hassan wrote:

> Hi Robin,
>
> Thanks for ur Response . Actually I m totally Unaware
> with Oracle.So that I dont know how to set the TNSNAME
> ora file.
> When I open SQL Editor. The screen comes to enter USER
> ID, PASSWORD, AND Host name. So wat I have to enter
> into the HOST NAME Text box.
>
> And how to set the file tnsname.ora
>
> Please help me
>
> Thanks
>
> --- Robin Quasebarth <robinq@www.digitalpoint.com>
> wrote:
>
> >
> >
> > Is your tnsnames.ora file set up correctly?
> >
> > ----------------------------
> > On Sep 15, 2004, at 12:55 AM, Muzammil Hassan wrote:
> >
> > Hi all
> >
> > I have installed D2K. When I m going ot the Form
> > editer and try to connect database. Its giving an
> > error as "ORA-12545 TNS Name : Lookup failure
> >
> > Please help me
> >
> > Regards
> > muzzu
> >
> > --- Jyoti.Rath@iflexsolutions.com wrote:
> >
> > Hi
> >
> >
> >
> > We have used OCIDateSysDate method to get Current
> > system date and time
> > of client.
> >
> > But it is showing different date and time in
> > different call.
> >
> > For example :
> >
> >
> >
> > First time invocation : 24 the August 2004
> >
> > Second time onwards it is showing 12 August 2004.
> >
> >
> >
> > Could it be related any server settings or it is a
> > problem with Oracle
> > OCI date.
> >
> >
> >
> > Regards
> >
> > JyotiR
> >
> >
> >
> >
> >
> > DISCLAIMER:
> > This message contains privileged and confidential
> > information and is intended only for the individual
> > named.If you are not the intended recipient you
> > should not disseminate,distribute,store,print, copy
> > or deliver this message.Please notify the sender
> > immediately by e-mail if you have received this
> > e-mail by mistake and delete this e-mail from your
> > system.E-mail transmission cannot be guaranteed to
> > be secure or error-free as information could be
> > intercepted,corrupted,lost,destroyed,arrive late or
> > incomplete or contain viruses.The sender therefore
> > does not accept liability for any errors or
> > omissions in the contents of this message which
> > arise as a result of e-mail transmission. If
> > verification is required please request a hard-copy
> > version.
> >
> >
> >
> >
> ----------------------------------------------------------
> > To subscribe, unsubscribe or to search list archive
> > please visit
> > http://www.digitalpoint.com/lists/oracle.html
> >
> ----------------------------------------------------------
> >
>
>
> =====
> Muzzu
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
> http://promotions.yahoo.com/new_mail
>
> ----------------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.digitalpoint.com/lists/oracle.html
> ----------------------------------------------------------

----------------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.digitalpoint.com/lists/oracle.html
----------------------------------------------------------

Sales:
888/4-DPOINT

Support:
858/452-3696