Thanks Thanks:  0
Page 1 of 2 12 LastLast
Showing results 1 to 10 of 20

Thread: Step by step guide to install and connect Oracle 10g to Enterprise v6

  1. #1
    Senior Member Reputation: 690
    Join Date
    2008-08-05
    Posts
    472


    Default Step by step guide to install and connect Oracle 10g to Enterprise v6

    Here i am uploading step by step guide to install and connect Oracle 10g to Aircom Enterprise v6.
    it works for me.
    it should resolve most of the related issues everyone facing.
    Please verify the process and let me know if somewhere i am wrong.
    if you find it useful and it works for you too, dont forget the thanks button.

    BR

    David brayan
    Attached Files Attached Files

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    Senior Member Reputation: 690
    Join Date
    2008-08-05
    Posts
    472


    Default starting oracle service

    If somehow after doing all that,still you are unable to connect.
    goto command prompt and view if the service is running or not.

    command to view running services is
    net start

    command to start any service is
    net start {servicename} where servicename is the name of service to be started

    in my case it is
    net start oracleserviceranopt

    look at attached screenshots
    Attached Images Attached Images

  4. #3
    VIP Member Reputation: 54
    Join Date
    2007-10-10
    Posts
    155


    Default

    Quote Originally Posted by davidbrayan View Post
    Here i am uploading step by step guide to install and connect Oracle 10g to Aircom Enterprise v6.
    it works for me.
    it should resolve most of the related issues everyone facing.
    Please verify the process and let me know if somewhere i am wrong.
    if you find it useful and it works for you too, dont forget the thanks button.

    BR

    David brayan
    Hi D,

    Your document is passworded so that we could not open :P
    pls share your password

    cheers

    NV

  5. #4
    Member Reputation: 417
    Join Date
    2008-06-09
    Posts
    536


    Default

    Quote Originally Posted by nova_debussy View Post
    Hi D,

    Your document is passworded so that we could not open :P
    pls share your password

    cheers

    NV
    The password is david.
    BR,

    -freqzt-

  6. #5
    Member Reputation: 417
    Join Date
    2008-06-09
    Posts
    536


    Default

    Quote Originally Posted by davidbrayan View Post
    If somehow after doing all that,still you are unable to connect.
    goto command prompt and view if the service is running or not.

    command to view running services is
    net start

    command to start any service is
    net start {servicename} where servicename is the name of service to be started

    in my case it is
    net start oracleserviceranopt

    look at attached screenshots
    Hi david, I have a problem. The servicename oracleserviceranopt is already running, but I still can't connect to the database. Can you help me?
    BR,

    -freqzt-

  7. #6
    Senior Member Reputation: 690
    Join Date
    2008-08-05
    Posts
    472


    Default

    go through the guide i posted and ensure you did all the steps.
    tell me the content of message log,what it says with the message unable to connect.
    check your listener configuration and one more thing i forgot
    goto
    C:\WINDOWS\system32\drivers\etc

    edit the file hosts using notepad

    insert this string into it

    10.10.10.10 localhost

    where localhost is your full computer name,localhost may also work.
    save it and try again

  8. #7
    Member Reputation: 417
    Join Date
    2008-06-09
    Posts
    536


    Default

    Quote Originally Posted by davidbrayan View Post
    go through the guide i posted and ensure you did all the steps.
    tell me the content of message log,what it says with the message unable to connect.
    check your listener configuration and one more thing i forgot
    goto
    C:\WINDOWS\system32\drivers\etc

    edit the file hosts using notepad

    insert this string into it

    10.10.10.10 localhost

    where localhost is your full computer name,localhost may also work.
    save it and try again
    I've edited the file hosts but I still get the error message like this:
    Attached Images Attached Images
    BR,

    -freqzt-

  9. #8
    Senior Member Reputation: 490
    Join Date
    2008-08-14
    Posts
    2,940


    Default

    I couldn't ping 10.10.10.10

    while I edit the host file

  10. #9
    Senior Member Reputation: 690
    Join Date
    2008-08-05
    Posts
    472


    Default

    Quote Originally Posted by freqzt View Post
    I've edited the file hosts but I still get the error message like this:

    Check your Tnsnames.ora file

    mine is like this

    # tnsnames.ora Network Configuration File: D:\oracle\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    RANOPT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RANOPT)
    )
    )
    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

  11. #10
    Member Reputation: 417
    Join Date
    2008-06-09
    Posts
    536


    Default

    Quote Originally Posted by davidbrayan View Post
    Check your Tnsnames.ora file

    mine is like this

    # tnsnames.ora Network Configuration File: D:\oracle\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    RANOPT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RANOPT)
    )
    )
    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )
    I've checked My Tnsnames.ora. It is same with your Tnsnames.ora. I don't know about this. Please help me.
    BR,

    -freqzt-

Tags for this Thread

Bookmarks

Bookmarks

Posting Rules

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