DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: connect to local database

  1. #1
    Join Date
    Oct 2000
    Posts
    32
    Hey.

    I have a database and all developer tools on my local pc. Using windows2000 and oracle8i.

    I imported a full db. I have existing reports and forms that I would like to make changes to...

    I cannot connect to my local db from the report builder or forms builder. I get error: ORA: TNS: cannot connect to service name

    Anyway, I have tried to alter the tnsnames.ora file...listener.ora file.

    I need help trying to connect. It is ALL LOCAL.

    Any suggestions?

    Thanks,
    Rara.

  2. #2
    Join Date
    Jul 2000
    Posts
    50
    Can you post your tnsnames.ora and listener.ora files. I think the files are not configured properly.

    abhijit

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Before you get into forms & reports, try to connect via sqlplus. If you can not connect via sqlplus, you networking is messed up.
    Jeff Hunter

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    i have the same problem, and i can in sql
    but not in forms builder

  5. #5
    Join Date
    Oct 2000
    Posts
    33
    I had the same and checked metalink : As developer 6 does not support multiple homes, it has to be installed before the 816 database software.

    If you already created the database abd do not want to do that again, shut down th edatabase and make a backup of all datafiles, controlfile etc. Remove all oracle software, developer and rdbs , delete the oracle registry keys and the oracle services and reinstall developer. Afterwards reinstall 816 and recreate the service for the database (oradim). Copy back the datafiles etc and you will be able to start up the database.

    Good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width