logs archiveIRC Archive / Freenode / #oracle / 2015 / August / 4 / 1
dsdel
wensia: easiest trick without knowing ANYTHING like your os or so: sqlplus / as sysdbaq
sqlplus / as sysdba
wensia
dsdel: yep I did that
then startup
dsdel
ah ok then your oracle is up and running - and no normally oracle does not listen somewhere
the 'listen for connections' is done by the tns listener
wensia
dsdel: thing is I can't access it through sqldeveloper, which is what i'm trying to do
dsdel
what connection type have you selected in sqldeveloper?
that where you can specify the host, port and sid? or the one with tns?
sorry got it at work, not here therefor i do not know the exact labels of sqldeveloper
you are on windows?
wensia
im on ubuntu
using the one with host port sid
dsdel: ^
dsdel
and exact error? must be something like tns-xxxx or ora-xxxxx
host: local, port: 1521 (default), sid: XE (if you have xe installed)
wensia
yep
Connected. SQL> startup ORA-01081: cannot start already-running ORACLE - shut it down first
dsdel
the error of sqldeveloper at connect time pls
         

wensia
dsdel: look this http://pastebin.com/Fd3ffvYq
dsdel
simply try:
lsnrctl start
sqlplus / as sysdba
alter database register;
sorry alter system register;
then exit and lsnrctl status
but check that you have set your oracle environment with: . oraenv
wensia
this is the error of sqldeveloper
An error was encountered performing the requested operation: IO Error: The Network Adapter could not establish the connection Vendor code 17002
dsdel
try above, brb :)
wensia
dsdel
seems hat you are below the wrong user
wensia
dsdel: what user do I need to user
to use
dsdel
not sure, not used oracle on linux for a while
but root should do the trick, therefor you are on ubuntu and if you haven't elevated to root you are forced to sudo everything
wensia
lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-AUG-2015 01:07:02 Copyright (c) 1991, 2005, Oracle. All rights reserved. Message 850 not found; No message file for product=network, facility=NL LSNRCTL>
dsdel:
dsdel
start
oh you haven't set the oracle environment.
do the following:
change to root
. oraenv
lsnrctl start
wensia
dsdel: sorry?
I need to sudo, cant' change to root user
sudo .oraenv
??
PeterFA
How do I mimic "sqlplus / as sysdba" assuming that that user / has a right to log in on the network, on a different computer (say, from some other SQL client?)
Or is that not possible.
That / isn't a user.
sigdk
hi. I want to patch oracle DB 11.2.0.4 with the latest patches and bugfixes. I ended up here: http://www.oracle.com/technetwork/topics/security/alerts-086861.html
I have 2 questions
1) Are these the only patches I can apply ? Cause it looks like it's only the security related patches
2) The patches read: "Critical Patch Update patches are usually cumulative..." does this mean that I only need to apply the latest or I have to apply them all one by one ?
petteja
yeah, they are cumulative, so you only need the latest
if you apply the psu rather than the cpu, you also get critical bug fixes in addition to the security patches
sigdk
petteja, where can I find the "psu" ones ?
petteja
http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html click on database and you'll get redirected to my oracle support
sigdk
petteja, but these are cpu updates...
petteja
if you log in to oracle support youll find the psu there as well
sigdk
petteja, good, thank you
petteja
Combo OJVM PSU 11.2.0.4.4 and Database SPU 11.2.0.4 (CPUJul2015) Patch 21150829
for instance
         

freakolowsky
is this the right channel to ask a ojdbc question?
MrZeus
freakolowski: I'd just ask and see what happens.
freakolowsky ^
hlavaty
is there a way to split oracle installation into read-only part and rw part? I would like to have ORACLE_HOME read-only and specify TNS_ADMIN and ORACLE_BASE as rw. i'm struggling with that, oracle somehow wants to write in read-only locations under ORACLE_HOME no matter what i do
freakolowsky
k ... so the question: with ojdbc you used to CLOB.createTemporary static method to create a temporary LOB where you could specify it's duration (CALL or SESSION). This class is now deprecated and you have to use java.sql.Clob. All cool, but now i'm unable to set LOB duration to CALL and i'm hitting temporary tablespace limit as my connection(session) does not reset often.
is there a way to set temporary default lob duration?
s/temporary default lob/temporary lob default/
the only alternative i see is manually freeing all temporary clobs but for that i'd have to remember all Clob objects in a batch to free them once i execute the batch
dsdel
hlavaty: every diagnostic destination is set to oracle home by default. additional the spfile/initfile reside there.. I would never try that
beside the question why someone should want to do this.
hlavaty
dsdel: ok thanks
but i think it should be possible
there is for example diagnostic_dest
freakolowsky
dsdel, although i too wonder why would anyone want to do that ... you can relocate spfile and pfile ... but there are some tools that ignore those parameters when writing logs, like for instance EM and then there's ASM, clusterware ... not everything goes into diagnostic-dest
i'd shelve that idea into "there be dragons" section
petteja
its often best to stick to the default defacto standard
easier when it comes to do follow documentation and if you need help from oracle
freakolowsky
petteja, easier ... sure, best ... not so much especially with crappy documentation like oracle's
petteja
if you work as a consultant, its more consistent between customers then :P
dsdel
freakolowsky: sure, you can do everything. but i would also not try to get my /bin and /etc rw or my c:\windows
:D
freakolowsky
dsdel, hey i'm saying NOT TO make ORACLE_HOME ro ... windows is a good comparison, but /bin & /etc isn't, because as long as you do not change configuration, install new or upgrade software, that's totally legal ... blackbox systems do that
hlavaty
ok, so diagnostic_dest should have deprecated user_dump_dest but not really; there is still something that needs user_dump_dest contradicting oracle documentation
dsdel
freakyGone: ye.. you're right. if the software is correct and so on. sadly to less but let's say /opt :D
hlavaty: user/background_dump_dest - the listener ADR and so on
hlavaty
yeah i need to wrap my head around it
dsdel: i specified user_dump_dest and it went further
dsdel
the only thing what makes sense is to use lsof to get these, insert a symlink where it writes to and redirect the folder this way. but hell, do not ask me what side effects you will get
hlavaty
now startup nomount pfile="foo"; cannot create lock; no idea where this lock is located, log files dont tell any path
dsdel
you need to redicat the pfile with an empty file and one statement: ifile=<pathtorealpfile>
redirect...
hlavaty
dsdel: what for?
i mean, i dont have problem with pfile, that seems to work fine; now i'm trying to find out what lock is startup trying to create
maybe /var/lock/subsys/listener
dsdel
ah
heh hf :)
« prev 1 2 next »