-
Do the following on the server...
1. login into insa database
select * from v$database;
select * from v$instance;
2. login into insb database
select * from v$database;
select * from v$instance;
Paste the result of the above here.
HTHU.
-
[oracle@ciberdb oracle]$ env | grep ORACLE_SID
ORACLE_SID=insa
[oracle@ciberdb oracle]$ sqlplus system/ora987
SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 24 03:43:42 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> select * from v$database;
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE
--------- ----------- --------- ----------
2935114683 INSA 17-APR-03 1 17-APR-03
0 NOARCHIVELOG 344217
343372 CURRENT 17-APR-03 29883 344217
23-APR-03 NOT ALLOWED 17-APR-03 READ WRITE
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
---------- --- ----------------- ------------------
1 insa
mydb
8.1.6.1.0 23-APR-03 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE
[oracle@ciberdb oracle]$ ORACLE_SID=insb;export ORACLE_SID
[oracle@ciberdb oracle]$ env | grep ORACLE_SID
ORACLE_SID=insb
[oracle@ciberdb oracle]$ sqlplus system/manager
SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 24 03:45:58 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> select * from v$database;
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE
--------- ----------- --------- ----------
1910859409 INSB 21-APR-03 1 21-APR-03
0 NOARCHIVELOG 191431
191086 CURRENT 21-APR-03 7012 191613
22-APR-03 NOT ALLOWED 21-APR-03 READ WRITE
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
---------- --- ----------------- ------------------
1 insb
mydb
8.1.6.1.0 22-APR-03 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE
-
Ya, that looks OK.
Well, one more thing, create a tnsnames.ora on the server and connect to both databases using the tnsnames.ora on the server.
sqlplus system/ora987@insa
sqlplus system/manager@insb
If you succeed, copy this tnsnames.ora to the client and check from there.
HTH.
-
i tried by creating the tnsnames.ora at server - Its not working properly - Giving the problem.
-
Hello,
Did you tried by restarting the Listener? You can reload the Listener.
Give listener stats and check whether there are any service handlers for your databases.
Thanks,
________________
ShanDJ
-
Originally posted by Sekhar
i tried by creating the tnsnames.ora at server - Its not working properly - Giving the problem.
You mean, connecting to the databases at the server using tnsnames.ora is not working?
Post the errors you are getting at the server when you use tnsnames.ora. What problem are you getting?
HTHU
-
[oracle@ciberdb admin]$ sqlplus system/passwordA@INSA
SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 24 08:26:39 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
But the Same is connecting if I am giving
sqlplus system/passwordB@INSB - But Connecting to instance B.
BTB, I tried all the options with listener ( restarting, reloading)
The listener status is
INSA has 1 service handler(s)
INSA has 1 service handler(s)
INSB has 1 service handler(s)
INSB has 1 service handler(s)
If the same is showing 1 Service Handler only like ( for this I am stopping and again restarting the listener)
INSA has 1 service handler(s)
INSB has 1 service handler(s)
Then They are connecting properly.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|