logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 5 / 1
davo
hi all. I'm trying to create a synonym "SQL> CREATE SYNONYM numgen FOR my_first_seq;" and getting error: "ERROR at line 1: ORA-01031: insufficient privileges". any ideas on how i can fix privileges would be appreciated.'
usn
davo, maybe "create synonym"?
oh, of course I am talking about a grant for your user
davo
usn, yes i think i need to grant the priviledge for my user
usn
you think right :)
davo
awesome! so what would be the command to grant my user the privilege to create the synonym?
usn
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9013.htm#SQLRF01603
davo
usn, ah, i had to log in as system admin and "GRANT create synonym TO my_user" thank you!
it worked :) thank you so much
usn
np, but anyway, have a look at the docs
http://www.oracle.com/pls/db102/homepage is you best friend
davo
ah yes, i'll keep it handy at all times. thanks for the link usn
         

usn
np, good night. Have to go now.
good luck
nunovsky
hey
replace(char,str1,str2) , what is the difference between a char and a string ?
a string is a group of chars?
SilSila
i want to use the sql*loader from the oracle 10g db's enterprise manager from my local pc..but how can i select the dat file from my localpc? am i have to copy the dat file in the server only? is it possible to load the data from my local pc?
dsdel
Nunovsky: char = 'A'; string = "ABCD"; so basically a string is an array of chars, so char[]
but cause of memory allocation/deallocation there is a huge difference between those 2 types
fore the frontenduser it is just char is one single char and string are many chars together
SilSila: if there is no option I assume that you need to upload it to the server :)
SilSila
is it possible to install sql*loader alone in my local pc?
then can i connect to the server?
dsdel
Load data across a network. This means that a SQL*Loader client can be run on a different system from the one that is running the SQL*Loader server.
official oracle answer :>
but for 11g, never used it till now hehe
SilSila
dsdel: so load data across a network is possible?
dsdel
http://my.opera.com/onyxluo/blog/2007/12/28/add-sql-loader-into-oracle-10-instant-client
google helps :)
SilSila
thanks...
Nunovsky
hmm ok
ty
sinesio
Hi guys, I'm trying to duplicate my DB for a standby DB using ASM on both DBs
but running rman I'm having some problems
can you identify some problem in my rman commands: http://tinypaste.com/c10b2
RJarett
are you licensed fully for the 2nd db?
sinesio
i'm running a lab environment... but for production I have all licenses
but I have to test it first on the lab
and for what oracle told me I don't need the licenses for the lab environment
RJarett
yeah not exactly true
sinesio
I was able to do the RMAN backup for standby using FS, but now with ASM I'm having some problems and RMAN gets stuck in 'Starting backup at XXXX'
I don't think the licenses have anything to do with that... but don't know for sure
by the way I'm using 11gR2
Spec
Anyone here tunnel tns/listener traffic over ssh tunnels?
Dormir
Spec: did at one time, but it's been awhile
Spec
hrm.
I'm having an issue with ssh-tunneling-the-traffic to a windows box running oracle (listener gets/establishes the connection...but the client gets 'connection timed out')
but when a linux boxen is running the oracle, it works just fine
and i can ssh tunnel in the internal network, and even *that* works fine. just not across my two networks.
Dormir
should work similarly
you're connecting to a windows box running ssh?
the ssh server on Windows is configured the same way the linux one is?
Spec
yeap
but i've tried it both ways
bouncing off a linux host within the same network as the windows box
as well as directly connecting to the windows box running opensshd
I don't really see why it should fail, so, debugging this is gonna be hard. :)
         

Dormir
turn on debugging within sshd
Spec
it's annoying, especially since I can tnsping the tunnel and it works (and i see the ping attempt on the listener log)
Dormir: i have
Dormir: the debug statements look correct
Dormir
you may have to set local_listener
Spec
oki
Dormir
man, I know I've seen this...
Spec
would pmon logs show the retries?
and/or failure, if pmon is the culprit/
Dormir
hmmm...this isn't the solution I used, but it may work
tcp.validnode_checking = yes
TCP.INVITED_NODES=(192.168.1.45) --> server IP address
set that in the server's sqlnet.ora
Spec
what needs to get restarted for that to take affect?
Dormir
what error are you getting when you try to connect?
Spec
Dormir: none, just times out.
but i see the established connection the listener logs
Dormir
don't think you need to restart anything
« prev next »