Home » RDBMS Server » Enterprise Manager » Logon to oracle
Logon to oracle [message #67778] Sun, 10 March 2002 19:19 Go to next message
Ken
Messages: 50
Registered: April 1998
Member
Hello,
Please help me. I try to logon to oracle by sql in Dos command. After logon to oracle by command "svrmgrl", I type " connect internal/oracle". It failed and error message like that "ORA-12203: TNS: Unable to connect to distincation". Do you know why?
If I got the service name "AVAP", how can I use "connect command".
Thanks!

Report message to a moderator

Re: Logon to oracle [message #67779 is a reply to message #67778] Mon, 11 March 2002 11:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
pls check the oracle is started.( from the control panel)
then check the listner.
then go to dos prompt
svrmgrl> connect internal

/* if the internal password is set ,,it will prompt for it..*/

Report message to a moderator

Re: Logon to oracle [message #67788 is a reply to message #67778] Fri, 15 March 2002 19:32 Go to previous message
arun
Messages: 67
Registered: January 2000
Member
c:> set ORACLE_SID=AVAP
c:> svrmgrl
svrmgr> connect internal

and so on. Please remember to do a set ORACLE_SID=<YOUR SID>. You can check if the ORACLE_SID is set correctly or not by typing:
c:> echo %ORACLE_SID%
AVAP
c:>

Hope this helps.

Report message to a moderator

Previous Topic: ora-00900
Next Topic: Table Creation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 04 08:48:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.