ORA-03114 : not connected to ORACLE

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

Check for environment.

ORACLE_SID
ORACLE_HOME
LD_LIBRARY_PATH
Oratab entry

and also

Networking entries
listener.ora
tnsnames.ora etc.

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 ?

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]

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.

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

I had a similiar problem and I unstalled/reinstalled and it worked.

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