Tras mucho buscar para poder conectarme desde Oracle Forms con la base de datos Oracle Database XE, al fin lo he conseguido. A continuación explico los pasos que he seguido para ello con la finalidad de que pueda ser de ayuda para muchos otros:

1. Instalar Oracle Developer Suite 10g
2. Instalar Oracle Database 10g Express Edition
3. Copiamos al portapapeles (ctrl + c) el contenido del fichero tnsnames.ora del directorio C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN (si instalamos Oracle Oracle Database 10g Express Edition en C:\oraclexe )
4. Pegamos el contenido anterior al final del documento tnsnames.ora del directorio C:\DevSuite\NETWORK\ADMIN\ (si hemos instalado Oracle Developer Suite 10g en el directorio C:\DevSuite).

5. Accedemos a la interfaz web de Oracle Database 10g Express Edition entrando en http://127.0.0.1:8080/apex/ . Hacemos login con el usuario SYS y la password que introducimos durante la instalación.

6. En la interfaz web, accedemos a Administración -> Usuarios Base Datos. Observamos que disponemos del usuario llamado «HR», el cual está bloqueado.
Hacemos clic sobre él y en la nueva ventana que aparece introducimos una password, ponemos el estado de la cuenta a «Desbloqueado» y comprobamos que tenga privilegios de CONNECT,RESOURCE y DBA (marcando las casillas).
Una vez hecho esto, pulsamos sobre «Modificar Usuario» con la finalidad de tener un usuario desde el cual conectarnos.

7. Ya podemos conectarnos desde Oracle Developer Suite 10g a la base de datos. Por ejemplo, para conectarnos mediante Forms Developer, vamos a Inicio -> Todos los programas -> Oracle Developer Suite -> Forms Developer -> Start OC4J Instance y a continuación abrimos el Forms Builder. Para ello vamos a Inicio -> Todos los programas -> Oracle Developer Suite -> Forms Developer -> Forms Builder

Ya  sólo falta conectarnos con la base de datos. Para ello vamos a Archivo -> Conectar o bien pulsamos «ctrl +j» . Nos aparecerá una nueva ventanita. En ella introducimos:

  • Usuario: HR
  • Contraseña: la contraseña que definimos en el paso 6.
  • Base de Datos: XE
Conectar Oracle Forms + Oracle Database XE (Express Edition) en Windows
Etiquetado en:                                        

128 pensamientos en “Conectar Oracle Forms + Oracle Database XE (Express Edition) en Windows

  • agosto 9, 2013 a las 11:51 am
    Enlace permanente

    Take a glance at any online job openings for the Internet and you will probably see a listing of benefits:
    higher than industry standard pay scales, healthcare, 401(k),
    paid vacation, sick and personal days. They can be cut into different lengths and offer a variety of available exercises to tone
    multiple muscle groups. Since many diets and exercise plans
    tend to fail, it is highly recommended to start out slow in order to provide the best chances
    for achievement and success.

  • agosto 10, 2013 a las 12:49 am
    Enlace permanente

    If you desire to improve your familiarity simply keep visiting this web site
    and be updated with the most up-to-date news update posted here.

  • agosto 13, 2013 a las 9:44 pm
    Enlace permanente

    I know this web site presents quality dependent articles or reviews and additional stuff, is there any other web page which provides these stuff in quality?

  • agosto 19, 2013 a las 1:29 am
    Enlace permanente

    Howdy would you mind letting me know which hosting company you’re utilizing? I’ve loaded your blog in 3 different internet browsers and
    I must say this blog loads a lot faster then most.
    Can you suggest a good web hosting provider at a fair price?
    Thanks, I appreciate it!

  • agosto 20, 2013 a las 10:35 am
    Enlace permanente

    Thanks for a marvelous posting! I definitely enjoyed reading it,
    you’re a great author. I will be sure to bookmark your blog and definitely will come back in the future. I want to encourage continue your great job, have a nice day!

  • agosto 29, 2013 a las 5:52 pm
    Enlace permanente

    Hey There. I found your blog using msn. This is a very well written article.

    I will be sure to bookmark it and return to read more of your
    useful info. Thanks for the post. I’ll certainly return.

  • octubre 1, 2013 a las 7:59 pm
    Enlace permanente

    You could definitely see your skills within the article you write.
    The arena hopes for even more passionate writers such as you
    who aren’t afraid to mention how they believe. At all times go after your heart.

  • octubre 2, 2013 a las 1:56 pm
    Enlace permanente

    I’ve been browsing online more than three hours today, yet I never found any
    interesting article like yours. It’s pretty worth enough for me.

    Personally, if all webmasters and bloggers made good
    content as you did, thhe wweb will be much more useful than ever before.|
    I couldn’t refrain from commenting. Well written!|
    I will right away snatch your rss as I can not to find your
    e-mail subscription link or newsletter service. Do you’ve any?
    Please alloow mme know in order that I could subscribe.
    Thanks.|
    It is thee best time to make some plans for the
    future and it is time to be happy. I have read this post and if I could I wsnt to
    suggest you some interesting things or tips. Perhaps you can
    write nxt articles referring to this article.
    I wanjt to read more things about it!|
    It’s appropriate time to make some plans for the longer term and
    it’s timme to be happy. I’ve learn this publish and if I could I wish to counsel you few interesting
    issues or suggestions. Maybe you can write next articles relating to this article.
    I want to learn even more things about it!|
    I have been browsing online more than 3 hours
    as of late, but I by no means discovered any fascinating article like yours.
    It is beautiful value enough for me. In my view, if all site owners and bloggers made excellent content material as you did, the net will likely be much more helpful than ever before.|
    Ahaa, its good dialogue on the topic of this piece of writing here at this
    web site, I have read all that, so now me also commenting here.|
    I am sure this piece of writing has touched all the internet users, its really really good paragraph on building up new weblog.|
    Wow, this post is nice, my sister is analyzing these things, therefore I am going to let know her.|
    Saved as a favorite, I like your website!|
    Way cool! Some extremely valid points! I appreciate you writing this write-up
    plus the rest of the website is also very good.|
    Hi, I do think this is an excellent site.
    I stumbledupon it 😉 I am going to return once again since
    i have book-marked it. Money and freedom is the greatest way
    to change, may you be rich and continue to guide other people.|
    Woah! I’m really enjoying the template/theme of
    this site. It’s simple, yet effective. A lot of times it’s very difficult to get that «perfect balance» betwen user friendliness and visual appeal.
    I must ssay that you’ve done a very good job with this.
    Additionally, the blog loads very quick for me on Safari.
    Outstanding Blog!|
    These are genuinely enormous ideas in concerning blogging.
    You have touched some nice things here. Any way keep up wrinting.|
    I really like what you guys are usually up
    too. Such clever work and reporting! Keep up the very good works guys I’ve incorporated
    you guys to blogroll.|
    Hey there! Someone in my Facebook group shared this website with us so
    I came to give it a look. I’m definitely enjoying the information.
    I’m book-marking and will be tweeting this to my followers!

    Grea blog andd superb style and design.|
    I love what you gugs are up too. This kind off clever work and exposure!
    Keep up tthe very good works guys I’ve incorporated you guys
    to my own blogroll.|
    Hey would you mind stating which blog platform you’re working with?

    I’m going to start my own blog in the near future but I’m having a hard time
    deciding between BlogEngine/Wordpress/B2evolution annd Drupal.
    The reaso I ask is because your design and style seems different then most blogs and I’m looking for something unique.
    P.S Sorry for being off-topic but I had to ask!|
    Hi there would you mind letting me know which web host you’re utilizing?
    I’ve loaded your blog in 3 completely different browsers and I must
    say this blog loads a lot quicker then most. Can you suggest a good hosting provider
    at a reasonable price? Cheers, I appreciate it!|
    I love it when people get together and share ideas.
    Great website, stick with it!|
    Thank you for the good writeup. It in fact was a amusement account it.
    Look advanced to far added agreeable from you! However, how could we
    communicate?|
    Hey just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Ie.
    I’m not sure iff this is a formatting issue or something to do with
    browser compatibility but I figured I’d post to let you know.

    The layout look great though! Hope you get the issue fixed soon.
    Kudos|
    This is a topic which is near to my heart…
    Thank you! Exactly where are your contact details though?|
    It’s very easy to find out any topic on web as compared to books, as I found this
    paragraph at this web site.|
    Does your site hace a contact page? I’m having trouble locating it but, I’d like to shoot you an email.
    I’ve got some ideas for your blog you might be interested
    in hearing. Either way, great site and I look forward to seeing it grow
    over time.|
    Hi! I’ve been reading yoour blog for a while nnow andd finally ggot the courage to go ahead and give
    you a shout out from Humble Texas! Just wanted to tell you keep up the great job!|
    Greetings from Los angeles! I’m bored to tears at work so I decided to check
    out your website on my iphone during lunch break.
    I enjoy the knowledge you provide here and can’t wait
    to take a lok when I get home. I’m surprised at how
    quick your blog loaded on my mobile .. I’m not even using WIFI,
    just 3G .. Anyhow, wonderful blog!|
    Its such aas you learn my thoughts! You appear too
    understand a lot aboutt this, such as you wrote the e
    book in it or something. I feel that you just
    can do with a few percent to pressure the message house a bit, but other than that, this
    is magnificent blog. A great read. I will certainly be back.|
    I visited various websites but the audio quality for audio
    songs current at this web site is really marvelous.|
    Hello, i read your blog occasionally and i own a similar one and
    i was just curious if you get a lot of spam responses?

    If so how do you protect against it, any plugin or anthing you cann
    advise? I get so much lately it’s driving me crazy so any assistance is very
    much appreciated.|
    Greetings! Very useful advice within this article!

    It is the little changes that make the largest changes. Thanks a lot
    for sharing!|
    I absolutely love your blog.. Great colors & theme. Did you create this amazing site yourself?
    Please reply back as I’m looking to create
    my own website and want to learn where you got this from or exactly what the theme is named.

    Cheers!|
    Howdy! Thhis post couldn’t be written any better! Reading through this post
    reminds me of my previous roommate! He constantly kept
    preaching about this. I most certainly will send this information to him.
    Fairly certain he’s gong to have a good read. Many
    thanks for sharing!|
    Amazing! This blog looks exactly like my old one!

    It’s on a entirely different subject but it has pretty much the same page layout and design.
    Great choice of colors!|
    There’s definately a lott to know about this topic.

    I really like all the points you have made.|
    You made some good points there. I chcked on the net to find out
    more about the issue and fojnd most individuals will go along with your views on thhis web site.|
    Hello, I check your blogs like every week. Your writing style is awesome, keep
    it up!|
    I just couldn’t leave your website prior to suggesting that I actually enjoyed
    the standard info an individual supply on your visitors?
    Is gonna be back incessantly to check out new posts|
    I needed to thank you for this good read!! I absolutely enjoyed every little bit of it.
    I have you book-marked to check out new stuff you post…|
    What’s up, just wanted tto tell you, I loved this blog post.
    It was practical. Keep on posting!|
    I leave a response when I appreciate a post on a blog or if I have
    something to contribute to the discussion. Usually it is triggered by the passion communicated in the post I looked at.
    And onn this article Itimag.com

  • octubre 4, 2013 a las 11:05 am
    Enlace permanente

    Thank you for the auspicious writeup. It actually was a
    enjoyment account it. Look complex to far introduced agreeable from you!
    However, how can we keep in touch?

    Visit my web site: recommended reading for middle school (Cecilia)

  • octubre 5, 2013 a las 4:50 pm
    Enlace permanente

    Kellogg’s Cereal created an altruistic campaign on their Fb web
    page known as «Kellogg’s Cares» the place they donate meals, educate younger folks about proper nutrition and work to scale
    back international malnutrition. They’ve a partnership with Feeding America – the nation’s leading domestic starvation-relief charity.
    Facebook Marketing Strategy

  • octubre 7, 2013 a las 1:07 am
    Enlace permanente

    We have been a small grouping of volunteers as well as cracking open a completely new plan within our neighborhood. Your website supplied us all with useful info to operate upon. You have done a notable task and the overall location should be happy to your account.

  • octubre 10, 2013 a las 4:01 am
    Enlace permanente

    I’m not that much of a internet reader to be honest but your sites really nice, keep
    it up! I’ll go ahead and bookmark your website to come back later on. Cheers

  • octubre 12, 2013 a las 4:46 pm
    Enlace permanente

    Definitely consider that which you said. Your favourite justification appeared
    to be on the internet the simplest thing to be mindful of.
    I say to you, I definitely get irked while other folks think
    about worries that they just don’t recognise about. You managed to hit the nail upon
    the highest as well as defined out the entire thing without having side-effects , folks can take a signal.
    Will probably be back to get more. Thank you

    Feel free to surf to my website pregnancy tips (Hildegard)

  • octubre 28, 2013 a las 6:27 am
    Enlace permanente

    Definitely consider that which you stated. Your favourite justification seemed to be on
    the net the easiest thing to have in mind of.
    I say to you, I certainly get irked even as other folks consider
    worries that they just don’t recognise about.
    You managed to hit the nail upon the top and outlined out the entire thing without having side effect ,
    folks can take a signal. Will probably be again
    to get more. Thanks

    my web site: best carpet cleaning machines (Natisha)

  • noviembre 13, 2013 a las 10:02 am
    Enlace permanente

    Hi there, I check your new stuff like every week.
    Your humoristic style is witty, keep doing what you’re doing!

    liberty slots casino bonus codes (Michel)

  • noviembre 13, 2013 a las 4:32 pm
    Enlace permanente

    I’m not that much of a online reader to be honest but your sites really nice, keep it up!

    I’ll go ahead and bookmark your website to come back in the future.
    Many thanks

  • noviembre 14, 2013 a las 3:23 pm
    Enlace permanente

    It can be really an excellent in addition to valuable piece of data. We’re pleased that you contributed this beneficial information and facts around. You need to keep us up to date like this. Appreciate your discussing.

  • noviembre 29, 2013 a las 1:30 am
    Enlace permanente

    Very good info. Lucky me I found your blog by accident (stumbleupon).
    I’ve bookmarked it for later!

  • diciembre 6, 2013 a las 7:06 am
    Enlace permanente

    Hi, Neat post. There’s an issue along with your web site in internet explorer, could check this?
    IE nonetheless is the marketplace chief and a big component of other
    people will leave out your great writing because of this problem.

    Feel free to surf to my web site: where to get garcinia cambogia extract [blog.travelpod.com]

  • diciembre 24, 2013 a las 9:24 am
    Enlace permanente

    This application allows you to store your usernames, your passwords, your bank account numbers and PINs and anything
    else that you need to store a password for. Truth be told, such a large amount of local storage is counter to the
    whole idea of Chrome OS — not to mention that the slow spin introduces a certain amount
    of unwelcome lag. Acer 3G Chromebook introduced in May is believed to be the potential of computing.

  • diciembre 24, 2013 a las 10:36 am
    Enlace permanente

    Can I just say what a relief to discover a person that really knows what they
    are talking about over the internet. You definitely know how to bring a problem to light
    and make it important. More people should read this and understand this side of your story.
    It’s surprising you are not more popular since you certainly possess the
    gift.

  • diciembre 28, 2013 a las 6:52 am
    Enlace permanente

    Es perfecta tu explicación. Tienes toda la razón es que cuando se instala el oracle el tnsname.ora esta apuntando a otra dirección.

    Una pregunta

    Si ya logro entrar en el form con un usuario; entonces porque puedo visualizar todos los objetos de otros usuarios o esquemas diferentes?

    Saludos desde Panamá

  • enero 23, 2014 a las 4:11 am
    Enlace permanente

    I am just highly amazed as well as your crafting abilities seeing that intelligently like with the dwelling on your web site. Is that this a new settled theme or maybe does one alter that by yourself? At any rate carry on the nice good quality crafting, it really is rare to search a terrific weblog just like it nowadays.

  • enero 31, 2014 a las 6:30 am
    Enlace permanente

    My sister was older, and didnt want anything to do with me, not in the conventional
    sense anyway. In those family discussions, make sure
    the kids get a clear message that the decision is coming from both of you and that you are
    in agreement.

  • marzo 2, 2014 a las 12:58 pm
    Enlace permanente

    Hello there! Do you know if they make any plugins to safeguard against hackers?

    I’m kinda paranoid about losing everything I’ve worked hard
    on. Any suggestions?

  • marzo 5, 2014 a las 2:10 pm
    Enlace permanente

    Hi there, I have seen that on occasion this webpage displays a 500 server error message. I thought that you would like to know. Regards

  • marzo 12, 2014 a las 11:28 am
    Enlace permanente

    The Lion feels lucky to have found such a good listener.
    For example, in «My Favorite Husband,» George has become to object
    of affection for young Sally Hopkins. He talks to his younger brother Imraan over the phone, explaining the idea and asking
    for his help.

  • marzo 17, 2014 a las 2:31 am
    Enlace permanente

    Review Opal Infotech assessment will allow you to to outsource web design providers.
    Making use of their facilities is possible via subscription,
    which implies paying a nominal amount, which allows an unbelievable freedom to download thousands of television shows from world over.
    We don’t want to read a book when it rains and the sale of
    books seem to have gone down a little, especially if the book is a collection of poetry.

  • marzo 21, 2014 a las 7:56 am
    Enlace permanente

    They are also the entry through which very many people enter their homes at the
    end of long days. That is why many people look to add
    windows to their garage door. Search the safe for some more credits before you go.

Deja una respuesta

Este sitio usa Akismet para reducir el spam. Aprende cómo se procesan los datos de tus comentarios.