ORA-03114 : not connected to ORACLE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-03114 : not connected to ORACLE

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    I was trying to create a database during installing Oracle8i EE (8.1.7) on Solaris 8. It failed when the database creation progress went to initialize database (Creating and starting Oracle instance, copying database files are OK. I used the typical option to create database.) I got a error message:

    ORA-03114 : not connected to ORACLE

    After installation, I tried to use dbassist to create a database and got the same result. So now there is no any database existing in my Oracle 8i.

    Thanks for any help
    zm

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Check for environment.

    ORACLE_SID
    ORACLE_HOME
    LD_LIBRARY_PATH
    Oratab entry

    and also

    Networking entries
    listener.ora
    tnsnames.ora etc.
    Reddy,Sam

  3. #3
    Join Date
    Mar 2001
    Posts
    109
    I found the entry of database I tried to create does not exist in tnsnames.ora that should be generated by Oracle configuration tools. But what should I do now ?
    zm

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    modify your tnsnames.ora and make sure that the entries are ther on the listener and then start the listener and then try connecting to the database and see.

    Here is a link that would help you

    http://technet.oracle.com/doc/window...apc.htm#442384


    Sam

    [Edited by sambavan on 04-27-2001 at 02:18 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2001
    Posts
    109
    Thanks for your kind help, Sam.

    But my problem is that the database never got created, that is way there was no entry in the configuration files. I also checked my oradata directory and it is empty.
    zm

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You can now create the database using the dbassist and it would help you to create your database. Before running the dbassist, I would make sure that the environment variables had been set correctly. THen would proceed with the database creation.


    Try it and let us know if you have any problems. BTW, the dbassist would also detect any database instances on the system, if they had already been created. You can use the delete option to check and delete the instance, if you find it to exist, before creating the instance of the same name again.


    Good luck,
    Sam

    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I had a similiar problem and I unstalled/reinstalled and it worked.

  8. #8
    Join Date
    Mar 2001
    Posts
    109
    I uninstalled/re_installed, but still got the same problem. I set the database name as "sugar". The file ORACLE_BASE/admin/sugar/create/seed.log shows:

    ORA-03113: end-of-file on communication channel
    create controlfile reuse set database "sugar"
    *
    ORA-03114: not connected to ORACLE
    alter database "sugar" open resetlogs
    *
    ORA-03114: not connected to ORACLE
    alter system enable restricted session
    *
    ORA-03114: not connected to ORACLE
    alter database "sugar" character set US7ASCII
    *
    ORA-03114: not connected to ORACLE
    alter database "sugar" national character set US7ASCII
    *
    ORA-03114: not connected to ORACLE
    alter database rename global_name to "sugar.SalesCentrix.com"
    *
    ORA-03114: not connected to ORACLE
    ORA-01012: not logged on



    zm

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