Connection problem

[Filosofo]

Hello guys,
I have an Oracle RAC 9.2.0.3 and, after a client and server reboot, when I try to logon with user pluto trought sqlplus / I see this message:

ORA-01017: invalid username/password; logon denied

But before of the reboot this command function correctly.
Please help me

Filo

PS I don't Know Oracle

[Patrick Wallek]

Is the DB you are trying to connect to up?

# ps -ef | grep pmon

You should see a process for the DB. If the DB isn't started, then you, or someone, needs to start it.

[Massimo Bianchi]

And check the listener, if you are on the other node !

ps -ef | grep -i lsn

Massimo

[Steven E. Protter]

To start oracle

log on as the oracle application owner(check the binaries for ownership)

database

check /etc/oratab for instance name

echo $ORACLE_SID

change as needed

sqlplus internal

select * from v$instance;

# make sure ORACLE_SID is set right

startup

quit or exit

lsnrctrl startup

SEP

[Hein van den Heuvel]

This is (IMHO) clearly an operational/usage question in your production environment.
We can all poke here at the problem with various more or less clever OS and Oracle questions and suggestions but in the end the solution will have to come from your own production environment. So just got there now?!
Please contact you own operational folks (hopefully that is not you!).

Oracle RAC has the potential and intend to handle individual server reboots completely transparently. Please question ypur local staff why this is not happening. Maybe some consultancy is in order, maybe it was a bad-luck glitch.

Regards,
Hein.

[Filosofo]

Thanks for helps,
I see the DataBase situation and I see that is Up an running like listener...infect if I try to execute sqlplus system/manager I log to DB.
Is possible that oracle user not exist?
What can I do to verify if the oracleuser exist?

Thanks

Filo

[Massimo Bianchi]

Hi,
there are some points:

- in oracle 9 the user "internal" no more exists

- to check if a particular user exists, use

sqlplus system/manager
select username from dba_users;

pay attention that using "/" you are using external authentication, so you must search for an entry like ops$

- in case, it's better to specify the oracle sid you are attempting to login into

sqlplus /@

Massimo

[Massimo Bianchi]

last and least

"This member has assigned points to 42 of 267 responses to his/her questions"

Since you like ITRC forum and its help, it would be a good thing to attain to its etiquette and assign some points. Not to me, but in general :)

Massimo

[Filosofo]

This is tha output of command:
select username from dba_users;
SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
WMSYS

SQL>


I think that tha user not exist....
What can I do to create?

Massimo, is true that you said about the points assigned....but when I write on the forum, I am in a " sea of disagreeableness " and I think to solve my problem quickly....But from Now I TRY to assigned point for the helps...
Excuse me for my INCORRECT conduct.

Thanks

Filosofo

[Massimo Bianchi]

Hi,

i need to know the exact O.S. user you are using, and the owner of the oracle executable.

The "/" login without password is only allowed for the oracle of the $ORACLE_HOME/bin/oracle executable.

From the output of your query i do not see any external user.
Are you connected with that user ?

Massimo