Archive for June, 2019
Without Editing tnsnames.ora file Creating a Database Link in Oracle
June 19th, 2019, posted in Oracle QueriesDevelopers needed access to some objects from one schema to another using database link. To enable database link he tried to create entry in tnsnames.ora file but had a problem with insufficient permissions. As a developer he has limited privileges on Unix machines so he can’t edit and save tnsnames.ora file.
But there is solution for this little problem.
You can create functional database link without editing tnsnames.ora file.
Little Demo Case:
system@TEST11> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production PL/SQL Release 11.1.0.7.0 - Production CORE 11.1.0.7.0 Production TNS for Linux: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production 5 rows selected. system@TEST11> select * from dba_db_links; 1. no rows selected
Create database link testlink_db2 using full tns entry:
system@TEST11> create database link testlink_db2 connect to system identified by oracle using '(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.2.10.18) (PORT=1525)) (CONNECT_DATA= (SID=test10)))' / Database link created.
Now little check and cleanout:
system@TEST11> select * from v$version@testlink_db2; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production 5 rows selected. -- cleanout system@TEST11> drop database link testlink_db2; Database link dropped.
From documentation:
http://download.oracle.com/docs/html/B13951_01/net.htm#i1153728
http:https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_5005.htm
server_name = (DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(PORT=port_number)
(HOST=host_name)
)
(CONNECT_DATA=(SERVICE_NAME=service_name)
)
)where:
server_name is the name of an Oracle server that matches an entry in the RDB directory. An entry in the RDB directory can be added using the ADDRDBDIRE command.
TCP is the TCP protocol used for TCP/IP connections.
port_number is the port number of the Oracle Net listener. This is usually port number 1521.
host_name is the name that defines the system where the target Oracle server resides. This name must be in the local host definition on the AS/400 or in a name server on your network. The host name can also be entered as an IP address, for example, 161.14.10.12.
service_name is the service name of the Oracle server.
Two Kinds Of Greedy People Never Get Satisfied
June 14th, 2019, posted in Saying Of Hazrat Ali ( A.S )
PAINTING THE ICONIC MARILYN MONROE WITH A PAKISTANI TWIST
June 1st, 2019, posted in Art, GiRLs, PAKiSTAN, POEPLes
Karachi-based artist, Summaiya Jillani, took a little over two weeks to paint her version of the iconic, beautiful, Marilyn Monroe.
Featured in colourful ethnic wear, with her braided, blond hair draped on one side of her shoulder, in addition to chunky earrings, the painting is pop art eccentric, animated and pretty darn brilliant. In a mere few days, an image of the painting went viral over Facebook. Jillani, a graduate from Karachi University remains baffled by the attention her painting seems to be generating.
Initially wanting to be a GD Pilot, Jillani couldn’t make the cut due to weak eyesight. However, the artist’s father was keen on his daughter becoming a doctor. “I was very good at Biology,” Jillani says regarding her consistent inclination towards the field of art, “Making nice diagrams, etc., therefore, this career used to be in the back of my mind like a haunting beast.”
Currently teaching Art at Beaconhouse, Jillani spoke with HELLO! Pakistan about her painting, art, how she approaches a project and more:
When did you paint this piece and what was it for?
I started working on this piece early this year but I left it 15% done as I got busy with a series of family events. Then on being contacted by the VM Gallery, here in Karachi, asking for some fresh work for a show called ‘Attaining Heights,’ I resumed working on it and finished the remaining 85% in a week alongside my job. Initially I was making the painting for myself. I start things very whimsically; not knowing where and how they would end up – but then they make their own way out. I feel very lucky.
How long did it take?
If I had to count to the exact number of days, I can say it’d have taken me about 15 days.
Did you have any other ideas in mind regarding what you’d like to see Monroe wearing?
I always have a lot of options for one single image and I pick one of them up quite intuitively, not thinking too much about it! Too much thinking overcooks the idea and also wastes time, I believe. The dress (angarkha) that you see Monroe wearing in the painting is a creation of a very young designer, Nabiha Hassan, who also studied at Karachi University. The first time I saw the dress, I had a thing for it…not for wearing it, but for painting it somehow! That dress has a life of its own and that certainly has made the painting what it is and the credit must also go to the person who designed the clothes.
What medium did you use for this painting?
I used a locally made cloth as the base with acrylic paints.
What was your inspiration behind this painting?
My only inspiration was to throw a pleasant visual at the viewer. I’m never looking for something too deep; rather, I look for an instant BANG effect! I don’t know if it’s a good or bad thing, all I know is that it works best for me. I can’t even say if I like Monroe or not. I have a taste for rather different things in movies such as dark British comedy, etc. Monroe is something I know almost everyone falls for in a jiffy and that is exactly what I enjoy bringing to light in my work.
What has the response been like so far?
The response has been simply overwhelming! I uploaded a photo of the painting (on Facebook) that was taken by my brother at the gallery and I’d forgotten that my wall photos were open to the public. And the very second it was uploaded, ‘likes’ and ‘shares’ went wild! The image went viral and in less than 12 hours it had almost about 600 shares directly from my profile.
Have there been any interested buyers?
Many!
Is this a one-off painting, or are you open to making identical paintings for interested buyers?
The idea is still in progress. Even before starting the painting I had a series of images in mind. So yes, in the near future we will be seeing more of Monroe with more surprising elements and a lot more than just Monroe!
How do you approach a project, what does the process entail?
My process is when I work, I sleep with it, I wake up beside it, and I listen to music constantly. I cannot work without music. I can’t tell how many hours exactly, but when I’m working I’ll keep at it until the need of a nap takes over me. And I’m not even a workaholic.
Source : https://sonyarehman.wordpress.com/2012/07/17/painting-the-iconic-marilyn-monroe-with-a-pakistani-twist/