| oracle 9i startup problem [message #245549] |
Mon, 18 June 2007 02:06  |
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
|
Member |
|
|
Hi friends.
I want to use export to be run from the form 6i.
For that i have installed oracle 9i.
But when i am starting sql plus.It asks me three fields
which are,
1)user name (which i enter scott)
2)password (tiger)
3)Host sting (???)
after entering the DB name it gives error.service name could not resolved.
And second problem is that,
when running EXP command from command prompt.
It again asks for user name , password & oracle 9i startup password.
Plz help me to start 9i.
errors are :
EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully
|
|
|
|
| Re: oracle 9i startup problem [message #245732 is a reply to message #245549] |
Mon, 18 June 2007 12:25  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Is scott account is unlock??
As a user sys connect and startup your database like
SQLPLUS> '/ as sysdba'
then unlock the user account by command
SQL>alter user scott identified by tiger account unlock;
then try to exp and imp;
What OS you working on??
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
