Please Help 
Author Message
 Please Help

hi,

   Catrtidge Error : ORA-1223 : TNS : unable to connect to destination

   Database and WAS in different machine.

   Script :

   use Oraperl;
   use CGI;
   $query = new CGI;
   print "content-type:text/plain\n\n";
   #print $query->param('event_id');
   #print $query->param('img_align');

   &ora_version;
   print "Image Sucessfully inserted !!";
   $lda=&ora_login('mworks','happen','happen') || die $ora_errstr;
   #$lda=&ora_login('mworks','scott','tiger') || die $ora_errstr;
   #$csr=&ora_open($lda,'select * from event_img ') || die $ora_errstr;
   #$csr=&ora_open($lda,'insert into event_img values(:1,:2,:3)') || die

$ora_errstr;
   #$csr=&ora_open($lda,'update event_img set img_align=:2 where
event_id=:1') ||  die $ora_errstr;

#&ora_bind($csr,$query->param('event_id'),NULL,$query->param('img_align'));

  Kindly advise on this issue.

Thanks

--
With regards
Steven

Steven Koh, Internet Software Engineer,
Mediaworks, Pacific Internet Pte. Ltd.,
77 Science Park Drive, 04-09/12
Cintech III, Singapore Science Park,
Singapore 118256.

Tel: (65) 7711305;
Fax: (65) 8728523
www.mediaworks.com.sg, www.pacific.net.sg

--
With regards
Steven

Steven Koh, Internet Software Engineer,
Mediaworks, Pacific Internet Pte. Ltd.,
77 Science Park Drive, 04-09/12
Cintech III, Singapore Science Park,
Singapore 118256.

Tel: (65) 7711305;
Fax: (65) 8728523
www.mediaworks.com.sg, www.pacific.net.sg



Mon, 27 Aug 2001 03:00:00 GMT  
 Please Help
[posted & mailed]

: Catrtidge Error : ORA-1223 : TNS : unable to connect to destination

        This is an Oracle error, not a perl error.  The Oracle/database
        groups (comp.database.*) are likely going to be more helpful.  In
        any even, here is what oerr (which you should have a copy of) says
        about that particular message:

        $ oerr ORA 1223
        01223, 00000, "RESETLOGS must be specified to set a new database name"
        // *Cause:  The SET database name option was specified to CREATE CONTROLFILE,
        //          but RESETLOGS was not specified. The database name can only be
        //          changed when opening the database with RESETLOGS.
        // *Action: Either add the RESETLOGS option or drop the SET option to
        //          CREATE CONTROLFILE.

        HTH

--

BSD:  A psychoactive drug, popular in the 80s, probably developed at UC
Berkeley or thereabouts.  Similar in many ways to the prescription-only
medication called "System V", but infinitely more useful. (Or, at least,
more fun.)  The full chemical name is "Berkeley Standard Distribution".



Mon, 27 Aug 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Please, PLEASE, Help!! (probably simple)

2. Basic PERL Question - PLEASE PLEASE HELP

3. Please Please Help

4. Please please help a beginner...

5. PLEASE HELP - PLEASE READ

6. Please, please help!

7. Please, PLEASE, Help!! (probably simple)

8. Help...Help, install failed, please help!!

9. Help Help Please Help !

10. please, help me, help me, help me.....

11. Printing Arrays urgent help required!!!Please help!!!

12. need help!!! - please help

 

 
Powered by phpBB® Forum Software