OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » confusing

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

confusing [message #50366]

Wed, 13 March 2002 05:48

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

Report message to a moderator

Re: confusing [message #50368 is a reply to message #50366]

Wed, 13 March 2002 06:06

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Uhh! let's see your tnsnames.ora file ...

Report message to a moderator

Re: confusing [message #50370 is a reply to message #50366]

Wed, 13 March 2002 06:24

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?

Report message to a moderator

Re: confusing [message #50376 is a reply to message #50366]

Wed, 13 March 2002 06:45

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'

Report message to a moderator

Re: to sanjay [message #50379 is a reply to message #50376]

Wed, 13 March 2002 06:53

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.. ?????

Report message to a moderator

Re: confusing [message #50403 is a reply to message #50376]

Wed, 13 March 2002 23:54

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

Report message to a moderator

Previous Topic:	Re: sql and pl/sql
Next Topic:	remote_login_passwordfile=shared

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 04 02:44:17 CDT 2026