| Basic networking [message #290179] |
Thu, 27 December 2007 22:29  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello Sir,
I've installed RHAS4 Linux on my home machine with Oracle 10.2.0. Its working fine , but I want to do networking concepts like Listener and TNS configuration , RMAN with Recovery Catalogue .
My doubt is how can I configure on a single machine both the TNS and the Listener .
Please help me out.
Regards,
Raj
|
|
|
|
|
|
| RMAN Recovery Catalogue [message #290181 is a reply to message #290179] |
Thu, 27 December 2007 22:32  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello Sir,
I've installed RHAS4 Linux on my home machine with Oracle 10.2.0. Its working fine , but I want to do RMAN with Recover Catalogue only by configuring the Listener and TNS configuration.
My doubt is how can I configure on a single machine both the TNS and the Listener .
Please help me out.
Regards,
Raj
|
|
|
|
|
|
| Re: Networking [message #290184 is a reply to message #290180] |
Thu, 27 December 2007 22:39 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Sir,
But as I mentioned you, I'm having a home PC and in that I want to do Networking concepts like DB Links,Mviews , RMAN with Recovery Catalogue and for that I think we need to have 2 database servers .
But I heard that we can do all these topics on a home PC using 2 disks . Can you help me out in that.
Regards,
Raj
|
|
|
|
|
|
|
|
| Re: Networking [message #290190 is a reply to message #290187] |
Thu, 27 December 2007 22:50 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Sir,
Now I feel we are close to the solution of my problem. Can you help me how to create 2 databases on a home PC. I think we set the environmental variables like the ORACLE_SID and others in the .bash_profile .
But in this we can have only one .bash_profile , I guess .
Please ignore if there are any mistakes in my words but please send me the reply or any link if possible how to create two DB's on a single PC.
Regards,
Raj
|
|
|
|
|
|
| Re: Networking [message #290195 is a reply to message #290190] |
Thu, 27 December 2007 22:58 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
You can create either by DBCA or manually .Your both databases would be running at the same time but
the only difference is that you have to export ORACLE_SID before connecting to the database.
Let suppose you have database A & B.
When you want to connect to database A just type
export ORACLE_SID=A;
or
export ORACLE_SID=B
Just make the new entries for new database into TNSNAMES.ora.
Then you can interact with both database through dblink.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
