Skip to Main Content

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.

Pseudo rows generated till 100

694022Apr 1 2009 — edited Apr 2 2009
Hello.

I need your help again (had to sign on new).
MY problem: Whe have a View which is receiving some columns.

Example:

A B
---------
df 1*
df 9*
ddf 1*
ddf 3*
ddf 54*
...

The pseudycolumns for "df" should be


1) 1*
2) blank
3) blank
4) blank
5) blank
6) blank
7) blank
8) blank
9) 9*
10) blank
11) blank
....
100) blank

The pseudycolumns for "ddf" should be


1) blank
2) blank
3) 3*
4) blank
5) blank
6) blank
7) blank
8) blank
9) blank
10) blank
11) blank
54) 54*
....
100) blank

Max row number = 100
Any tipps or tricks... thx Silvester752
This post has been answered by BluShadow on Apr 2 2009
Jump to Answer

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 Apr 30 2009
Added on Apr 1 2009
13 comments
1,416 views