OraFAQ Forum: Backup & Recovery » Catalog database on Windows Server and target Database on Linux??

Home » RDBMS Server » Backup & Recovery » Catalog database on Windows Server and target Database on Linux??

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

Catalog database on Windows Server and target Database on Linux?? [message #233869]

Fri, 27 April 2007 17:09

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Hi I'm a Jr. Oracle DBA,

I am required to setup a recovery catalog for our development database. The only thing that I don't understand is that the development database (Oracle10g R2) is running on RHEL 4 and the server that I have been provided to create the catalog database on, is on Windows 2003 Server. How do I do that? Don't they both have to be the same platforms? How is the catalog going to be updated when it is on a windows machine and the target database is on a Linux machine? How do I link the two?

Thank you

[Updated on: Fri, 27 April 2007 17:18]

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #233881 is a reply to message #233869]

Fri, 27 April 2007 19:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Don't they both have to be the same platforms?
Not essentially.
>> How do I link the two?
It is just a TNSentry(tnsnames.ora)
Recovery catalog databse is just used to store information about the backup. The acutal backups would be stored in the locations you specify. During every backup/restore/duplication scenario, your RMAN session will query the catalog database to get necessary information.
More about it in Oracle documentation Smile

Smile

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234002 is a reply to message #233881]

Sat, 28 April 2007 20:52

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Ok. But the Oracle 10g software must be installed on this seperate server (Windows) right? Or else you can't create the catalog database on the Windows server.

Then I would just add the TNS entry on the target database (Linux)TNSnames.ora file not the recovery catalog (windows) databases' side? Correct?

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234003 is a reply to message #234002]

Sat, 28 April 2007 21:07

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Ok. But the Oracle 10g software must be installed on this seperate server (Windows) right?
Yes.
>>Then I would just add the TNS entry on the target database (Linux)TNSnames.ora file not the recovery catalog (windows) databases' side? Correct?
You can invoke RMAN backup from anywhere.
The target database and recovery catalog database should identify each other using tnsnames.ora entries.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234427 is a reply to message #234003]

Tue, 01 May 2007 09:55

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Ok. I have got the connection working. However, I'm getting the following error when I am trying to connect to the target and catalog database with the following command:

RMAN> connect CATALOG rman/rman@catdb TARGET sys/<passwd>@<hostname>

RMAN-00571: ===========================================================
RMAN-00569:===== ERROR MESSAGE STACK FOLLOWS ==============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

How to I grant privs to rman to be able to connect to the target database, which again is on a Linix server?

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234432 is a reply to message #234427]

Tue, 01 May 2007 10:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I would first try to establish an sqlplus connection.
Check your sqlnet.ora. Remove unwanted entries.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234435 is a reply to message #234432]

Tue, 01 May 2007 10:20

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

My sqlnet.ora seems to be fine. However, I cannot establish a sqlplus connection as sys from catalog database (Windows) to the target database (Linux). I am getting the same error:
ERROR:
ORA-01031: insufficient privileges

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234443 is a reply to message #234435]

Tue, 01 May 2007 11:03

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Is it necessary for me to create a database link?

I don't see how I can grant any privs from the target database to the catalog database when there is no link between the two other than the listener and tns file.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234451 is a reply to message #234435]

Tue, 01 May 2007 11:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>However, I cannot establish a sqlplus connection as sys from catalog database (Windows) to the target database (Linux).
Means some problem.
Comment all entries in sqlnet.ora in both nodes and try (in target database)
No need for 'database link'.
You just need a tns entry.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234455 is a reply to message #234451]

Tue, 01 May 2007 11:55

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Ohh. Ok. Let's take a step back. Do I need to modify both TNS and listener files? In the target and catalog database? Because I only modified the catalog database one.

This is what I'll do:
- add the TNS entry in the target database as well as the catalog database
- try the connection. If it does not work then I'll comment out the sqlnet.ora files for both the target and catalog databases

How does that sound?

Thanks

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234491 is a reply to message #234455]

Tue, 01 May 2007 15:30

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I'm still getting the same error. Does it have anything to do with the pwfile? I ran select * from v$pwfile_users and got the following:

USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
RMAN TRUE FALSE

I tried with commenting out the sqlnet.ora entries for both and that still didn't do it.

Please help...I'm on a tight timeline.

Thanks,

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234496 is a reply to message #234491]

Tue, 01 May 2007 15:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

lawp1 is my target database identified by tnsentry (local tnsnames.ora)
rmandb is my catalog database identified by my local tnsnames.ora
in your case first make sure you have created proper tnsentries.
Try connecting with sqlplus and test it.
Did you create a passwordfile? If so, it may be corrupt.
Try recreating one. Even before doing it, just make sure you have
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in your pfile/spfile.

oracle@mutation#rman

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN> connect target sys/sys@lawp1

connected to target database: LAWP (DBID=907585623)

RMAN> connect rcvcat r_lawp/rman@rmandb

connected to recovery catalog database

>>RMAN> connect CATALOG rman/rman@catdb TARGET sys/<passwd>@<hostname>
replace your HOSTname with tnsservicename / tnsentry.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234499 is a reply to message #234496]

Tue, 01 May 2007 16:17

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Okay. Let me tell you what I have done so far.

When I try to connect from the Windows(catalog db) DOS prompt to the target database (Linux):

SQL> connect sys@fprcdev.fprc.ophth.wisc.edu as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

1. So I cannot connect to the other target database like this.

Question: As for TNS entries, then do I have to modify them at both ends i.e. target and catalog? If so, then I have already done that.

2. Do I create the pwfile on the target database or catalog?

3. the remote_login_passwordfile parameter should be set to EXCLUSIVE in the target or catalog?

After these clarifications, I will proceed what you told me to do in the previous reply.

Thank you,

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234501 is a reply to message #234499]

Tue, 01 May 2007 16:27

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

First, start reading the documentation.
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/toc.htm

>> As for TNS entries, then do I have to modify them at both ends i.e. target and catalog?
Whereever you want to connect to.
>>If so, then I have already done that.
Based on the questions you are asking,
did you create the listener? Check tnsentries with tnsping service name. YOu should get simlar stuff

oracle@mutation#tnsping rmandb

TNS Ping Utility for Solaris: Version 9.2.0.8.0 - Production on 01-MAY-2007 17:27:38

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = rmandb)))
OK (30 msec)

