OraFAQ Forum: Server Administration » Can't connect to Oracle db

Home » RDBMS Server » Server Administration » Can't connect to Oracle db - Help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't connect to Oracle db - Help [message #50010]

Sat, 23 February 2002 00:50

Hendrik
Messages: 6
Registered: February 2002

Junior Member

I have problem.
I installed Oracle 8i on Window 2000 Server.
Right now I create 2 database on Oracle (A & B)
The problem is, when I tried to logon using scott/tiger, it didn't go through.
what should I do? Should I put/type something on HOST field?

Thx
Raj

Report message to a moderator

Re: Can't connect to Oracle db - Help [message #50013 is a reply to message #50010]

Sat, 23 February 2002 03:08

Kassim Kasmani
Messages: 25
Registered: January 2002

Junior Member

Before you log into Server Manager, set the oracle sid of the db you wish to log into:

C:set oracle_sid=dbname

Hope this helps!

__________________________
Kassim Kasmani
Yahoo Messenger: kassim13

Report message to a moderator

Re: Can't connect to Oracle db - Help [message #50023 is a reply to message #50010]

Sun, 24 February 2002 15:15

Hendrik
Messages: 6
Registered: February 2002

Junior Member

But where should I go to type the command?
Thx

Report message to a moderator

Re: Can't connect to Oracle db - Help [message #50025 is a reply to message #50010]

Sun, 24 February 2002 17:25

Kassim Kasmani
Messages: 25
Registered: January 2002

Junior Member

From Start > Run: type in CMD and press enter.

That will bring you to a dos prompt. Something like c:winnt

Type: cd

type: set oracle_sid=dbname
type: svrmgrl

That will get you into server manager.

Hope this helps.

__________________________
Kassim Kasmani
Yahoo Messenger: kassim13

Report message to a moderator

Re: Can't connect to Oracle db - Help [message #50059 is a reply to message #50010]

Tue, 26 February 2002 11:53

kalpana
Messages: 6
Registered: February 2002

Junior Member

Hi
1. You can configure the connection Using Net8 Assistant.

2. You have look into your tnsnames.ora file which will be located in your admin folder.

Hope this helps you out

Kalpana

Report message to a moderator

Previous Topic:	Re: ORA-3113 error detected
Next Topic:	URGENT_multi - listeners

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 12:30:59 CST 2024