| Re: SQL*Plus: Error accessing package DBMS_APPLICATION_INFO [message #368053] |
Tue, 30 November 1999 10:23 |
vitabiz
Messages: 1
Registered: November 1999
|
Junior Member |
|
|
</H4><CENTER><IMG SRC="http://members.xoom.com/vitabiz/pics/relove12.jpg"></CENTER>
-
Do the following (for WinNT, I'm sorry):
AT THE COMMAND PROMPT:
- C:\set ORACLE_SID=your_db_name
- C:\svrmgr30
- svrmgr> CONNECT internal
- (Give the password)
- svrmgr> SHUTDOWN
- svrmgr> exit
- C:\restart
AT THE COMMAND PROMPT
- C:\set ORACLE_SID=your_db_name
- C:\svrmgr30
- svrmgr> CONNECT internal
- (Give the password)
- svrmgr> startup nomount
- Start the scripts to recreate you database and your tablespaces and restart the sql-files of Oracle. (in %ORAHOME%\rdbms80\admin\*.sql)
- Exit the dos prompt
- Stop the services that are running, and run Net8Assistant (Or edit you tnsnames.ora and listener.ora files manually)
Normally this should fix it.
(And since you just installed the db, it is no problem shutting it down, or restarting the sql-statements to generate your db and tablespaces.)
Greetings
Vita Biz
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