>> Do I create the pwfile on the target database or catalog?
Both. It is a standard practise whether you are using rman or not.
>>3. the remote_login_passwordfile parameter should be set to EXCLUSIVE in the target or catalog?
Whereever you want to connect as sys into.
In this case, your target database.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234571 is a reply to message #234501]

Wed, 02 May 2007 09:50

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I have done the following, BUT I still cannot connect. I get the same error of "insufficient privs."

-The TNSping utility is working and on both ends (target and catalog).
- I have created the password files and they are both set to EXCLUSIVE

Question
- How can I give privs to the rman user to connect to the target database, which is on a different server? I can't even connect as sys through SQLPLUS to the target database.

I'M STUCK!!

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234579 is a reply to message #234571]

Wed, 02 May 2007 10:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Forget about RMAN for a while.
>> I can't even connect as sys through SQLPLUS to the target database
This is the problem first.
Post contents of your sqlnet.ora.
Post what you did. verbatim (screenshots)

[Updated on: Wed, 02 May 2007 10:20]

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234583 is a reply to message #234579]

Wed, 02 May 2007 10:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you connecting as sysdba in sqlplus?

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234589 is a reply to message #233869]

Wed, 02 May 2007 10:45

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Ok here is what I have tried so far.

1. I re-created the password file in the target database and it is set to EXCLUSIVE.

>>Are you connecting as sysdba in sqlplus?
Initially, when I was tring to connect as sysdba in sqlplus I was getting the insufficient privileges error. Now that I created the password file, it is giving me a couple of different tns errors:

ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

OR

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

And this doesn't make any sense because when I do tnsping db_name then it works and it is reading it. OK Below are the contents of the sqlnet.ora file from the catalog database:

#
# sqlnet.ora
# In D:\oracle\product\10.2.0\db_1\network\admin
# 09/27/2006
#
SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.EXPIRE_TIME = 10
NAMES.DIRECTORY_PATH = (TNSNAMES)
TRACE_LEVEL_SERVER = OFF
#TRACE_DIRECTORY_SERVER = D:\oracle\admin\rctest\trace
#TRACE_FILE_SERVER = sqlnet_rctest_srv.trc

