Home » RDBMS Server » Server Administration » confusing
confusing [message #50366] Wed, 13 March 2002 05:48 Go to next message
krb
Messages: 25
Registered: March 2002
Junior Member
hi,
I am having two servers :
FCPL having schema -- Training,
FCBACK having schema -- Conversion

On the client m/c the TNS name seem OK but quite often I face this strange problem;

SQL> conn conversion/conversion@fcpl.world
Connected.
SQL> sho user
USER is "CONVERSION"
SQL> select name from v$database;

NAME
---------
FCBACK

1 row selected.

SQL> conn converion/conversion@fcback.world
ERROR:
ORA-01017: nieprawidłowa nazwa użytkownika/hasło; odmowa rejestracji

Warning: You are no longer connected to ORACLE.
SQL> conn conversion/conversion@fcback.world
Connected.
SQL> sho user
USER is "CONVERSION"
SQL> select name from v$database;

NAME
---------
FCBACK

1 row selected.

SQL> conn conversion/conversion@fcpl.world
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL>

--what might be the reason for this type of error.. Is anything missing in the client that I have to add

regards
KRB
Re: confusing [message #50368 is a reply to message #50366] Wed, 13 March 2002 06:06 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Uhh! let's see your tnsnames.ora file ...
Re: confusing [message #50370 is a reply to message #50366] Wed, 13 March 2002 06:24 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Sorry if I sounded harsh on my last message. Your tnsnames looks ok. Why two ports? Are you using a host file. Is it correct and not pointing to two IP's. When you do a ping -a to each server do you get the right servers?
Re: confusing [message #50376 is a reply to message #50366] Wed, 13 March 2002 06:45 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
You tnsnames.ora looks fine.

Save a copy of your your tnsnames.ora file and try these.

1. I think COMMUNITY=... is really not needed. I am seeing this for the first time.
2. Is this the same 3 GB db ? Why do you need 2 listener ports (1521 and 1526) ? Try with the standard 1521 ONLY.
3. try 'tnsping fcpl.world' & 'tnsping fcback.world'
Re: to sanjay [message #50379 is a reply to message #50376] Wed, 13 March 2002 06:53 Go to previous messageGo to next message
krb
Messages: 25
Registered: March 2002
Junior Member
It is a different database..
Both tns ping working properly..
I will change the Ports to 1521 .

This problem is not always.. It happens once in a while.. ?????
Re: confusing [message #50403 is a reply to message #50376] Wed, 13 March 2002 23:54 Go to previous message
krb
Messages: 25
Registered: March 2002
Junior Member
1. I think community shouldnt make any difference to this problem
2. This is not the same as 3GB database it is another
I will remove one of the ports(1526).. but I dont think Net8 will refer only to the later
3.Tns ping returns me correctly

PS: this problem is recurrsive but occurs occassionally
Previous Topic: Re: sql and pl/sql
Next Topic: remote_login_passwordfile=shared
Goto Forum:
  


Current Time: Tue Dec 24 22:31:22 CST 2024