Home » SQL & PL/SQL » Client Tools » oracle 9i startup problem
oracle 9i startup problem [message #245549] Mon, 18 June 2007 02:06 Go to next message
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 Go to previous messageGo to next message
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??
Re: oracle 9i startup problem [message #245893 is a reply to message #245732] Tue, 19 June 2007 03:11 Go to previous messageGo to next message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
I have win 98.
scott is not locked.
I dont know the problem
Re: oracle 9i startup problem [message #245896 is a reply to message #245549] Tue, 19 June 2007 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the database is local:
- Set your ORACLE_SID in your environment/registry .
- Don't put anything in "host string"

Regards
Michel

Re: oracle 9i startup problem [message #253009 is a reply to message #245549] Sat, 21 July 2007 08:06 Go to previous messageGo to next message
Mohannad
Messages: 47
Registered: January 2006
Location: palestine
Member

Dear Sir :
did u cheak that u start the database from the register or now ?make sure that u make it start ..wish then it work
Re: oracle 9i startup problem [message #253018 is a reply to message #245549] Sat, 21 July 2007 09:33 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Mohannad,
Why are you responding to a post that has been dormant for more than 1 month?
I doubt that OP will benefit from your advice after 30+ days.
Re: oracle 9i startup problem [message #253025 is a reply to message #253009] Sat, 21 July 2007 10:19 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition to Ana post, write in english, I don't understand what you wrote.

Regards
Michel
Previous Topic: How to remove blanks in this csv spools
Next Topic: Need Help
Goto Forum:
  


Current Time: Thu Dec 08 10:07:59 CST 2016

Total time taken to generate the page: 0.12917 seconds