Re: SQLPlus Hangs

raghu wrote:
When I enter the credentials in SQL Plus, it hangs. This happens both
in the server machine (Oracle 10.2.0) and the clients. But I am able
to login using the command prompt in the server. Tnsping works
correctly. Nothing is logged in the alert log for the login attempt.
Any ideas?


tnsping only checks for the listener - not whether it can connect.

Starting up ORACLE RDBMS Version: 10.2.0.2.0.
System parameters with non-default values:

sga_target = 12884901888

That would be 12GB?!? On Windows?
Given the fact you state you can connect from the
command line on the machine (how?!?), it should be
working - just frowning eyebrows here...

db_block_size = 16384
__db_cache_size = 11140071424

pga_aggregate_target = 1707081728
ditto


Wed Dec 26 11:58:39 2007
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)
(HOST=BRNORA62-vip)(PORT=1521))'

Does that say anything? vip is Virtual IP, or what?
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
.

Relevant Pages

  • Re: Cant TNSPing XE database
    ... the command prompt session I was running at the time and I don't know ... So now the important environment variables are: ... What I do see is that your TNSNAMES is not used (or at least, ... If it was, tnsping would say so: ...
    (comp.databases.oracle.server)
  • Re: Cant TNSPing XE database
    ... the command prompt session I was running at the time and I don't know ... So now the important environment variables are: ... What I do see is that your TNSNAMES is not used (or at least, ... If it was, tnsping would say so: ...
    (comp.databases.oracle.server)
  • Re: Dropped Mapped Connections....
    ... >>>login with using the exact same login and it never looses the mapped ... >> mapped resource, it was because I lost the actual network connection, ... >will appear but if from a command prompt I type "S" it will not find the ...
    (microsoft.public.windowsxp.general)
  • Re: Login Process
    ... preset the account/password by running this command ... from a Command Prompt: ... This will not work since items in the startup folders are run after login ... The problem is that I am not sure where to place my script. ...
    (microsoft.public.windowsxp.general)
  • Re: Login Process
    ... from a Command Prompt: ... If the account is variable then a registry hack invoked ... This will not work since items in the startup folders are run after login ... I am trying to "write" a script to login automatically on a WS at ...
    (microsoft.public.windowsxp.general)
Loading