Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2007
    Posts
    7

    Unhappy Unanswered: Developer Suite 10g

    Please Help!

    How do I run Oracle Developer Suite 10g with Oracle Database 10g Express Edition. I was told you had to amend a file in the directory folder of DevSuiteHome.

    Please can you help me make this work.

    Thank You!

    I look forward to your reply.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Basically, Developer Suite must be able to connect to the database. It will do so if/when you set the TNSNAMES.ORA file. It can be found in \network\admin directory (of every Oracle Home).

    I suspect that you were told to take this file from Express Edition's \network\admin directory and copy it into the Developer Suite's \network\admin directory.

    You might try to do so - there's a chance that everything will work fine.

    Or (if on MS Windows), run Start - Programs - Oracle Dev. Suite - Configuration and Migration Tools - Net Configuration Assistant which should help you.

  3. #3
    Join Date
    Jun 2007
    Posts
    7
    How do i set the TSNAMES.ORA file. what do I have to key in or what do I have to amend?

    Thank you for your previous reply and I look forward to your next reply?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Did you start the Net Configuration Assistant I suggested? It should create an alias to Oracle 10g Express Edition.

    If the database is installed on your computer (local host), TNSNAMES.ORA entry might look like this:
    Code:
    # Oracle 10g Express Edition on localhost
    
    XE =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = XE)
        )
      )

  5. #5
    Join Date
    Jun 2007
    Posts
    7

    Talking

    Thank You Very Much Littlefoot!!

    It's Sorted!


  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Great! Enjoy in Oracle!

  7. #7
    Join Date
    Jun 2007
    Posts
    7
    1 Last Question?

    Where is the database saved when finished?

    I know this is a silly question and it is my fault I should have attended class!

    Look forward to your reply.

    Thanks

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Some, many, most folks would RTFM to find answers to BASIC questions.
    Please consider doing likewise.
    http://www.oracle.com/technology/doc.../devsuite.html
    Last edited by anacedent; 06-28-07 at 19:55.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jun 2007
    Posts
    7
    what i mean 2 say is how do i save it to my own personal folder?

  10. #10
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by 215HAN
    Where is the database saved when finished?
    What do you call "a finished database"? If you are talking about data files (and regarding the fact you use XE), they might be somewhere in \oraclexe\oradata\xe directory.

Posting Permissions

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