| Bishal |
Posted: May 02, 2008 07:11:43 AM |
Total Post: 207
Joined: Apr, 2008
|
what are the parameters that needs to be set for auxiliary database in LISTENER.ORA AND TNSNAMES.ORA FILE...
pLEASE PROVIDE IN DETAIL |
|
|
 GOPU |
| Posted: May 02, 2008 07:15:17 AM |  |
|
Total Post: 340
Joined: Apr, 2008
|
go through this link
http://www.idevelopment.info/data/Oracle/DBA_tips/RMAN_9i/RMAN9_32.shtml
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 07:18:20 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Bishal,
Are you reading any links which is provided ?
I will suggest you to read documents thoroughly before starting any work.It will save your time in troubleshooting and error fixings.
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 07:20:03 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
HI GOPU,
DO I NEED TO CHANGE PARAMETERS IN TNSNAMES.ORA AND LISTENER.ORA IF I AM AUXILIARY DATABASE ON SAME MACHINE
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 07:20:18 AM | |
|
Total Post: 340
Joined: Apr, 2008
|
I think he is not going throuhg any of the links....
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 07:24:27 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
THE PROBLEM IS I AM NOT ABLE TO CREATE AUXILIARY DATABASE SINCE YESTERSAY...
IT GIVES AN ERROR TNS SERVER NAME COULD NOT BE RESOLVED...
NOT ABLE TO FIX IT AT ALL
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 07:25:49 AM | |
|
Total Post: 340
Joined: Apr, 2008
|
I think you have to do some modification
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 07:28:56 AM | |
|
Total Post: 340
Joined: Apr, 2008
|
can you post the error you getting
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 07:33:09 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
ORA-12154: TNS: COULD NOT RESOLVE THE SERVICE NAME
i dont know what is the problem... and what modification needs to be done...
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 07:48:55 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
if i am running my auxiliary database on the same host.. i dont think i need to modify anything in tnsnames.ora or listener.ora;
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 08:19:02 AM | |
|
Total Post: 340
Joined: Apr, 2008
|
Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.
- Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.
- Make sure the host, port and service name specified are correct.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
