 9i: Data dictionary views does exists [message #136580] |
Thu, 08 September 2005 18:15  |
nimika
Messages: 2
Registered: September 2005
|
Junior Member |
|
|
Hi,
i m new in the DBA field. I installed 9i database on Windows XP on my laptop. Also created the database but i m not able to access any of the Data dictionary views.. returns with an error ORA-04043 object or view doesnt exists.
is there any problem with the installation of the 9i software?
please help me to get out of this. i cant proceed without it.
Thanks.
|
|
|
|
| Re: 9i: Data dictionary views does exists [message #136607 is a reply to message #136580] |
Fri, 09 September 2005 00:01  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| Quote: |
ORA-04043 object string does not exist
Cause: An object name was specified that was not recognized by the system. Following are possible causes:
An invalid name for a table, view, sequence, procedure, function, package, or package body was entered. Since the system could not recognize the invalid name, it responded with the message that the named object does not exist.
An attempt was made to rename an index or a cluster, or some other object that cannot be renamed.
Action: Check the spelling of the named object and rerun the code. (Valid names of tables, views, functions, etc. can be listed by querying the data dictionary.)
|
u can read this link also.
http://www.cryer.co.uk/brian/oracle/ORA04043.htm
did u create the datbase manually or using DBCA? ( if u created manually then did u run necessary scripts like catalog.sql )
Through which user did u login & try , i.e. is it SYS or any other user like SCOTT ?
check it out & post the problem with a excerpt from Oracle.
regards.,
tarun
|
|
|
|
| Re: 9i: Data dictionary views does exists [message #136608 is a reply to message #136580] |
Fri, 09 September 2005 00:03 |
oracledbanewbie
Messages: 6
Registered: August 2005
|
Junior Member |
|
|
Hi There,
I am also new to this field. Just for curiosity purposes, have you run the following scripts after opening the database?
1. As sysdba
?/rdbms/admin/catalog.sql
?/rdbms/admin/catproc.sql
Check for the location on this one
?/sqlplus/admin/catdbsyn.sql
2. As scott/tiger
?/demo/demobld.sql
These should get you started. Normally this error occurs when U have do not have proper previleges to access them or they are not existing in the schemas, they should. Any experts help appreciated. Thank you.
-Anand
|
|
|
|
| Re: 9i: Data dictionary views does exists [message #136661 is a reply to message #136580] |
Fri, 09 September 2005 07:51 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Others may be able to offer better advice, but in order to do so it will help if you can provide a copy and paste of your oracle session showing the user and the command you were doing along with the results. It could be a problem with the installation of dictionary, but need more info to know for sure.
Also, if you are brand new, I would suggest starting with version 10gR1 instead of 9iR2. Installation is quicker and easier, so is administration, lots of advantages really to going with the later version. And most of what you learn will be applicable to the lower 9i version should you be forced to work with it.
|
|
|
|
| Re: 9i: Data dictionary views does exists [message #136735 is a reply to message #136580] |
Fri, 09 September 2005 14:03 |
nimika
Messages: 2
Registered: September 2005
|
Junior Member |
|
|
hi there,
thanks for all of urs advice..
i logged in sysdba
i did run the scripts catalog.sql and catproc.sql..
while the catalog.sql scripts runs i cud see the same errors scolling again and again but finally it returns with successful creation.
i am not able to find any solution:( so the last option now is to reinstall and see if it works.
thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
