Today's Messages (on)  | Unanswered Messages (off)

Forum: Client Tools
 Topic: Help with tnsname.ora
Re: Help with tnsname.ora [message #678869 is a reply to message #678867] Sat, 18 January 2020 01:04
Michel Cadot
Messages: 66776
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The file in %ORACLE_HOME%\network\admin\sample is just an example of tnsnames.ora file to help you write yours.
The file used by the programs must be in %ORACLE_HOME%\network\admin.
You have 2 ways to build a valid tnsnames.ora:

1/ Copy the tnsnames.ora from sample directory into ?/network/admin, open it with notepad and create an entry using the example one

2/ Using the Oracle Network Configuration Assistant with one the 2 methods
2a/ Open a DOS box, verify that ORACLE_HOME and PATH are correctly set, type "netca"
2b/ Click on Windows "Start" button, scroll down to "Oracle..." folder, then to "Configuration and migration tools" and click on "Oracle Net Configuration Assistant"
then follow the screens.

Forum: Performance Tuning
 Topic: Database performance tuning (merged)
Database performance tuning (merged) [message #678870] Sat, 18 January 2020 04:52
mha2020
Messages: 2
Registered: January 2020
Junior Member
i am relatively new to the database tuning, kindly advise which books or manuals to read in order to efficiently tune the datAbase.
i had a word with few DBA'S and the took awr report but i cannot understand anything .
Kindly advice.
Database performance tuning [message #678871 is a reply to message #678870] Sat, 18 January 2020 04:58
mha2020
Messages: 2
Registered: January 2020
Junior Member
How to start learning on Oracle performace tuning, as i am new to this. I have little knowledge on DB creation, tablespaces.
What learning path should i follow to understand awr report and addm report.
Re: Database performance tuning (merged) [message #678872 is a reply to message #678870] Sat, 18 January 2020 05:41
Michel Cadot
Messages: 66776
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Detailed OraFAQ Forum Guide section, Performance Tuning paragraph
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

You can also have a look at Database Performance Tuning Guide.

[Updated on: Sat, 18 January 2020 05:41]

Report message to a moderator

Re: Database performance tuning (merged) [message #678874 is a reply to message #678870] Sat, 18 January 2020 06:48
John Watson
Messages: 8120
Registered: January 2010
Location: Global Village
Senior Member
I wouldn't focus on AWR or ADDM reports. Tuning has to be aimed at a business problem (a report takes ten minutes and you need it in 30 seconds, a screen refresh is too slow, the overnight batch jobs don't finish until lunchtime - that sort of thing) and an AWR report does not help you unless you have already defined that problem. Also, many sites have not paid for the licence you need to use it.
Forum: Application Express, ORDS & MOD_PLSQL
 Topic: Create View Error Message
Re: Create View Error Message [message #678875 is a reply to message #678844] Sat, 18 January 2020 07:04
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome. I'm glad you found the culprit.
 Topic: Making select list - display and return values
Re: Making select list - display and return values [message #678873 is a reply to message #678838] Sat, 18 January 2020 06:44
petar97
Messages: 116
Registered: October 2018
Senior Member
How do I know where it is stored?

select name, id 
from sample$project_milestones
order by 1;
After using this code - ID value is same

[Updated on: Sat, 18 January 2020 06:44]

Report message to a moderator

Re: Making select list - display and return values [message #678876 is a reply to message #678873] Sat, 18 January 2020 07:10
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's how it goes: suppose you created a form on a table. One of items represents project milestones. Table (you based the form on) contains the ID_PROJECT_MILESTONE column which is - via foreign key constraint - related to SAMPLE$PROJECT_MILESTONES table that contains both ID and project milestone NAME.

In Apex, that item's type is SELECT LIST whose source is a SQL query that looks like the one you posted above.

Once you run the form and fetch data from the table, it displays values currently stored into that table.

Now, if you navigate to the item that represents the project milestone and select some other value from the list and push the SUBMIT button, Apex will perform an update action on that table and substitute the old project milestone ID value with the one you selected from the select list item.

In order to check it, go to e.g. SQL Plus or SQL Developer or Apex' SQL Workshop or run a report on that table and verify whether the change has been made.
Forum: Forms
 Topic: Language
Re: Language [message #678877 is a reply to message #678770] Sat, 18 January 2020 10:39
hissam78
Messages: 111
Registered: August 2011
Location: PAKISTAN
Senior Member
1/ Does AR8MSWIN1256 which is "Microsoft Windows Code Page 1256 8-Bit Latin/Arabic" support Urdu characters?
YES IT SUPPORT URDU BECAUSE NOT A BIG DIFFERENCE BETWEEN URDU AND ARABIC ALPHABETS.

2/ Does you Forms use this setting?
CAN YOU PLEASE TELL ME HOW TO CHECK FORM 6i SETTING.

3/ Does your database support these characters (i.e. what is its character set)?
FOLLOWING IS THE CHARACTER SET, I HAVE USED THE FOLLOWING SQL TO FIND THE VALUE

SELECT *
FROM v$nls_parameters
WHERE parameter LIKE '%CHARACTERSET';


PARAMETER VALUE

NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
Re: Language [message #678878 is a reply to message #678877] Sat, 18 January 2020 12:46
Michel Cadot
Messages: 66776
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

For 2. I can't tell but I know Littlefoot or cookiemonster can.
For 3. Do not check v$nls_parameters but NLS_DATABASE_PARAMETERS.

Also post the result of the following query from a client Forms workstation (not the database server):
Select distinct client_charset||' - '||client_version
from v$session_connect_info
where sid = sys_context('USERENV','SID')
  and client_charset is not null
/
 Topic: pdf file opening
pdf file opening [message #678879] Sat, 18 January 2020 15:20
knd.prasad
Messages: 32
Registered: December 2009
Location: HYDERABAD
Member
Hi,

Some pdf files located in server path '/u01/app' and file name '/u01/app/65845.pdf'

I want to open the pdf file from client by using web.show_document

url: http://newsys.com:9001/forms/frmservlet?

Any one help me on this.

Thank in Advance.






Current Time: Sat Jan 18 16:38:06 CST 2020