Here is the TNSnames.ora file also from the catalog database. Note: the catalog database name is FPRCCAT (Windows); the target database name is FPRCDEV (Linux)

FPRCDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fprcdev.rh-development.fprc.ophth.wisc.edu)
)
)

FPRCDEV.FPRC.OPHTH.WISC.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fprcdev.rh-development.fprc.ophth.wisc.edu)
)
)

FPRCCAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FPRCCAT.japan.fprc.ophth.wisc.edu)
)
)

FPRCCAT.FPRC.OPHTH.WISC.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FPRCCAT.japan.fprc.ophth.wisc.edu)
)
)

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234594 is a reply to message #233869]

Wed, 02 May 2007 10:53

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Here are the TNSPING commands I executed and errors

H:\>tnsping fprcdev

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 02-MAY-2007 10:31:28

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = FPRCDEV.rh-development.fprc.o
phth.wisc.edu)))
OK (30 msec)

H:\>set ORACLE_SID=fprdev

H:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed May 2 10:32:19 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect sys/password@fprcdev.fprc.ophth.wisc.edu as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

H:\>tnsping fprcdev.rh-development.fprc.ophth.wisc.edu

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 02-MAY-2007 10:31:11

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234597 is a reply to message #234594]

Wed, 02 May 2007 11:00

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You are ping'ing a service and using somthing else in connect string. Why?
use this (from OS command prompt)
sqlplus "sys/yourpassword@fprcdev as sysdba"

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234600 is a reply to message #233869]

Wed, 02 May 2007 11:07

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I tried and this is what I got:

H:\>sqlplus "sys/password@fprcdev as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed May 2 11:01:12 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Could it be the TNSnames file in the target database??

And after this I changed the tns entry to:

FPRCDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fprcdev)
)
)

and I still got the same error as above.

[Updated on: Wed, 02 May 2007 11:10]

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234601 is a reply to message #234600]

Wed, 02 May 2007 11:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

goto node where FPRCDEV is hosted.
Make sure the database is UP and available.
Do an lsnrctl status (assuming you are using the default listener.
Commend all entries in both sqlnet.ora and try again.

[Updated on: Wed, 02 May 2007 11:22]

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234603 is a reply to message #233869]

Wed, 02 May 2007 11:24

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I checked if the FPRCDEV database is up:

[oracle@rh-development dbs]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 02-MAY-2007 10:44:30

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LSNR_FPRCDEV
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 27-APR-2007 10:52:36
Uptime 4 days 23 hr. 51 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/app/oracle/admin/FPRCDEV/logmuseum/oraclenet/lsnr_fprcdev.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "FPRCDEV.fprc.ophth.wisc.edu" has 2 instance(s).
Instance "FPRCDEV", status UNKNOWN, has 1 handler(s) for this service...
Instance "FPRCDEV", status READY, has 1 handler(s) for this service...Service "FPRCDEVXDB.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "FPRCDEV", status READY, has 1 handler(s) for this service...
Service "FPRCDEV_XPT.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "FPRCDEV", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

However, when I ran the same command from the Windows server I got:

LSNRCTL for 32-bit Windows: Version 10.2.0.2.0 - Production on 02-MAY-2007 11:13:59

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=japan.fprc.ophth.wisc.edu)(PORT=1521)(QUEUESIZE=256)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production
Start Date 30-APR-2007 21:52:26
Uptime 1 days 13 hr. 21 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File D:\oracle\logarch\oraclenet\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=japan.fprc.ophth.wisc.edu)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "FPRCCATXDB.japan.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "FPRCCAT", status READY, has 1 handler(s) for this service...
Service "FPRCCAT_XPT.japan.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "FPRCCAT", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "fprccat.japan.fprc.ophth.wisc.edu" has 2 instance(s).
Instance "FPRCCAT", status READY, has 1 handler(s) for this service...
Instance "fprccat", status UNKNOWN, has 1 handler(s) for this service...
Service "fprcdev.rh-development.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "fprcdev", status UNKNOWN, has 1 handler(s) for this service...Service "rctest.japan.fprc.ophth.wisc.edu" has 2 instance(s).
Instance "rctest", status UNKNOWN, has 1 handler(s) for this service...
Instance "rctest", status READY, has 1 handler(s) for this service...
Service "rctestXDB.japan.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "rctest", status READY, has 1 handler(s) for this service...
Service "rctest_XPT.japan.fprc.ophth.wisc.edu" has 1 instance(s).
Instance "rctest", status READY, has 1 handler(s) for this service...
Service "tg4msql" has 1 instance(s).
Instance "tg4msql", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Here are the contents of my listener.ora on the Windows side:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521)(QUEUESIZE = 256))
(ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521)(QUEUESIZE = 256))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SDU = 32768)
(GLOBAL_DBNAME = rctest.japan.fprc.ophth.wisc.edu)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = rctest)
)
(SID_DESC =
(SDU = 32768)
(GLOBAL_DBNAME = fprccat.japan.fprc.ophth.wisc.edu)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = fprccat)
)
(SID_DESC =
(SDU = 32768)
(GLOBAL_DBNAME = fprcdev.rh-development.fprc.ophth.wisc.edu)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1)
(SID_NAME = fprcdev)
)
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = tg4msql)
)
)

