Localhost Doesn't Work In Listener.ora Or Tnsnames.ora
Jul 29, 2010
I want to be able to use "localhost" in my tnsnames.ora and listener.ora files but for some reason its not working.
just concentrating on the listener, when I have the following in my listener.ora the database doesnt register with the listener:
########################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
########################################
This is even after using the "alter system register" command. I'm checking whether my database is registering using "lsnrctl services".
With the following in listener.ora all is fine:
########################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.152)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
########################################
So why wont it work with localhost?! I'm running Oracle 11G on XP Pro.
View 7 Replies
ADVERTISEMENT
Jul 28, 2010
I was working on an applications program It is written in PL/SQL . It is running on an oracle 8i database It was not written by me but now I am responsible of it. I made some changes to database tables for this years regulations. Everything was working fine but yesterday I have recompiled two of the packages for some regulations and one of the procedures was stopped working.
It is called 'sayfa2'. Packages names are 'aday1' and 'aday2'. They both have a procedure called sayfa2 and both of them don't work now. They gave me no compilation errors. All I did is I have copied the original code from toad and compiled it at sqlplus I have changed nothing except some texts inside html tags. I couldn't guess what is wrong.
It actually converts to html pages. All procedures are working fine except sayfa2. aday1 is for to fill information and submit but when I click submit button it gives an error:
The requested URL /pls/kon/aday1.sayfa1 was not found on this server. Oracle HTTP Server Powered by Apache/1.3.19 Server at ...
There is also a problem with Turkish characters they don't appear correctly.
Below is sayfa2 and I also added aday1 package could you have a look at it .
PROCEDURE sayfa2(stuid VARCHAR2,tckimlik VARCHAR2, ad VARCHAR2, ad2 VARCHAR2, soyad VARCHAR2,
sex VARCHAR2, mdurum VARCHAR2, bad VARCHAR2, aad VARCHAR2,
dyer VARCHAR2, dgun VARCHAR2, day VARCHAR2, dyil VARCHAR2,
nil VARCHAR2, nilce VARCHAR2, nkoy VARCHAR2, cilt VARCHAR2,
asira VARCHAR2, sira VARCHAR2, asuba VARCHAR2, kang VARCHAR2, agorev VARCHAR2,
[code].......
View 10 Replies
View Related
May 7, 2013
I have a master block (MASTER with Item 1 and 2) and details block (DETAILS). If the user enters the query mode and queries the Master block, the Details get populated automatically. So far so good.
Now I attached an LOV to Item 1 in the Master Block and the requirement is that when the user picks an item in the LOV, the details should automatically populate. Because of "restricted procedures" (GO_BLOCK) in triggers, I put a Button in a Control Data Block and the code in the WHEN-BUTTON-PRESSED trigger is as follows :
GO_BLOCK('DETAILS');
EXECUTE_QUERY;
It does go to the Details block and also displays all the details. However, when I try to update, insert or delete data, it fails with "Insufficient Privileges". So when I looked at the query being executed (Cntrl + Shift + E), I can see that it is trying to perform these operations on the Master block. (ie for some reason the scope is still in the Master and not Details even after Go_Block(DETAILS) has been executed.
I then tried to use Go_Item('DETAILS.Dept_No') to see if that would work. That too did not work. I tried to set the Navigation Style on these Data Blocks to "Change Data Block". Still no success.
View 3 Replies
View Related
Jan 11, 2011
It shows me error when i create a table with column name as UID.
Is UID a inbuilt function or anything else?
View 2 Replies
View Related
Mar 8, 2011
im now doin' my currently program, actually they requesting for an update. I added birth date column in the module,they asked to the request to put a validation on date, such as:
a. under age
b. :txt_ph_birthdate > SYSDATE
c. if :txt_plan_type = 212 then
17 yrs, 5 mos and 29 days and 40 yrs, 5 mos and 29 day - as validation
d. if :txt_plan_type = 214 then
40 yrs and 6 mos and 55 yrs, 5 mos and 29 days - as validation
e. if :txt_plan_type = 215 then
17 yrs, 5 mos and 29 days and above - as validation
they also instructed me to put the validations in birth date after the column of birthdate, which is the :txt_plan_type(list_item) and i put it in TRIGGER (when-validate-item)after i did the codes and compile it., theres no message for error but i think its not working..it working. i already updates also the insert and the other trigger and procedure, i just add the plan type on it.
i havent edit the save button because the as i read the codes the it just call the procedure that i edit.when i run the program and after i encode the data..and when i press the save button, nothing happens or any confirmation.in addition, why is it that my validation on age doesnt work?
heres the
declare
n_months_between NUMBER;
d_same_day_occur DATE;
n_years NUMBER;
n_months NUMBER;
[code]...
View 8 Replies
View Related
Sep 19, 2011
I installed Oracle 10g. Then I created an instance. After the instance was created, I went to OEM to look at the instance, and noticed it wasn't turned on. I went to the network folder and noticed I only had sqlnet.ora; no Listener.ora or tsnames.ora. I put the files there, but when I try to startup the instance, the password and usernames I created with the database don't work. Agent Connection to Instance failed Listener down
View 14 Replies
View Related
Jan 27, 2011
I'm trying to make a div that is hidden at the top of a page until you click support, and then it slides out. I've got this working fine in FF, but in IE it's really choppy.
View -1 Replies
View Related
Aug 28, 2007
The following script doesnt work.
DELETE
FROM PSPROJECTITEM I
WHERE I.PROJECTNAME = 'TEMP1'
and (I.OBJECTTYPE between 79 and 84
or (I.OBJECTTYPE = 58
and I.OBJECTID1 = 104
[code]...
It gives the following error:
Error at Command Line:12 Column:6
Error report:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
View 7 Replies
View Related
Mar 28, 2010
I've installed without problems Oracle 8.0.5 on WS 2003. After installation I've created 8 databases, with the utility Database Configuration Assistant (dbassist, executed by launch80.exe).
After that, the DBAssist doesn't run anymore.
I've tried EVERYTHING. And I have no success, Im stuck. And I need to create several databases.
View 1 Replies
View Related
Oct 10, 2012
We have troubles with import of transportable tablespace, when i try to import it with system the import is done currectly, when i try to use another user we receive this message :
impdp bmcese/***** directory=TTS_DIR dumpfile=RMCCO_RMC_ANA_STS_ABB_CO121001.dmp TRANSPORT_DATAFILES=/data/TTS/RMCCO_RMC_ANA_STS_ABB_CO121001.dbf logfile=tts_imp_proc.log
ORA-31626: il job non esiste
ORA-31633: impossibile creare la tabella principale "BMCESE.SYS_IMPORT_TRANSPORTABLE_05"
ORA-06512: a "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: a "SYS.KUPV$FT", line 1020
ORA-00959: tablespace 'RMCCO_RMC_UTZ_PP080531' inesistente
this happens only on development server and it work into test server, so i don't think that the problem is in grants(i controlled that are the same and i have tried with DBA grant too and we received the error).Another strange thing is that tablespace 'RMCCO_RMC_UTZ_PP080531' is not included into the dump that i try to import and it doesn't exist in the database.
View 4 Replies
View Related
Apr 17, 2012
I have the following problem on a 10.2.0.4 Oracle on AIX 1.6..I have 2 RAC nodes as the node # 2 goes down, the VIP migrated correctly to the node # 1, but the listener # 1 do not see the change, and just resolve to the local ip.
The same does not apply in the reverse case, when it drops the node N 1, the listener attends to the fallen VIP node and migrated.The configuration is correct and identical in both nodes, according to the documentation, but I can not find a reasonable answer.
IP node # 1.
scm1or01 192.68.60.11
scm1or01-VIP 192.68.60.13
IP node # 2
scm1or02 192.168.60.12
scm1or01-VIP 192.168.60.14
when scm1or02 is down: scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 11-APR-2012 19:56:46
Copyright � 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCM1OR01
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 11-APR-2012 16:50:19
[code]...
I do not understand the reason, I've rebuilt the configuration of the listener, and netmgr netca tools, but the problem persists
View 3 Replies
View Related
Jul 15, 2010
I am using Oracle 10g and when i start my server then my database is running and my application use this database.But after 15 min automatically application show this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
View 1 Replies
View Related
Apr 17, 2012
I have the following problem on a 10.2.0.4 Oracle on AIX 1.6...
I have 2 RAC nodes as the node # 2 goes down, the VIP migrated correctly to the node # 1, but the listener # 1 do not see the change, and just resolve to the local ip.
The same does not apply in the reverse case, when it drops the node N 1, the listener attends to the fallen VIP node and migrated.The configuration is correct and identical in both nodes, according to the documentation, but I can not find a reasonable answer.
IP node # 1.
scm1or01 192.68.60.11
scm1or01-VIP 192.68.60.13
IP node # 2
scm1or02 192.168.60.12
scm1or01-VIP 192.168.60.14
Below I write as I detect the problem: when scm1or02 is down:
scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 11-APR-2012 19:56:46
Copyright © 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
[code]...
Also the listener.ora in scm1or01 starts how LISTENER, but the crsstat says:
scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin>crsstat listener_scm1oro1 ONLINE
I do not understand the reason, I've rebuilt the configuration of the listener, and netmgr netca tools, but the problem persists.
View 5 Replies
View Related
Jul 25, 2011
When i'm trying to connect my already-existing database, i get an error: "ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.The Connection descriptor used by the client was: localhost:1521:xe".
i can't loose the builted tables and the information stored in them.My listener.ora file is :
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
[code]....
View 36 Replies
View Related
Oct 14, 2011
How to know the oracle port no on localhost machine.
View 1 Replies
View Related
Jan 31, 2012
Is there a way to put on tnsnames.ora the alternative IP of a server that if the first dont respond it tries the ip of the second? Example:
ORA92 =
(DESCRIPTION =
(ADDRESS_LIST =
try
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
except
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))
end )
(CONNECT_DATA =
(SERVICE_NAME = tsh1.world)
)
)
View 6 Replies
View Related
Jan 4, 2011
I have several environment that are physically not connected to each other (except network). Each environment has its own tnsnames.ora. I have downloaded every tnsnames.ora into C:\OraHome1\network\ADMIN, so TOAD opens connect dialog using the file currently named 'tnsnames.ora'. Every time I need to switch to a different environment (and to different connection string) I have to manually rename the 'tnsnames.ora' into something like 'tnsnames.ora.environmentA' and rename another 'tnsnames.ora.environmentB' into 'tnsnames.ora'.
This is inconvenient and time consuming task as I have to restart TOAD after every rename.if there is an easier way to use multiple tnsnames.ora without renaming those.
View 1 Replies
View Related
Apr 22, 2013
Possible to call a tnsnames file from master tnsnames like the principle of ifile in the init.ora...My primary tnsnames.ora has a lot of development entries which are repointed frequently, it would work with logistics if I could manage these in a second tns file and load from primary so when my dev instances are repointed I'm not editing the master tnsnames
View 4 Replies
View Related
Feb 15, 2013
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
View 0 Replies
View Related
Mar 11, 2010
I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.
also,everytime when i give lsnrctl>show current_listener it is showing "listener"
i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.
View 8 Replies
View Related
Jun 19, 2012
Way to share or manage the TNSNAMES.ORA file for all oracle clients in same place?I already have a TNSNAMES.ORA configured and running in the machines (locally).The problem is that any change done( ip, port etc), imply in update all files in all the Oracle clients
View 1 Replies
View Related
Apr 3, 2008
I'm trying to connect to my DBs.I installed Oracle Client 10g, but PLSQL Dev. 7.1.4 doesn't find my tnsnames.ora.
View 4 Replies
View Related
Jun 20, 2012
I am completely new to anything with Oracle or OCI,
Also, basic information:
Language: C
Oracle DB version: 11g
Trying to use OCI
I am trying to write a client that connects to an Oracle database and gets some information (obviously). On the OCILogon() step, I need the username, password, and db address. However, someone said there will be a tnsnames.ora file, and that should be enough.I've searched online and I have not been able to find anything that relates OCILogon() to tnsnames.ora, so here are my questions:
1) Can OCILogon() use tnsnames.ora at all?
2) Is there any other function that I should use instead of OCILogon() that would work with the tnsnames.ora
View 2 Replies
View Related
Jul 5, 2010
In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?
As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.
View 4 Replies
View Related
Jan 13, 2013
we have an issue when we are using sql loader with address at command line as below.
sqlldr user/pass@"(DESCRIPTION\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=host)(PORT\=1521))(CONNECT_DATA\=(SERVER\=DEDICATED)(SERVICE_NAME\=sname)))" control=ctl_filename log=file_name
Ideally we need to include description in tnsnames.ora but its taking time to contact DBA here. Hence we tried with this work around. The same is working fine if we are using sqlplus but sqlloader gives this error.
LRM-00116: syntax error at 'ADDRESS' following '('
SQL*Loader: Release 11.2.0.2.0 - Production on Thu Jan 10 21:31:32 2013
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-100: Syntax error on command-line
our environment: ORACLE 11.2.0.2, UNIX AIX 5.3
View 1 Replies
View Related
Jun 10, 2011
How to find out the database TNSNAMES.ora file if there are multiple .ora files with different names in Oracle_home/network/admin directory ?
View 6 Replies
View Related
Dec 28, 2010
we have an environment with many Oracle databases in different versions (v8, V9, V10 and V11). Besides that, there are many versions of the Oracle Client in use, ranging from V6 to V11. Many of the clients have a TNSnames.ORA and as was to eb expected, many of these are old as well with a lot of (by now) invalid information in there.
Is there any reasonable maximum size to the TNSnames.ORA file?What are the consequences from going over the max size? Are there alternatives to using TNSnames.ora which you would recommend?
View 4 Replies
View Related
Oct 5, 2011
I need to Update Oracle tnsnames.ora file with the some new entries ....i was looking for ora 92, but could not find a proper link to download.now I have oracle 11 g, but i cant find tnsnames.ora file in that...is it because my installation was not proper...
View 1 Replies
View Related
Apr 28, 2010
what the purpose of tnsnames file does? Does it need to be on the client workstation and what should be it's correct location?
View 2 Replies
View Related
Apr 19, 2011
We are preparing a script for purposes of cold backup.
We have already listed the Oracle binary files except for the tnsnames.ora and the password file.
show tnsnames.ora path using SQLPlus?
View 6 Replies
View Related