logs archiveIRC Archive / Freenode / #oracle / 2015 / August / 21 / 1
PeterFA
I have a view that appears in all_tables but not in all_views. You'd think that would mean it's a table, but I cannot update on it.
lng
Hi! I'm trying to export a DB via command line and having 'bash: exp: command not found' error. What do I need to install?
the user is root and it's in dba group
hali
maybe just sort out your $PATH?
realtime
I want to change the sysdba password but I can't even start this 'sqlplus' sh*t. here a very brief log of what I tried, it doesnst start: http://pastebin.com/Y32pdvM9
on the intyernet everyone just says "sqlplus "/ as sysdba", but also doenst work
I'm so lost. I never did oracle, it's all different. I just want to be able to log into the database and pull their data into my system (a migration(
but my IDEA IDE says I mjust connect as sysdba for whatever reason
dbfuse
realtime, paste it in pastebin
realtime, create user blah identified by foo; grant create session to blah; grant create resource to blah;grant select_catalog_role to blah;
realtime, fire up IDEA and connect as blah
realtime
where should I type "create user blah identified by foo"?
I mean, my question is, how to start up sqlplus
it's a linux machine
dbfuse
realtime, do you have db running locally
realtime, which sqlplus; cd /u01; find . -name "*sqlplus" ; export ORACLE_HOME=<From the path>;export PATH=$ORACLE_HOME/bin:$PATH; sqlplus "/ as sysdba"
realtime
think I'm almost there. but you sdeparated the cmds with ; by convenience, right? I get errors. only seems to have worked liek this: http://pastebin.com/w8HiqJjy
buuuut I'm not being able to liog with blah:foo, so maybe it didnt work
log in*
the error I talk when using . is: http://pastebin.com/zZSs1SGt
"when using ;"*
(sorry if I seem confused. I actually programmed for some time but this Oracle/Apex is a paradigm so different from PG and other things I used)
ahh ok. have to use the ; but only 1 cmd per line.
I should have started a band. good grief I need to sleep.
ok, only "grant create resource to blah;" failed for missing privilege. but it worked
Thank you so much.
just like cheeser for Java and RhodiumToad for PostgreSQL, you are now my idol for Oracle.
thanks a million.
dbfuse
realtime, np
realtime, yes run them one by one.
realtime, one day at a time. Yeah starting band sounds better , I will join too.
         

realtime
it's a deal then :)
Realtime and the Ex-Programmers
dbfuse
RealXErs
realtime
nice!
MatheusOl
PeterFA: query dba_objects/user_objects and see the object_type, perhaps it is a materialized view (in which case you'll see a table too)
realtime
I have an user in Apex which I always used but now it simply says 'it's locked' whenever I try to log in. if I try on sqlplus: "alter user PRD account unlock;" it says users doesn't existe. curiously, if I put the same command but with the schema (to which the user belong to) I dont get an error
like "alter user PRD_PASSE_LIVRE account unlock; -> works. but it's an schema. I want to unlock the user PRD
there's an option to reset the password
but I dont know which email it's registered to
(this madness just felt on my lap, I'm all lost)
if I could unlock the user, find/change it's email.... anything would help....
MatheusOl
realtime: select account_status from dba_users where username = 'PRD';
dbfuse
realtime, https://community.oracle.com/thread/634299
its all madness or survival
oradarwin
realtime
dbfuse, just about that question before. I'm using the blah:foo you kindly helped me create. after some more fighting I was able to connect on the DB with the Oracle SQL Developer.... But for some reason it's like I'm navigating in a blank database... no tables or anything... maybe it needs some permission?
dbfuse
realtime, grant dba to blah;
realtime, then using sqldeveloper navigate to the user and you can see all objects.
realtime
hm didnt work.... but I managed to change the sysdba password, and this guy can do sh*t!
thanks anyways!
dbfuse
realtime, cool
realtime
hm... on sql developer I see like a million system-like looking tables... whereas sshing into the same ip then using sqlplus I can query the tables created by the developers
dbfuse
realtime, navigate to the user/schema
realtime
ok, that one was silly of me. thanks!
dbfuse
np
realtime
so, the last thing I need to do today is unlock this apex user.... see how I tried: WWV_MIG_ACC_USERS
oops
http://pastebin.com/cjKeM4LK
I'm sure the workspace name and user name are correct
dbfuse
It may not be a DB user its a workspace user.
select username from dba_users where username='PRD';
if no row then it is a work space user.
realtime
hmm how could I unlock him?
dbfuse
realtime, http://surachartopun.com/2013/05/the-account-is-locked-on-apex.html
set this to latest apex APEX_040200
also you may ask in apex forums I am not apex expert
realtime
yeeeees. thanks so much. You have no idea how much you helped
well, more than 2 million brl
         

dbfuse
realtime, you are welcome. Regards.
realtime
btw, do you work at oracle?
just so I tell the guys I had inside help ;D
dbfuse
i wish:-)
realtime
hehe ok
well, gtg, thanks again, cya!
dbfuse
https://dbfuse20.wordpress.com/
cya you can email me dbfuse20@gmail.com
if you get questions
realtime
how kind of you, I'll write it down! thanks thanks!
dbfuse
k