LOG_DIRECTORY_LISTENER = D:\oracle\logarch\oraclenet
LOG_FILE_LISTENER = listener.log

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234606 is a reply to message #234603]

Wed, 02 May 2007 11:35

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I checked if the FPRCDEV database is up
You checked the listener.
Not the database.
Please not that, when you throw TOO MUCH OF unwanted garbage information, it will really confuse us over the other end.
You have similar entries all over.

Restart both the datbases.
Comment all entries in both sqlnet.ora and try again.

THis is very very simple.
Target database:
See whether database is up.
See listener is up.
Check whether you created the passwordfile correctly.
CHeck remote_login_passwordfile in target initsid.ora/spfile.
Check wheter you can talk to target database ( from local) using
tnsservervice.
sqlplus "sys/pass@yourservice as sysdba"
Try again from remote node (say your RMAN NODE).

Do the same for your RMAN database(node).
Check whether you can establish Sqlplus connections as SYS (from RMAN node to Target db).

Regarding the Privs,
You can worry about that later (when you are creating the repository. First try to establish the connectivity.

[Updated on: Wed, 02 May 2007 11:54]

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234615 is a reply to message #234606]

Wed, 02 May 2007 12:24

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I apologize Embarassed

Embarassed

I am going to send you a detailed follow up post after this question. I just looked at the password file and I have 2.

/opt/app/oracle/admin/FPRCDEV/pfile

drwxrwxr-x 12 oracle dba 4096 Apr 12 16:54 ..
-rw-r--r-- 1 oracle oinstall 5298 Apr 16 10:50 initFPRCDEV.ora
-rw-r----- 1 oracle dba 7680 May 2 09:36 orapwFPRCDEV
drwxr-xr-x 2 oracle dba 4096 May 2 09:36 .

and 1 in the directory below: /opt/app/oracle/product/10.2.0/db_1/dbs. Should I delete one?

-rw-r----- 1 oracle dba 8385 Sep 11 1998 init.ora
-rw-r--r-- 1 oracle dba 12920 May 3 2001 initdw.ora
-rwSr----- 1 oracle dba 3584 Apr 16 10:03 pwdFPRCDEV.ora
-rw-rw---- 1 oracle dba 1552 Apr 16 10:30 hc_FPRCDEV.dat
-rw-rw---- 1 oracle dba 24 Apr 16 10:30 lkFPRCDEV
drwxr-xr-x 62 oracle dba 4096 Apr 17 22:40 ..
-rw-r----- 1 oracle dba 5632 Apr 30 13:35 spfileFPRCDEV.ora
drwxr-x--- 2 oracle dba 4096 May 2 09:46 .
-rwSr----- 1 oracle dba 1536 May 2 09:48 orapwFPRCDEV

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234617 is a reply to message #234615]

Wed, 02 May 2007 12:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I would keep the ones in $ORACLE_HOME/dbs.
Also have one copy of pfile and (or) spfile in $ORACLE_HOME/dbs.
To create password file, check here.
http://orafaq.com/faqdbase.htm#INTERNAL

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234651 is a reply to message #233869]

Wed, 02 May 2007 14:25

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I apologize. When I checked that the database is up I actually connected to it like this:
[oracle@rh-development admin]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Wed May 2 11:05:41 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining Scoring Engine options

SQL>

Restart both the datbases - done
Comment all entries in both sqlnet.ora and try again - done

THis is very very simple.
Target database:
See whether database is up - yes
See listener is up - yes
>>Check whether you created the passwordfile correctly.
The command that I gave to create the password file was:

orapwd file=orapwFPRCDEV password=<password> and then I gave it the chmod 4640 privs. >>

>>CHeck remote_login_passwordfile in target initsid.ora/spfile.

SQL> show parameter pass

NAME TYPE VALUE
------------------------------ -------------- -------------
remote_login_passwordfile string EXCLUSIVE

>>Check wheter you can talk to target database ( from local) using
tnsservervice.

Commands are running on the Target(FPRCDEV-Linux) database:
[oracle@rh-development pfile]$ tnsping fprcdev

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 02-MAY-2007 13:35:30

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
/opt/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = FPRCDEV.fprc.ophth.wisc.edu)))
OK (0 msec)
[oracle@rh-development pfile]$ sqlplus "sys/password@fprcdev as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Wed May 2 13:36:17 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining Scoring Engine options

