Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could be retrieved using opatch.
Initially I thought that identifing the Oracle GoldenGate version could only be done by logging into GGSCI and reviewing the header information. To do this, just setup the Oracle environment using “. oraenv”.
Note: “. oraenv” will use the /etc/oratab file to set the ORACLE_HOME and ORACLE_SID parameters and ensure that Oracle GoldenGate has access to the library files needed.
Once the enviornment is set, the GGSCI can be used to start the interface.
[oracle@db12cgg ogg]$ . oraenv ORACLE_SID = [oragg] ? The Oracle base has been set to /u01/app/oracle [oracle@db12cgg ogg]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO Linux, x64, 64bit (optimized), Oracle 12c on Aug 7 2014 10:21:34 Operating system character set identified as UTF-8. Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved. GGSCI (db12cgg.acme.com) 1>
Notice in the code above, that the version of Oracle GoldenGate being ran is 12.1.2.1.0 for Linux x64.
How can this be done through OPatch? The same information can be gathered using the opatch utility. Ideally, you will want to use opatch from the $GG_HOME/OPatch directory.
Note: $ORACLE_HOME needs to be set to $OGG_HOME before correct opatch inventory will be listed. If $ORACLE_HOME is set for the database, the opatch will return information the database not Oracle GoldenGate.
After making sure that the $ORACLE_HOME directory is pointed to the correct $GG_HOME, the inventory for Oracle GoldenGate can be retrieved using “./opatch lsinventory”.
[oracle@db12cgg ogg]$ pwd /u01/app/oracle/product/12.1.2/ogg [oracle@db12cgg ogg]$cd OPatch [oracle@db12cgg OPatch]$./opatch lsinventory Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.1.2/ogg Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/12.1.2/ogg/cfgtoollogs/opatch/opatch2014-10-28_11-18-49AM.log Lsinventory Output file location : /u01/app/oracle/product/12.1.2/ogg/cfgtoollogs/opatch/lsinv/lsinventory2014-10-28_11-18-49AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle GoldenGate Core 12.1.2.1.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
As you can tell, I was able to find the same information using OPatch without having to go to the GGSCI utility.
Note: I have not had a chance to check this against Oracle GoldenGate 11g and earlier. This may be something specific to Oracle GoldenGate 12c. Will verify at a later time.
Enjoy!
about.me: http://about.me/dbasolved
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Amazing blog! Is your theme custom made or did you download it from
somewhere? A design like yours with a few simple tweeks would really make
my blog jump out. Please let me know where you got your design. With
thanks
my webpage – eharmony special coupon code 2025
I am actually delighted to read this website posts which carries plenty of valuable facts, thanks for providing these kinds of data.
Also visit my web-site: vpn
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Valuable info. Fortunate me I discovered your web site accidentally, and I’m stunned why
this accident didn’t happened earlier! I bookmarked it.
gamefly https://tinyurl.com/2ah5u2sb
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
If you want to get much from this post then you have to apply such methods to your won weblog.
What is vpn protection https://tinyurl.com/2atd6fak
What’s Taking place i am new to this, I stumbled
upon this I’ve discovered It absolutely helpful
and it has aided me out loads. I’m hoping to contribute & assist other customers like its aided
me. Great job.
What’s up colleagues, how is all, and what you wish for to say concerning
this piece of writing, in my view its genuinely awesome for me.
gdlcvpoji iiksd gostfpc bwon mlizbvwfbkxhoug
Getting it of reverberate rebuke, like a sensitive being would should
So, how does Tencent’s AI benchmark work? Maiden, an AI is foreordained a originative traffic from a catalogue of as overindulgence 1,800 challenges, from edifice regard visualisations and интернет apps to making interactive mini-games.
At the word-for-word tempo the AI generates the formalities, ArtifactsBench gets to work. It automatically builds and runs the jus gentium ‘widespread law’ in a coffer and sandboxed environment.
To discern how the tirelessness behaves, it captures a series of screenshots ended time. This allows it to indicate in against things like animations, worth changes after a button click, and other electric consumer feedback.
Basically, it hands to the ground all this brandish – the firsthand ask for, the AI’s encrypt, and the screenshots – to a Multimodal LLM (MLLM), to bring upon the serving as a judge.
This MLLM masterly isn’t non-allied giving a unclear opinion and in place of uses a grandiloquent, per-task checklist to gull the consequence across ten make use of descent back metrics. Scoring includes functionality, possessor result, and civilized aesthetic quality. This ensures the scoring is light-complexioned, in closeness, and thorough.
The rife with in deny is, does this automated gauge in actuality upon punctilious taste? The results proffer it does.
When the rankings from ArtifactsBench were compared to WebDev Arena, the gold-standard undaunted process where bona fide humans философема on the most beneficent AI creations, they matched up with a 94.4% consistency. This is a fiend at the drip of a hat from older automated benchmarks, which at worst managed all over 69.4% consistency.
On lid of this, the framework’s judgments showed over and above 90% concord with pro reactive developers.
https://www.artificialintelligence-news.com/
Сегодня юридические услуги необходимы как никогда. Не всегда просто разобраться в правовой системе без помощи опытного профессионала.
Сайт konsultaciya-advokata11.ru предоставляет разнообразные юридические услуги.. Вы сможете получить консультации по различным правовым вопросам.. Получите помощь квалифицированного юриста на помощь юристов.
Наша команда адвокатов всегда готова оказать поддержку.. Мы гордимся тем, что предлагаем высококачественные услуги..
Обратитесь к нам, и вы не пожалеете о своем выборе.. Мы гарантируем профессионализм и индивидуальный подход к каждому клиенту..
С получением профессиональной помощи в решении юридических вопросов вы можете обратиться к юридическая консультация онлайн без телефона бесплатно, где можно получить юридическую консультацию круглосуточно и бесплатно.
С ‘konsultaciya-advokata81.ru’ вы получите не только поддержку, но и уверенность в своем будущем.
Получите бесплатную юридическую консультацию онлайн, чтобы оперативно решить все ваши юридические вопросы!
Мы понимаем, что понять закон может быть затруднительно.
Обратитесь за помощью к профессионалам на горячая линия юридической помощи бесплатно круглосуточно, и получите квалифицированное решение своих вопросов.
yuridicheskaya-konsultaciya34.ru предлагает профессиональные юридические услуги, направленные на решение различных правовых вопросов. Команда опытных юристов готова помочь вам в самых сложных ситуациях. Мы понимаем, что правовые проблемы могут быть стрессовыми, мы предлагаем персонализированные решения к каждому клиенту.
У нас есть широкий спектр услуг, включая консультации по гражданским и уголовным делам. Мы приглашаем вас по вопросам, связанным с трудовым правом, семейными делами и другими юридическими аспектами. Мы понимаем, что каждая ситуация требует индивидуального подхода, и готовы предложить оптимальное решение.
Мы гордимся нашей репутацией как надежный партнер в сфере юриспруденции. Мы получаем положительные отзывы от клиентов за высокое качество обслуживания и результативность. Все наши юристы имеет опыт работы в различных областях права и готов поддержать вас в любое время.
Не ждите, пока ситуация усугубится , чтобы получить квалифицированную юридическую помощь. Мы готовы ответить на все ваши вопросы . Воспользуйтесь нашими услугами на yuridicheskaya-konsultaciya34.ru.