1,655 reputation
1615
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 8 months
seen 2 days ago

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.


Oct
27
comment Unable to mount database: error reading control file
Trying things like replacing the files from your copies could make things worse. Do you have a recent control file backup (e.g. from backup controlfile to trace)? Is there a problem with the E: disk - have you verified the media itself?
Sep
30
awarded  Explainer
Aug
1
comment How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora
@GlennLong - but in your version, database is still a TNS alias, which has to exist in the tnsnames.ora, so it's the same as Louis was trying to avoid?
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
@Oliver - Which error - 'does not currently know of service'? Did you change the tnsnames.ora to have SID = asdb?
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
No, I'd already said to create it in a different directory. Example added.
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
OK, so what is the service name? Can you see it from Toad, e.g. select value from v$parameter where name = 'service_names'? If you don't have privs to do that you'd need to ask your DBA. Or use your own tnsnames.ora file, specifying the SID instead.
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
That's the same service name you proposed for the tnsnames.ora entry. So it is actually the SID? How do you connect through Toad, with a device name or a SID? Do you know the actual service name of the database?
Jul
31
answered How to create an oracle dump(.dmp) file using Toad?
Jul
8
comment ORA : 12519 No appropriate Service Handler
You don't need both SID and SERVICE_NAME. This ought to work with just the service name.
Jul
7
comment ORA : 12519 No appropriate Service Handler
Cross-posted on SO; that might be migrated here soon though.
Jun
25
comment Why does second instance of database not open?
Did you copy all the .dbf and .log files from test to orcl; and if so was test up at the time? What does your new init.ora look like? It might be useful to show the steps you went through in the order you did them.
Jun
11
comment Inner Join Performance
Please don't post the same question on multiple sites. There's a FAQ about this on meta.
May
27
comment How to startup a oracle database with sql plus or with any developer tool without connecting to the Database
How are you connecting (or trying to) at the moment? Are you sure the database is down and you have the right service name? Can you access the database server to check lsnrctl services or connect to the database locally, which you'll need to be able to do to start the database if it is down?
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
I don't think you're quite getting to that point; looks like it would be after the connection is established, not during connection. Still means you can't use it of course, but doesn't explain what you're seeing. Maybe it is setting the user/password explicitly earlier, or doing something else weird.
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
@AmirAvarzamani - I agree, I just don't understand what you're seeing, if amir/amir is getting ORA-01017. Just a thought.
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
Do not grant anything to system, it has everything it needs - don't mess with built-in accounts or objects. For the other one you need at least grant create session to amir, which should let you log in to SQL*Plus. But I don't think that will resolve the ORA-01017 through WebGoat.
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
Passwords are case sensitive, but it looks like you're using the same case as when you created the user. Have you granted connect privs to the new user? That would get a different error though. Not quite sure what's going on now... you can connect as amir/amir through SQL*Plus, or other clients? Maybe the app you're using is overriding the credentials somehow, but not familiar with it.
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
And based on the other question you asked on DBA, does using amir/amir also get an ORA-01017?
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
@AmirAvarzamani - your TNS-12514 error is gone. Are Amir-PC and localhost the same machine - all of this is on your own box, and Amir-PC resolves to 127.0.0.1? Otherwise you might be looking at two databases, which would explain a lot, but seems unlikely you'd have missed that.
May
9
comment Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )
@AmirAvarzamani - what is ${USER} set to, also system/system? Is that actually your system password; and can you try it with other non-privileged credentials that you know work locally?