![]() However, this does work when connecting to other databases on other servers. Select * from V$INSTANCE shows that it is in MyDb and that both tool and db are 11.2.0.3Īttempt to access MyDb from same with SQL Developer, succeeds for "system" username, but fails for "sys" "as sysdba" with “ORA-01031:insufficient privileges”. Using SQL-Plus start menu option from same (sever, account and home), these also work: Enter user-name: as sysdba (ALSO: entering the wrong password works as well(!)) ![]() So does this one: D:\Oracle\app\product\11.2.0\dbhome_1\BIN>sqlplus as sysdba On this server, in my windows Admin account (also entered as server administrator in Oracle Admin Asst.), this DOS command works: D:\Oracle\app\product\11.2.0\dbhome_1\BIN>sqlplus as sysdbaĪnd, Select * from V$INSTANCE shows that it is in MyDb and that both tool and db are 11.2.0.3 However, I can connect using "system" with either SQL Plus or SQL Developer. The Problem: I can connect using "SYS As SYSDBA" from SQL Plus, but not from SQL Developer on the same system. I have done development on Oracle, but not much DBA work, and not in multi-homed environments like this. Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.I am a SQL Server developer/DBA consultant who is helping out a customer who recently lost their Oracle DBA. The Newsletter for PHP and MySQL Developers ![]() At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission. □ 5 Truths I’ve Come To Realize As a Self-taught Developerĭisclosure: Some of this blog post’s services and product links are affiliate links.Need hosting for your next web application or WordPress site? I highly recommend Hostinger and use them to host my niche bass fishing site.Get a handle on Google Analytics with this course by the folks over at The Content Technologist.Any of the Web Squadron Mastery Modules can help you with your online web entrepreneurial endeavor(s).Use those practices that best benefit your needs and goals. Your particular goals and needs may vary. The majority, if not all, of the examples provided, is performed on a personal development/learning workstation-environment and should not be considered production quality or ready. They are not the utmost best solution(s). Among those, he shares a love of tabletop RPG games, reading fantasy novels, and spending time with his wife and two daughters.ĭisclaimer: The examples presented in this post are hypothetical ideas of how to achieve similar types of results. Other favorite activities find him with his nose buried in a good book, article, or the Linux command line. Josh Otwell has a passion to study and grow as a SQL Developer and blogger. To receive email notifications (Never Spam) from this blog (“Digital Owl’s Prose”) for the latest blog posts as they are published, please subscribe (of your own volition) by clicking the ‘Click To Subscribe!’ button in the sidebar on the homepage! (Feel free at any time to review the Digital Owl’s Prose Privacy Policy Page for any questions you may have about: email updates, opt-in, opt-out, contact forms, etc…)īe sure and visit the “Best Of” page for a collection of my best blog posts.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |