<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=2205571685581136471&zx=985360b5-a9ff-49b6-b10b-22e8735bb478' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=2205571685581136471&zx=985360b5-a9ff-49b6-b10b-22e8735bb478' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

</head><body>*/</style>

SP2-0310: unable to open file "marker_status.sql"

Hey there,

So, I've been running this script and ran into a bit of a snag. No worries though, I managed to sort it out by setting some environment parameters. This script is supposed to work under the Golden Gate directory.

I fired up an SQL session as the system DBA:

SQL> conn / as sysdba
SQL>@/ora/oracle/ggs12/marker_setup.sql

This triggers a script for setting up markers. It asks for the name of a schema for the Oracle GoldenGate database objects. Just make sure you've created the schema before running this script, and don't forget to stop all DDL replication before getting started.

Here's a snippet of how the interaction goes:

Enter Oracle GoldenGate schema name: gguser
...
...
...

Enter Oracle GoldenGate schema name: ggate

After all that, it finishes up with the message:
Marker setup table script complete, running verification script...
SP2-0310: unable to open file "marker_status.sql"
Script complete.

Now, for the command-line part, I did a few exports to set up the environment correctly. Check it out:

$ echo $ORACLE_HOME
/ora/oracle/app/oracle/product/12.1.0/dbhome_1
$ export ORACLE_HOME=/ora/oracle/app/oracle/product/12.1.0/dbhome_1
$ export PATH=$ORACLE_HOME/bin:$PATH
$ export ORACLE_SID=orasap
$ export PATH=/ora/oracle/ggs12:$PATH
$ export LD_LIBRARY_PATH=/ora/oracle/ggs12:$ORACLE_HOME/lib
$ pwd
/ora/oracle/ggs12

Then I hopped into SQLPlus:

SQL*Plus: Release 12.1.0.1.0 Production on Sat May 2 02:52:47 2020

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing options

SQL> !pwd
/ora/oracle/ggs12

SQL> @marker_setup.sql

Again, it prompts for the GoldenGate schema name, so just provide that. Once you've got that set, it completes the process with a success message:

Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGUSER

MARKER TABLE
-------------------------------
OK

MARKER SEQUENCE
-------------------------------
OK

Script complete.

Hope that helps you out! Let me know if you need more assistance.

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/591462033-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4BT4Z0M992Q5vW2rRQgBlilaJCgg:1696140793197';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d2205571685581136471','//www.webmasterbn.xyz/2020/05/sp2-0310-unable-to-open-file.html','2205571685581136471');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '2205571685581136471', 'title': 'WebMasterBN', 'url': 'https://www.webmasterbn.xyz/2020/05/sp2-0310-unable-to-open-file.html', 'canonicalUrl': 'https://www.webmasterbn.xyz/2020/05/sp2-0310-unable-to-open-file.html', 'homepageUrl': 'https://www.webmasterbn.xyz/', 'searchUrl': 'https://www.webmasterbn.xyz/search', 'canonicalHomepageUrl': 'https://www.webmasterbn.xyz/', 'blogspotFaviconUrl': 'https://www.webmasterbn.xyz/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-576V0GEHVM', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'en-GB', 'localeUnderscoreDelimited': 'en_gb', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22WebMasterBN - Atom\x22 href\x3d\x22https://www.webmasterbn.xyz/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22WebMasterBN - RSS\x22 href\x3d\x22https://www.webmasterbn.xyz/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22WebMasterBN - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/2205571685581136471/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22WebMasterBN - Atom\x22 href\x3d\x22https://www.webmasterbn.xyz/feeds/8012358502245162704/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/2d0a24a4c015fadb', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en_GB\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '8012358502245162704', 'pageName': 'SP2-0310: unable to open file \x26quot;marker_status.sql\x26quot;', 'pageTitle': 'WebMasterBN: SP2-0310: unable to open file \x26quot;marker_status.sql\x26quot;', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard', 'ok': 'Ok', 'postLink': 'Post link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'SP2-0310: unable to open file \x26quot;marker_status.sql\x26quot;', 'description': 'The Largest Educational Website For Students.', 'url': 'https://www.webmasterbn.xyz/2020/05/sp2-0310-unable-to-open-file.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8012358502245162704}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': 'WebMasterBN (Header)', 'type': 'Header', 'sectionId': 'upload-image', 'id': 'Header1'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '8012358502245162704', 'title': 'SP2-0310: unable to open file \x26quot;marker_status.sql\x26quot;', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags:'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Tags:'}]}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML3'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'Email about celebration of Victory Day at school', 'id': 8395001414986934139}, {'title': '\u0987\u0995\u09cb\u09a8\u09cb \u09ac\u09be\u09b8 \u09b8\u09be\u09b0\u09cd\u09ad\u09bf\u09b8 | \u09a2\u09be\u0995\u09be\u09b0 \u09b8\u0995\u09b2 \u0995\u09be\u0989\u09a8\u09cd\u099f\u09be\u09b0 \u09ae\u09cb\u09ac\u09be\u0987\u09b2 \u09a8\u09be\u09ae\u09cd\u09ac\u09be\u09b0 | Econo Service', 'id': 1919783831416606577}, {'title': 'Email about recent visit to Paharpur', 'id': 7704414963026159312}, {'title': 'Composition writing : A Summer Night ', 'id': 8411793021024821985}, {'title': 'Median UI v1.4 Blogger Template by Jago Design', 'id': 6612269768874628443}, {'title': 'Fletro Pro v5.5 Blogger Template', 'id': 7331171276827411911}, {'title': 'Find out Broken Links and Fix it', 'id': 6523089933061219901}, {'title': 'INTERNET PARAGRAPH Jsc,Ssc,Hsc', 'id': 4409256247467199692}, {'title': ' TREE PLANTATION PARAGRAPH JSC SSC HSC', 'id': 5990781142372435060}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'upload-image', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/392051530-lbx__en_gb.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3268905543-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'sidebar-static', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>