Hey guys so at work I've been task to make a VM for some classes at the School I work for. Pretty much I have to make a VM that has SQL developer which I was able to get started with no issues. The thing I'm struggling with is installing and getting is SQL*PLUS running and make it be able to use Scott/Tiger. I was able to get everything installed but every I try to log in with Scott/tiger i get the following error: "ORA-12560: TNS:protocol adapter error. I did the install the normal way just followed the prompts and what not. The sole purpose for this VM is so students can get to the Scott/Tiger tables and just use that and learn basics.
Last week we suffered block corruption, and other issues in one of our reporting databases. Long story short I had to spin up a new server. I'm looking a tools to purchase in order to nip problems like this in the bud. What tools do you guys use to monitor your databases?
Hey everyone! I’m trying to bring unit testing into my work and have hit a little roadblock. The client I do Oracle/PLSQL work for provided me with SQL Developer Vs 1.5 running oracle 11g and as far as I can tell unit testing isn’t available in that version of SQL developer. I’m also restricted so I can’t use any unit test platform that requires me to create new users or grant privileges.
Am I out of luck? Or is there something available that I can download and use that doesn’t require a purchase (as I don’t have the authority to purchase anything). Thanks!
I am a sql developer who works primarily in Oracle (i do a few odd jobs in MS SQL Server for another client) and I want to get better at what I do.
When I took my job here I had no experience in SQL other than teaching myself SQL and doing a few small reports at my last position. 2 years in, I've learned a lot but I want to learn more. I want to get better at both designing database structures as well as writing code, performance tuning, etc etc.
Any tips on where to go from here? Things I can do outside of work to increase my skills?
I'm using the Oracle format mask on a field to output a value exceeding a million. Whenever I output the BI with xml data, I'll always get an exponential value. I tried this on version PeopleTools 8.54. But the same BI, whenever I run it on 8.55, I'll get the right amount. Can someone clarify this for me, please. Thanks.