Home » Infrastructure » Windows » Creating a new database / DBCA (10g)
Creating a new database / DBCA [message #511868] Wed, 15 June 2011 10:37 Go to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

when i am trying to create a new database in oracle 10 g in my local system when creating database error shows a numbe 146
no other error is showing
what must be the reason


[MERGED by LF]

[Updated on: Thu, 16 June 2011 06:16] by Moderator

Report message to a moderator

Re: dbca [message #511869 is a reply to message #511868] Wed, 15 June 2011 10:41 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: dbca [message #511870 is a reply to message #511868] Wed, 15 June 2011 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the log it generated.

Regards
Michel
creating new database [message #511935 is a reply to message #511868] Thu, 16 June 2011 03:40 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

I am using i have installed oracle 10g in my pc my version os is windows xp pro
i already have a database, now i am creating a new database through dbca command databse control assistant is opening
after naming and givinga all the parameters finllly when i craeate a database a message screen is coming withou error
its showing only the number 178 in the creadatabase configuration assistant info screen

i have 4.5 gb freespace in my drive

help me creating a new database
Re: creating new database [message #511943 is a reply to message #511935] Thu, 16 June 2011 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you show us what you see?
Had you a look to dbca log file?

Regards
Michel
Re: creating new database [message #511948 is a reply to message #511943] Thu, 16 June 2011 04:29 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

DBCA ERROR SCREEN
Re: creating new database [message #511954 is a reply to message #511948] Thu, 16 June 2011 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Behind the screen with the number there is a screen giving you the log file, have a look at it.

Regards
Michel
Re: creating new database [message #511960 is a reply to message #511954] Thu, 16 June 2011 05:32 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

this is the file i saw in that folder in the name of :emca_2011-06-16_01-01-24-PM
the content is as follows


Jun 16, 2011 11:48:11 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to c:\oracle\product\10.2.0\db_1\oui
Jun 16, 2011 11:48:11 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to c:\oracle\product\10.2.0\db_1\oui
Jun 16, 2011 11:48:12 AM oracle.sysman.emcp.util.OUIInventoryUtil isValidOH
CONFIG: Invalid oracleHome: e:\oracle\ora90
Jun 16, 2011 11:48:12 AM oracle.sysman.emcp.util.OUIInventoryUtil isValidOH
CONFIG: Invalid oracleHome: e:\oraclient
Jun 16, 2011 11:48:12 AM oracle.sysman.emcp.util.OUIInventoryUtil isValidOH
CONFIG: Invalid oracleHome: E:\oracle\BIToolsHome_2
Jun 16, 2011 11:48:12 AM oracle.sysman.emcp.util.CentralAgentUtil getCentralAgentHomeAndURL
CONFIG: Central Agent home and URL: {}
Re: creating new database [message #511964 is a reply to message #511960] Thu, 16 June 2011 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems you didn't give a correct Oracle home.

Regards
Michel
Re: creating new database [message #511966 is a reply to message #511964] Thu, 16 June 2011 05:54 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

i have installed oracle client and bitools in the e:\ drive

how to set the oracle_home default
Re: creating new database [message #511977 is a reply to message #511966] Thu, 16 June 2011 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot create a database with Oracle client, you must have an Oracle server install.

Regards
Michel
Re: creating new database [message #511987 is a reply to message #511977] Thu, 16 June 2011 07:39 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

I HAVE INSATALLED ORACLE 10G DATABSE INTHE C DRIVE
BEFORE INSTALLING 10G I ALREADY HAD INSATALLED CLIENT , FORMS 6I AND BI TOOL IN D DRIVE
MAY BE THAT IS HAVING A DEFAULT ORACLE HOME ,
I DONT UNDERSTAD THE LOG FILE ERROR because SAME ERROR IS SHOWING IN MY EXISTING DATABSE LOG FILE BUT IT WAS CREATED SUCCESSFULLY.







Re: creating new database [message #511995 is a reply to message #511987] Thu, 16 June 2011 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't answer to people that yell against me.
Please read OraFAQ Forum Guide.

In addition, YOU have the information, WE have only what you post, do you think we can diagnose something with what you posted?

Regards
Michel
Re: creating new database [message #512005 is a reply to message #511995] Thu, 16 June 2011 09:23 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

hey,

If you dont want to reply just ignore, i thought i was strange error if somebody faced the same they would give appropriate answer.
I don't expect stupid reply like this.


Re: creating new database [message #512010 is a reply to message #512005] Thu, 16 June 2011 10:20 Go to previous message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think that insulting those that trying to help will bring you more answers.
Take you are borderline.
Once again, Please read OraFAQ Forum Guide.

Regards
Michel


Previous Topic: ora-12546:tns:permission denied
Next Topic: upgrading
Goto Forum:
  


Current Time: Fri May 07 11:22:22 CDT 2021