Connection problem

[Filosofo]

No I'm not Connect....end the name of the OS user is like the name of the oracle user...

Thanks

Filo

[Massimo Bianchi]

are you able to connect with

sqlplus /@SID

?


try from both server.

[Massimo Bianchi]

Well,
if you want to create that user, i will give you the instructions, but it's more a dba work.


sqlplus system/manager


create user ops$ identified by default tablespace temporary tablespace ;
grant connect, resource to ops$;
commit;


But, it's a dba-question....Once this is resolved, there may be other issues.

Massimo

[Filosofo]

Hi,
I try to connect like oracle user on server db and I execute sqlplus /@ORACLESID...but I see the some message

ORA-01017.....

Thanks

Filo

[Massimo Bianchi]

Was there any change in the $ORACLE_HOME/dbs/initSID.ora file ?

are you sure that the instance is opened read/write ? check with

sqlplus system/manager

select * from v$instance;
select * from v$database;


and from the alert_SID.log .

Massimo

[Filosofo]

I see from the commands:

select * from v$istance;
select * from v$istance
*
ERROR at line 1:
ORA-00942: table or view does not exist


and

-------------------- -------- ----------- ---------------- ------------------
SWITCHOVER_STATUS DATAGUAR GUARD_S SUP SUP SUP FOR
------------------ -------- ------- --- --- --- ---
23-JUL-03 NOT ALLOWED 18-JUL-03 READ WRITE MAXIMUM PERFORMANCE

DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE


Thanks

Filo

[Massimo Bianchi]

Hi,
the instance is open properly.


I did a misstype:

select * from v$instance;

(with the _n_ )

You said Oracle RAC. It's on one or two nodes ?
if two nodes, do one works well or both fail ?

You said client/server reboot. What is the client application that will use oracle ?

Massimo

[Filosofo]

RAC on two nodes, and on the nodes the situation is ugual.
The output is :

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 GBCREG1
h3rmh129
9.2.0.3.0 23-JUL-03 OPEN YES 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL


SQL>

and on tha client there is oracle 9.2

Thanks

Filo

[Yogeeraj_1]

hi,

is the problem solved now?

To add to the excellent replies by Massimo,

note that on the client, you must ensure that the tnsname entries are correct.

can you also post the output of:

show parameter os

(you may connect as / as sysdba to get that)


cheers
Yogeeraj