PMREDDY19 Posted February 4, 2013 Report Posted February 4, 2013 [quote name='Silence..Please' timestamp='1360004833' post='1303224171'] scan IP is a new concept bhayya .. each scan IP will listen to 3 IP's in round-robin fashion .. scan IP anedhi Oracle concept, i dont think its network related (i may be wrong ) .. where as VIP is single VIRTUAL Ip .. [/quote] SCAN IP ni kuda netwrok vallu provide chestaru anukunta. .kada.. RAC kosam request pettinappudey.. Request form lo. mention chestaavu kada.. Inni SCAN ips.. innni VIPs kaavali ani cheppi..
ChampakDas Posted February 4, 2013 Report Posted February 4, 2013 good deal....thanks for the information mama [quote name='Silence..Please' timestamp='1360004833' post='1303224171'] scan IP is a new concept bhayya .. each scan IP will listen to 3 IP's in round-robin fashion .. scan IP anedhi Oracle concept, i dont think its network related (i may be wrong ) .. where as VIP is single VIRTUAL Ip .. [/quote]
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='GatisKandis' timestamp='1360004309' post='1303224093'] mee ammulyamina time ki ketayinchinandhuku thanks.....inko doubt bold: how is it different [/quote] tnsnames lo SCAN untndi ippudu users oracle RAC database ki connect avali annapudu use avtundi. for example 4 node unna appudu a scan user ni a 4 node lo edo okadaniki connect chestundi,depending on node busy unte(let's say node 1 already busy undi anuko 2,3,4 edo oka daniki connect avutundi)
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='PMR aka OM' timestamp='1360005022' post='1303224203'] SCAN IP ni kuda netwrok vallu provide chestaru anukunta. .kada.. RAC kosam request pettinappudey.. Request form lo. mention chestaavu kada.. Inni SCAN ips.. innni VIPs kaavali ani cheppi.. [/quote] yeah anthe bhayya,adi kuda round robin lo ani mention chestam
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='Silence..Please' timestamp='1360004888' post='1303224179'] oracle user ga create chesthe .. saripothundi .. no need of using cluster resources .. andhu k anna .. y to touch grid ani .. [/quote] kadhu bhayya RAC lo listener.ora grid home untndi kadha Oracle home undadu kadha ani adugtuna??
ChampakDas Posted February 4, 2013 Report Posted February 4, 2013 thanks mama...boundary conditions? like if all the 4 nodes are busy? [quote name='KOTC' timestamp='1360005208' post='1303224225'] tnsnames lo SCAN untndi ippudu users oracle RAC database ki connect avali annapudu use avtundi. for example 4 node unna appudu a scan user ni a 4 node lo edo okadaniki connect chestundi,depending on node busy unte(let's say node 1 already busy undi anuko 2,3,4 edo oka daniki connect avutundi) [/quote]
PMREDDY19 Posted February 4, 2013 Report Posted February 4, 2013 [quote name='KOTC' timestamp='1360005275' post='1303224236'] yeah anthe bhayya,adi kuda round robin lo ani mention chestam [/quote] Data center vaadiki Racking request pettey time lo.. 3 servers oracle RAC lo pettali antey.. seperate gaa mention cheyyali.. node 1 meeeda.. more number of VIPS kaaavali.. migilina 3 nodes meeda.. 1 extra VIP each ala .. inak akakdey SCAN IPs ki kuda edho mention cheis undedhi..
Gachibowli_Diwakar Posted February 4, 2013 Report Posted February 4, 2013 [quote name='KOTC' timestamp='1360005342' post='1303224249'] kadhu bhayya RAC lo listener.ora grid home untndi kadha Oracle home undadu kadha ani adugtuna?? [/quote] cluster services use cheyali anukunte grid home lo listener ni add chesthav .. avasaram ledu anukunte oracle home (under oracle user) lo listener ni nuvu start cheyochu .. just like u start listener for non-rac database .. unless INSTANCE_NAME ani specify chesthe thappa .. general ga nuvu em chesina kuda .. the connection may go to any of the node .. enduku anavsaram ga grid lo listener.ora ni kelakatam ani .. oracle user lo create cheyi ani cheppa anthe .. oracle home enduku undadhu .. adhi lekapothe database ela run authundi moreover .. ni listener.ora lo oracle home specify cheyochu .. grid home ye ivali ani em rule ledu .. give it a try and see it will work , I tested it many a times .. database ni duplicate cheyali annapudu [quote name='PMR aka OM' timestamp='1360005022' post='1303224203'] SCAN IP ni kuda netwrok vallu provide chestaru anukunta. .kada.. RAC kosam request pettinappudey.. Request form lo. mention chestaavu kada.. Inni SCAN ips.. innni VIPs kaavali ani cheppi.. [/quote] yeah correct ye .. now i remember
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='GatisKandis' timestamp='1360005417' post='1303224255'] thanks mama...boundary conditions? like if all the 4 nodes are busy? [/quote] ala nodes ani busy aithe no more connections unna connections kuda break avutai bhayya adi antha malli different concept bhayya.processor 100% tho run ayinapud sar 60 480 command koti chudu neku idea vastundi % usr %sys %wio % idle a idle dagara 0 vachindi ante ani node paina appudu ala avachu(telsindi chepina kaka tapu aithe evaru ayina correct cheyandi vayya)
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='Silence..Please' timestamp='1360005763' post='1303224303'] cluster services use cheyali anukunte grid home lo listener ni add chesthav .. avasaram ledu anukunte oracle home (under oracle user) lo listener ni nuvu start cheyochu .. just like u start listener for non-rac database .. unless INSTANCE_NAME ani specify chesthe thappa .. general ga nuvu em chesina kuda .. the connection may go to any of the node .. enduku anavsaram ga grid lo listener.ora ni kelakatam ani .. oracle user lo create cheyi ani cheppa anthe .. oracle home enduku undadhu .. adhi lekapothe database ela run authundi moreover .. ni listener.ora lo oracle home specify cheyochu .. grid home ye ivali ani em rule ledu .. give it a try and see it will work , I tested it many a times .. database ni duplicate cheyali annapudu yeah correct ye .. now i remember [/quote] ardham ayindi nuv chepindi nenu anedi listener.ora installation time lo create avtundi kadha.RAC lo different untndi antuna in regards non-rac database.na dantlo ippudu listener.ora ledhu oraclehome paina but grid lo undi listener file.ippudu lsnrctl status kodite neku services run ayinatu chupistundi. so RAC database install chesaka oraclehome lo listener.ora create avundha? leka manam manual ga create cheyala?adi na question.oraclehome lo listener file lekapoina em kadha? [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Oracle acts as a Client-Server software. That means you have two main ends, the Client who must somehow get to the server, and the server who must accept connexion requests from clients.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]When the client attempts to connect to the server, you give him a "Service". The service is mainly 4 info: Host for the server, Protocol and port (the language to speak) ad SID (name of the instance/database). Those 4 infos are usually and by default locates in a tnsnames.ora. This is called: Translation Named Server - errrrrr Service - errrr Ser* [/background][/size][/font][/color][img]https://forums.oracle.com/forums/images/emoticons/happy.gif[/img] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]On the server side you must have one or more active processes (daemons) who are waiting for the client to attempt a connection. Those services are called Listeners. In most cases only one listener is required. This listener is configured via a listener.ora file. This file includes the process config, mainly: Host for which it listens, protocol and port, list of SID for which the process can establish a connexion.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Furthermore, if you're connecting to the database on the server computer, and it's the default database, you don't need to tell where you're going when you're the client. Default Database. [size=3][b]You don't even need to have a listener.[/b][/size][/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Please review the Net Service administrator's Guide ([/background][/size][/font][/color][url="http://www.oracle.com/pls/db92/db92.to_pdf?pathname=network.920%2Fa96580.pdf&remark=docindex"]http://www.oracle.co...remark=docindex[/url][color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]) for more info.[/background][/size][/font][/color] [url="https://forums.oracle.com/forums/thread.jspa?threadID=293386"]https://forums.oracl...threadID=293386[/url]
Gachibowli_Diwakar Posted February 4, 2013 Report Posted February 4, 2013 [quote name='KOTC' timestamp='1360006531' post='1303224419'] ardham ayindi nuv chepindi nenu anedi listener.ora installation time lo create avtundi kadha.RAC lo different untndi antuna in regards non-rac database.na dantlo ippudu listener.ora ledhu oraclehome paina but grid lo undi listener file.ippudu lsnrctl status kodite neku services run ayinatu chupistundi. so RAC database install chesaka oraclehome lo listener.ora create avundha? leka manam manual ga create cheyala?adi na question.oraclehome lo listener file lekapoina em kadha? [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Oracle acts as a Client-Server software. That means you have two main ends, the Client who must somehow get to the server, and the server who must accept connexion requests from clients.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]When the client attempts to connect to the server, you give him a "Service". The service is mainly 4 info: Host for the server, Protocol and port (the language to speak) ad SID (name of the instance/database). Those 4 infos are usually and by default locates in a tnsnames.ora. This is called: Translation Named Server - errrrrr Service - errrr Ser* [/background][/size][/font][/color][img]https://forums.oracle.com/forums/images/emoticons/happy.gif[/img] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]On the server side you must have one or more active processes (daemons) who are waiting for the client to attempt a connection. Those services are called Listeners. In most cases only one listener is required. This listener is configured via a listener.ora file. This file includes the process config, mainly: Host for which it listens, protocol and port, list of SID for which the process can establish a connexion.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Furthermore, if you're connecting to the database on the server computer, and it's the default database, you don't need to tell where you're going when you're the client. Default Database. [size=3][b]You don't even need to have a listener.[/b][/size][/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Please review the Net Service administrator's Guide ([/background][/size][/font][/color][url="http://www.oracle.com/pls/db92/db92.to_pdf?pathname=network.920%2Fa96580.pdf&remark=docindex"]http://www.oracle.co...remark=docindex[/url][color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]) for more info.[/background][/size][/font][/color] [url="https://forums.oracle.com/forums/thread.jspa?threadID=293386"]https://forums.oracl...threadID=293386[/url] [/quote] ilanti special purpose scenarios ki kavali ante .. nuvve manual ga create cheyali listener in oracle .. this is outside of application perspective .. only for DBA's use
subbayya Posted February 4, 2013 Report Posted February 4, 2013 Silence..Please na problem kuda koncham solve cheyyava... [color=#282828][font=helvetica, arial, sans-serif]I have removed a job from jobs queue using [/font][/color] [color=#282828][font=helvetica, arial, sans-serif]exec sys.dbms_job.remove(job#);[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]But, now it's removed from daily jobs list? I need help in recovering it.[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Thanks in advance.[/font][/color]
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='Silence..Please' timestamp='1360007057' post='1303224501'] ilanti special purpose scenarios ki kavali ante .. nuvve manual ga create cheyali listener in oracle .. this is outside of application perspective .. only for DBA's use [/quote] ohk gotcha ade doubt unde.default ga aithe listener create avadhu kadha oraclehome lo??
KOTC Posted February 4, 2013 Author Report Posted February 4, 2013 [quote name='subbayya' timestamp='1360008182' post='1303224617'] Silence..Please na problem kuda koncham solve cheyyava... [color=#282828][font=helvetica, arial, sans-serif]I have removed a job from jobs queue using [/font][/color] [color=#282828][font=helvetica, arial, sans-serif]exec sys.dbms_job.remove(job#);[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]But, now it's removed from daily jobs list? I need help in recovering it.[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Thanks in advance.[/font][/color] [/quote] ela recover chedam ani bhayya nuv drop chesav kadha may malli recreate cheyali anukunta.not sure
subbayya Posted February 4, 2013 Report Posted February 4, 2013 [quote name='KOTC' timestamp='1360009840' post='1303224764'] ela recover chedam ani bhayya nuv drop chesav kadha may malli recreate cheyali anukunta.not sure [/quote] That's not drop buddy...just job queues nundi remove chesa...developer gadu ipudu adi kanapadatam ledu..aa code ento cheppu malli schedule chesukunta antunnadu...
Recommended Posts