Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How I work with MS-SQL function in oracle

599499Sep 24 2007 — edited Jul 30 2010
I’m working in oracle now but I don’t know how can I use following function in oracle.
convert, dateadd, datediff, fetch_status, isnumeric, reverse, str and stuff

Comments

Satishbabu Gunukula
See links

http://www.ardentperf.com/2007/02/28/rac-listener-best-practices/
http://cs.felk.cvut.cz/10gr2/install.102/b25414/rac_cfg.htm#i1033049

Hope this should help.

Regards
Click here to see [Connect by nocycle query gives wrong results|http://www.oracleracexpert.com/2009/08/connect-by-nocycle-query-wrong-results.html]
Click here to learn [Upgrade 8i to 10g|http://www.oracleracexpert.com/2009/08/upgrade-oracle-8i-to-10g.html]
http://www.oracleracexpert.com
RTunitn
Satishbabu Gunukula wrote:
See links

http://www.ardentperf.com/2007/02/28/rac-listener-best-practices/
http://cs.felk.cvut.cz/10gr2/install.102/b25414/rac_cfg.htm#i1033049

Hope this should help.

Regards
Click here to see [Connect by nocycle query gives wrong results|http://www.oracleracexpert.com/2009/08/connect-by-nocycle-query-wrong-results.html]
Click here to learn [Upgrade 8i to 10g|http://www.oracleracexpert.com/2009/08/upgrade-oracle-8i-to-10g.html]
http://www.oracleracexpert.com
Thank you Satishbabu,
but your link points to 10.2 installation.

On 10.2 and also on 11.1 I've been able to create two different listener, listening on different ports and make two databases register with only one listener:

listener_a, port 1521 -> db A register with it
listener_b port 1522 -> db B register with it

So, I can define firewall ACL to grant access on listener_a (db A) and/or listener_b (db B).

On RAC 11.2 things are quite different: clients access the db through scan listener:

sqlplus scott/tiger@cluster-scan:1521/servicename

For a brief explanation see:
http://www.oracle.com/technology/products/database/clustering/pdf/scan.pdf
http://download.oracle.com/docs/cd/E11882_01/rac.112/e10717/intro.htm#BABDIHAD

It seem that I could not add different scan listener on different port on the same subnet, so I can't define any acl.
A client that have access to port 1521 could specify the servicename of db_a or db_b...

I tried also to modify the standard scan listener to add a second port, but it's not supported.

Regards
R.
RTunitn
Solved.
See

http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener

Cheers
Roberto
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 27 2010
Added on Sep 24 2007
14 comments
7,234 views