>>Do the same for your RMAN database(node).
Check whether you can establish Sqlplus connections as SYS (from RMAN node to Target db).

So I can connect to the target database from the target database server. BUT when I try to connect to the TARGET database from the catalog (RMAN Node-Windows) then I get the following error:

H:\>tnsping fprcdev

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 02-MAY-2007 14:04:57

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = fprcdev)))
OK (20 msec)

H:\>set ORACLE_SID=frpcdev

H:\>sqlplus "sys/password@fprcdev as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed May 2 14:08:32 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

So basically, I can connect to each database from their own server, But when I try to connect to the target from catalog or vice versa I get the TNS error.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234657 is a reply to message #234651]

Wed, 02 May 2007 14:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> chmod 4640 privs.
Are you logged in as Oracle? You no need to do anysuch thingies.
You are still confusing me.
You did this (from linux box).
>> [oracle@rh-development pfile]$ tnsping fprcdev
seems fprcdev is hosted on rh-development.fprc.ophth.wisc.edu with service FPRCDEV.fprc.ophth.wisc.edu.

and again did ( from windows)
>>H:\>tnsping fprcdev
which again seems to be hosted on rh-development.fprc.ophth.wisc.edu (as the previous server???)

So what exactly is going on?
Are you trying to access the same database from different nodes?
You need to explain~.
Seems you are using WRONG TNSENTRIES.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234662 is a reply to message #234651]

Wed, 02 May 2007 14:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Ok. Let us startover Smile

Smile

From linux machine(target):
try
sqlplus "sys/password@targetdatbase as sysdba".
If this fails,
look whether 'targetdatabase' is a valid entry in linux machine's tnsnames.ora.
Make sure there is nO entry in sqlnet.ora.
try loging as a 'regular' user instead of sysdba (use regularuser/password@targetdatabase).
If that works(regular user works, sys fails), problem is with your local passwordfile.
Then
try
sqlplys "rmanuser/rmand@rmandb"

Meanwhile, i assume you do not have more than one ORACLE_HOME. Do you?
If so, export the CORRECT $ORACLE_HOME

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234663 is a reply to message #233869]

Wed, 02 May 2007 15:00

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

Ok. Let me start from the beginning and tell you what I have been trying to do.

1. I need to setup a recovery catalog database. This database will be sitting on a Windows machine (Server). I created the recovery catalog database with the database name as FPRCCAT.

2. This recovery catalog database needs to store RMAN metadata for a database that is on a Linux box. That database is called FPRCDEV.

3. So in terms of RMAN...we have the "catalog" database - FPRCCAT
and the "target" database - FPRCDEV.

4. Now my problem began when I was trying to configure/setup the catalog database. I was at the last step where you have to connect to both the catalog and target databases to give the REGISTER DATABASE command. BUT before I could get to that part I got an error when I was trying to connect to the catalog and target database with the following command:

RMAN> connect CATALOG rman/rman@fprccat TARGET sys/password@fprcdev

