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!
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: 10707
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..*/
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.
Previous Topic: ora-00900
Next Topic: Table Creation
Goto Forum:
  


Current Time: Thu Mar 28 06:09:54 CDT 2024