suresh sargar

Greenhorn
+ Follow
since Feb 10, 2009
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by suresh sargar

Hi VijayPal,

Any sample set of question you referred for CCDH4? I am planning to buy dummy question bank from HadoopExam.com.

Currently i am reading Definative Guide 4th Edition.

Please comment.
8 years ago
Hi All,

I know that this not a JAXB blog, but i feel this might be right palce to discuss about JAXB issue.

I am facing issue JAXB XSD to Java Class conversion.

i have more than 10 XSD which are internally reference to each other. for 2 XSD the complex object have same name causing name conflicts issue.

As a remedy for this i prefer to go with external ( binding.xjb) i specified both XSD with the field while running through Maven i am getting error like mentioned .XSD is not under compilation path.

I don't understand which compilation path it referring to...

pom.xml have correct entry for XJC- tag and even i have specified schema and binding tag into it, but doesn't understand what compilation path it's look for.

Please comment.
8 years ago
Hi ,

i am getting below error when i tried to connect to the database using JDBC on local box.

2011/06/10 19:06:45
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
ssagar-pun-01:1621/ORA102DB

i provided below value as i/p. e.g hostname, listener port ,username, pwd ,query

ssagar-pun-01 1621 ORA102DB pat1 pat1 "select * from v$instance"

i am using dyamic listener for static listener it's working fine but for dynamic it's not.

SQL> show parameter local

NAME TYPE VALUE
------------------------------------ ----------- ---------------------------
local_listener string XYZ


from tnsnames.ora

XYZ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSAGAR-PUN-01)(PORT = 1621))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA102DB)
)
)

from listener.ora
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSAGAR-PUN-01)(PORT = 1621))
)

lsnrctl status
LSNRCTL> status LISTENER1
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SSAGAR-PUN-01)(PORT=1621
)))
STATUS of the LISTENER
------------------------
Alias LISTENER1
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 10-JUN-2011 18:57:29
Uptime 0 days 0 hr. 5 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\network\admin\listener.ora
Listener Log File D:\Oracle10g\network\log\listener1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SSAGAR-PUN-01.adprod.bmc.com)(PORT=1
621)))
Services Summary...
Service "ORA102DBXDB" has 1 instance(s).
Instance "ora102db", status READY, has 1 handler(s) for this service...
Service "primary" has 1 instance(s).
Instance "ora102db", status READY, has 1 handler(s) for this service...
Service "primary_XPT" has 1 instance(s).
Instance "ora102db", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

i don't have sqlnet.ora in my environment currently .

i am confused why it's not working for dynamic listener.

Thanks,
Suresh.

i connected with SYS user ..still i am not able to drop the user.and how can i find it that any user is executing currently? if i restart the database will other execution get stop so that i can try to drop that user.
14 years ago
hi All,

i need to drop my local database user as a part of test i tried to put "drop user "******" cascade in sql file and tried to run it;

but it's giving error stating that
*************************************************

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

***************************************************

please help me, what's may be cause?

thanks in advance

Suresh
14 years ago
Hi all,

could you please help to let me know how to find out if any of the datafiles was resized?

thanks in advance,
Suresh.
14 years ago
i want to create silent oracle instance creation using following script


dbca -silent -createDatabase
-templateName D:\Oracle9i\ORA92\ORA92Template.dbt
-gdbName ORA92
-sid ORA92
-datafileDestination E:\Oracle9i\ORA92


i have Oracle9i is existing oracle directory and now i want to create another instance as a destination E:\Oracle9i\ORA92

i tried with same script but its giving error in log as

Template D:\Oracle9i\ORA92\ORA92Template.dbt does not exist. Please specify an existing template for database creation.

please give me suggestion.


thanks in advance,

Suresh
14 years ago
Integer i3 = 10;
Integer i4 = 10;
if(i3 == i4) System.out.println("same object");
if(i3.equals(i4)) System.out.println("meaningfully equal");


This example produces the output:
same object
meaningfully equal

but when i tried i3=i4=1000 (greter than 127 ) i3 & i4 are not equal.can anyone tell me how its works..?
15 years ago
i want to find particular string from whole database where it is how many times present in database.

e.g i want to find string "xyz" in whole database

can anyone suggest me...?
15 years ago
please help me for the query..

i want tablename and row count of each table.

i knew one query select table_name ,num_rows from user_tables;

but if i update some table that updated row count will be not gettting with this query...

can you suggest me any other query how to get updateable result..?
15 years ago
yes i agreed this is related to timeout. but even i increase time interval 15 min or 30 min .then still this error occours..

on SQL prompt query takes hardly less than 5 seconds... there is only one connection with jdbc..
"ORA-01013: user requested cancel of current operation
" encountered while processing query to database .
Query: select a.tablespace_name, file_name, round(bytes/1048576,2), round(maxbytes/1048576,2), round((user_bytes - NVL(free_bytes,0))/1048576,2), autoextensible from dba_data_files a, dba_tablespaces b, (select file_id, sum(bytes) free_bytes from sys.dba_free_space group by file_id) c where contents = 'PERMANENT' and b.status = 'ONLINE' and a.tablespace_name = b.tablespace_name and bytes is not NULL and maxbytes is not NULL and user_bytes is not NULL and c.file_id (+)= a.file_id order by 1



i got this error to particular oracle database.this query works with terabyes of database. but certain databases giving above error.

i used this query with jdbcdriver in java. on SQL prompt of same machine query works fine.

please give me suggesion..what the root cause for failing through jdbc ?