| urgent:cannot see those tables [message #138469] |
Thu, 22 September 2005 03:22  |
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
|
Senior Member |
|
|
hii
i have a big problem that our applications arenot running
and when i run the sql i can connect with no problems
but when i make that command
desc tab
the sql hang and close
also the tables of of all_objects,user_objects
although our tables are found and work from sql with no problems
what can i do
plz reply immediatly
thx
also i want to add something
that after these problem happened
i run the files of catalog.sql & catproc.sql & utlrp.sql
from the sql
is those made the problem
[Updated on: Thu, 22 September 2005 03:30] Report message to a moderator |
|
|
|
| Re: urgent:cannot see those tables [message #138471 is a reply to message #138469] |
Thu, 22 September 2005 03:37  |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
Can you post the last few entries in your alert log to help solve the problem.
Also when you ran catalog.sql and catproc.sql did you do this as user sys.. connect / as sysdba or connect sys/password as sysdba?
Cheers
Allie
|
|
|
|
|
|
| Re: urgent:cannot see those tables [message #138476 is a reply to message #138472] |
Thu, 22 September 2005 03:50 |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
Yes they must be run as sysdba, it creates views under the sys schema, that might be where your problem lies..
If you open each of the files that you ran, they give you instructions on which user must be logged.
I'd try that first, if not my second query was for you to post us some of the latter entries in your ALERTsid.ora file.
Sorry if you already know this, but you can find this file in the BACKGROUND_DUMP_DEST.
show parameter BACKGROUND_DUMP;
A file is created in this directory that holds a chronological list of all major events that occur on your database, including startup/shutdown and importantly errors..
If you copy and paste the entries from this file into the thread then it might help us analyze the problem, (make sure you don't give us the whole file though.. only the entries that cover the time period when the problem occurred)
I would try re-running catalog and catproc as sys first though.
Allie
|
|
|
|
|
|
|
|
|
|
|
|
| Re: urgent:cannot see those tables [message #138486 is a reply to message #138484] |
Thu, 22 September 2005 04:32 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I think your problem that you had specified in your first post is related to application because you were able to connect with the database throug SQL without any problem ...
Please check the connect string in the application code as well as the user and password in it.
Regards
Always Friend Sunilkumar
|
|
|
|
|
|
|
|
|
|
| Re: urgent:cannot see those tables [message #138496 is a reply to message #138495] |
Thu, 22 September 2005 05:09 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
Uh-HUH.... can you think of any more information for us that might be useful??
Whenever you post a question, you MUST give as much info as possible. Without lots of information, people cannot assess what the problem is. One of the most frustrating things about this is that there can often be 3, 4 10, 20 more posts just trying to find out what the problem actually is, before any resolution can be arrived at.
Give more details. without them no-one can do anything other than guess. Most people are too busy for that.
Jim
|
|
|
|
|
|
| Re: urgent:cannot see those tables [message #138506 is a reply to message #138503] |
Thu, 22 September 2005 05:32 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
Uh-HUH.... can you think of any more information for us that might be useful??
Whenever you post a question, you MUST give as much info as possible. Without lots of information, people cannot assess what the problem is. One of the most frustrating things about this is that there can often be 3, 4 10, 20 more posts just trying to find out what the problem actually is, before any resolution can be arrived at.
Give more details. without them no-one can do anything other than guess. Most people are too busy for that.
Jim
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
