New answers tagged

0

Your code page is 936 (Chinese). When you start SQL"Plus then this code page is inherited from CMD. Usually you have two possibilities: Set NLS_LANG according to your code page (either as Environment Variable or in Registry). Example set NLS_LANG=.WE8MSWIN1252 for a PC in Central Europe, the language and territory information do not matter for character ...


0

Most likely you corrupted your database and you should consider to make a full restore from backup. ALTER DATABASE CHARACTER SET ... was supported till Oracle version 9 and worked only at certain conditions. Never use clause INTERNAL_USE or make any updates on Oracle system tables unless you are advised by Oracle Support. If you like to change the ...


3

As you haven't shown us the sql files I'm going to take a guess that you haven't included the exit statement. This means that SQL*Plus will be invoked, run the commands/sql in the first file and then sit there waiting for the next SQL command. This means the 'sleep 2' command is never reached. Try this in your sql file instead update db.table_name set ...


1

To expand a bit, it is what is referred to in the previously cited doc as a 'net service name'. Let's say you have a database instance named 'orcl'. On the client server you'd have a tnsnames.ora file with an entry (net service name) something like this: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mydbservername)(...


0

Had a similar issue, myself, where my app could connect from Visual Studio, but not when published to a server. Nothing here resolved it for me, though zaratustra's post helped, but so I thought I'd link to my post - ORA-01017: invalid username/password;logon denied - to show how to troubleshoot these - or at least, how I did, before I gave up and posted my ...


0

It refers to connection info stored in a tnsnames file, check pages like this for more info.



Top 50 recent answers are included