Home » RDBMS Server » Networking and Gateways » Basic networking
Basic networking [message #290179] Thu, 27 December 2007 22:29 Go to next message
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
Re: Networking [message #290180 is a reply to message #290179] Thu, 27 December 2007 22:31 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
$ lsnrctl start
$ netca
& answer questions as prompted.
RMAN Recovery Catalogue [message #290181 is a reply to message #290179] Thu, 27 December 2007 22:32 Go to previous messageGo to next message
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: Basic networking [message #290183 is a reply to message #290179] Thu, 27 December 2007 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
read & follow posting guidelines as stated in URL above
Re: Networking [message #290184 is a reply to message #290180] Thu, 27 December 2007 22:39 Go to previous messageGo to next message
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 #290187 is a reply to message #290184] Thu, 27 December 2007 22:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Create another database on the same machine!!
Re: Basic networking [message #290188 is a reply to message #290179] Thu, 27 December 2007 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>I think we need to have 2 database servers .
You think incorrectly.
Re: Networking [message #290190 is a reply to message #290187] Thu, 27 December 2007 22:50 Go to previous messageGo to next message
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: Basic networking [message #290193 is a reply to message #290179] Thu, 27 December 2007 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Where I have more than 1 database on a system, I have files like
db1.env
db2.env
db3.env
db4.env
etc.
Prior to operating against any specific DB, source in the appropriate *env file.
Re: Networking [message #290195 is a reply to message #290190] Thu, 27 December 2007 22:58 Go to previous messageGo to next message
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.
Re: Networking [message #290197 is a reply to message #290195] Thu, 27 December 2007 23:00 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Sir,

Thanks and I will give a try and let you know.

Regards,
Raj
Re: Networking [message #290198 is a reply to message #290197] Thu, 27 December 2007 23:02 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Sorry Ana i didn't see your post i was replying.
You Welcome!!!
Previous Topic: TNS protocol adapter error
Next Topic: Problem listener?
Goto Forum:
  


Current Time: Wed Dec 07 08:45:24 CST 2016

Total time taken to generate the page: 0.06420 seconds