NOTE: That all of this is being done on the Windows machine because that is where the recovery catalog (FPRCCAT) database resides.

From this point is where I asked for your help with the "insufficient privs" errors, which now has turned into TNS errors. I hope this is clear.

Thanks

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234665 is a reply to message #234663]

Wed, 02 May 2007 15:05

manjeet24
Messages: 6
Registered: May 2007
Location: California

Junior Member

If you have not granted the following privileges to "rman" then
Please do the following :

grant connect, resource to rman;
grant RECOVERY_CATALOG_OWNER to rman;

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234667 is a reply to message #233869]

Wed, 02 May 2007 15:09

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

I have already done it.

I am at the part where---if you look in the documentation it give the command:

% rman TARGET / CATALOG rman/cat@catdb

THIS IS WHERE I AM GETTING THE ERROR. Everything else before that has been done.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234669 is a reply to message #234662]

Wed, 02 May 2007 15:16

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

>>From linux machine(target):
try sqlplus "sys/password@targetdatbase as sysdba".

This works. I have no problem...never did.

>>try loging as a 'regular' user instead of sysdba (use regularuser/password@targetdatabase).

This also works...never had a problem.

>>Then try sqlplys "rmanuser/rmand@rmandb"

This is where the problem is...I can't connect to catalog from target server or vice versa.
[oracle@rh-development oradata]$ sqlplus "rman/rman@fprccat"

SQL*Plus: Release 10.2.0.3.0 - Production on Wed May 2 14:39:46 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

OR
[oracle@rh-development oradata]$ sqlplus "sys/password@fprccat" as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed May 2 14:40:44 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

And I only have one Oracle Home.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234671 is a reply to message #234669]

Wed, 02 May 2007 15:22

manjeet24
Messages: 6
Registered: May 2007
Location: California

Junior Member

I was facing the same problem. Get it checked with linux admin if both the machines are on same domain.

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234672 is a reply to message #234669]

Wed, 02 May 2007 15:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Is there a firewall involved between linux and windows machines?
if so,
USE_SHARED_SOCKET=TRUE in registry and reboot windows machine.

[Updated on: Wed, 02 May 2007 15:24]

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234673 is a reply to message #234669]

Wed, 02 May 2007 15:24

manjeet24
Messages: 6
Registered: May 2007
Location: California

Junior Member

Try the following please:

$ORACLE_HOME/bin/rman target / catalog rmanuser/rmanpwd@rmandb

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234675 is a reply to message #233869]

Wed, 02 May 2007 15:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

<tns_alias>=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<fully.qualified.hostname>)(PORT=<port_num>))(CONNECT_DATA=(SID=<your_sid >)))

Try changing your tnsnames.ora entries to appear like the line above.
Replace <substitution_strings> above with value correct for you.

HTH & YMMV!

[Updated on: Wed, 02 May 2007 15:39] by Moderator

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234986 is a reply to message #234675]

Thu, 03 May 2007 11:33

shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI

Senior Member

ok. It seems like I can't get it to work. I can't waste my time on the catalog as I have to get some backups implemented.

Now I'm trying to connect to rman on the target database through the prompt and nothing is happening. Anyone know why? Meaning I give the "rman" command to connect to the rman utility and nothing is happenning, like below:

[oracle@rh-development db_1]$ rman

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234987 is a reply to message #234986]

Thu, 03 May 2007 11:40

manjeet24
Messages: 6
Registered: May 2007
Location: California

Junior Member

check if the oracle_sid and oracle_home are set properly.

Send me the following:
echo $ORACLE_SID
echo $ORACLE_HOME

Report message to a moderator

Re: Catalog database on Windows Server and target Database on Linux?? [message #234991 is a reply to message #234986]

Thu, 03 May 2007 12:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

that is because in linux, there is this another utlity named as rman.

try $ORACLE_HOME/bin/rman


oracle@xxx:~> which rman
/usr/X11R6/bin/rman
oracle@xxx:~> which $ORACLE_HOME/bin/rman
/u01/home/bin/rma

[Updated on: Thu, 03 May 2007 12:06]

Report message to a moderator

Pages (2): [1 2 › »]

Previous Topic:	RMAN Backup
Next Topic:	rman backup script not running??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:36:43 CST 2024