PL/SQL :: Overcome Prompt User ID And Password To Connect Oracle DB From Unix Environment?
Mar 23, 2013How to overcome the prompt user id & password to connect oracle DB from Unix environment.
View 2 Replies
ADVERTISEMENT
Client Tools :: UNIX User In Group Dba But Cannot Connect As SYS?
Jun 4, 2012> id -a
uid=56088(appadm) gid=50120(dba) groups=50120(dba)
> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 09:26:23 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name: ^C
our UNIX user in group "dba" but can't connect as SYS
why?
Data Guard :: Change Non-SYS Password On Oracle 11g Environment?
Jul 26, 2012how to change non - SYS oracle users' password in data guard envirnment. We all know that for SYS password change in data guard. DBA has to change in primary database by either "alter user SYS identified by xxxx" or create password file with orapwd.
Then scp password file to standby database. However, if I want to change SYSTEM or DBSNMP passwords, I change on primary with " alter user ....." SQL, then new passwords will be login dictionary. But this new SYSTEM pqssword will be shipped with redo log to standby and SYSTEM password on standby will be updated? I need technical answer on this question
PL/SQL :: Connectivity Code To Connect Oracle DB In UNIX?
Jun 13, 2013i need a connectivity code to connect oracle DB in UNIX.pls send me a code exactly.
View 2 Replies View RelatedEfficient Way To Connect SQL Server From Oracle Which Is Running On HP-UNIX
Mar 8, 2011I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.
View 1 Replies View RelatedForms :: Reports In Unix Environment
Mar 23, 2010Below is my code for calling a report from form in windows environment. I want to use the same report to be called from Unix environment . When m using application server tbanner@.... instead of 'repsrv@ahad-pc' is throwing error its in UNIX environment
REP-51002: Bind to Reports Server tbannerdb.kfupm.edu.sa failed
Declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=abdulahad/inshalla@test';
v_report_serverVARCHAR2 (30) := 'repsrv@ahad-pc';
v_report_nameVARCHAR2(100) := 'test3.rdf';
[code].......
Client Tools :: How To Use Unix Environment Variables
May 25, 2011An application uses one user as a container of objects(this user is stripped of ALL privileges), and other users that can access objects in this unique schema depending on their privileges.
There can be multiple installations of the application in one database, therefore many such schemes. An environment variable APP_UNIQUE_SCHEMA points to a current unique schema.
So instead of typing
select * from my_unique_schema.my_table I want to set a current schema for sqlplus session in glogin.sql.
It would have been nice if I could have entered in glogon.sql the following line
alter session set current_schema=$APP_UNIQUE_SCHEMA;
BUT it does not work. sqlplus does not resolve the reference to an environment variable. I cannot figure out how to get the value of an environment variable in sqlplus.
Security :: Creating Wallet - System Does Not Prompt For Password
Apr 14, 2011I'm trying to hide the password for the batch programs that connect to the DB Server
as Cadot pointed out in
[URL].........
Quote:
use secure external password store
with reference to
[URL].........
when I create wallet, the system does not prompt me for password
C:>mkstore -wrl "C:ora102NETWORKADMIN" -create
when creating login credentials, again the system never prompts me for password
C:>mkstore -wrl "C:ora102NETWORKADMIN" -createCredential db10g scott tiger
here's my sqlnet.ora configurations
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =C:ora102NETWORKADMIN)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSESSL_VERSION = 0
here's my tnsname.ora settings
DB10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mike)
)
)
here's the outcome
C:Documents and SettingsAdministrator>sqlplus /@db10g
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 13 22:53:06 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12534: TNS:operation not supported
Enter user-name:
so I Google around for the solution to the ORA-12534 error, one of the site,
[URL].......
here's my lsnrctl services
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "MIKEXDB" has 1 instance(s).
Instance "mike", status READY, has 1 handler(s) for this service...
Handler(s):
[code].....
The command completed successfully
right now I think I will be a fool to think that the solution is to resolve the ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. so what is wrong with my setup, or is it some patch that I need to apply?
Client Tools :: Not Able To Launch Sql Prompt After Entering Username And Password?
Oct 17, 2011I have installed Oracle 10 galso changed the password of Scott,System users during installation via passwordmanagement. When I am click on sql plus icon to launch sql and entering user name : Scoot pwd :Tiger
It get closed and nothing is coming up.
Client Tools :: How To Connect From Client To Oracle Database In Unix
Dec 11, 2012I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1
when I try
# sqlplus
username :xxxxxxx
password : xxxxxxx
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
SQL & PL/SQL :: Disconnect And Connect Sql Prompt In Loop Using Script File?
Nov 23, 2011I want to disconnect and connect sql prompt in loop using script file.But whenever I try to do this it is giving error,check the below code.I save below code into some file and call that file using @"filename.sql", it won't work.
Basically I want to run one procedure in loop, and in each loop counter I want to disconnect the session and connect again. Becaue CONN and DISC not working while calling through @"..."
DECLARE
BEGIN
FOR N IN 1..5 LOOP
DISC
CONN SCOTT/TIGER@TEST;
EXEC MY_PROC;
END LOOP;
END;
Server Administration :: Unable To Connect Both SQL And RMAN Prompt?
Jul 21, 2011now DB is hanging; i am not able to connect both SQL and RMAN prompt. Is it possibel to move some old archives using ASMCMD prompt to datafile mount point location? Once i got some free space, then i can try connect RMAN and fire my script manually to take the backup and delete the same. ....
ASMCMD [+QSTAGE_T1_BACKUP_01/QSTAGE/ARCHIVELOG] > ls -ltr
cdType Redund Striped Time Sys Name
Y 2011_07_15/
Y 2011_07_16/
Y 2011_07_17/
Y 2011_07_18/
Y 2011_07_19/
Y 2011_07_20/
i have free space at mount point : +QSTAGE_T1_DATA_01/QSTAGE/DATAFILE
i need to backup the archives first before deletion..as those are required for Streams.
backup script:
run {
backup archivelog all delete completed before 'sysdate-1';
}
note: i would like to remove the file which are older than one day
Prompt User For Value
Apr 29, 2010What is the function to prompt a user for a value when running a script and where would it be used?
I was also wondering if it is possible to populate a list from a table that would be displayed in a drop down box for the user to choose from?
Security :: Create Password File / Don't Know Password Of Sys User
Jun 5, 2012I want to know what if any person don't know the password of SYS, can he create password file, becauase i dont know the password of sys users, generally login with '/ as sysdba',
View 4 Replies View RelatedSQL & PL/SQL :: Overcome Recursive Triggers In Oracle?
Jul 14, 2012How can we overcome recursive triggers in oracle SQL?
View 7 Replies View RelatedClient Tools :: Connect Database On Unix And Windows
Jun 24, 2013How I can connect database on unix OS and windows what is the deference.
View 7 Replies View RelatedPL/SQL :: User Session Has Expired And Enable User Without Changing The Password
Aug 13, 2012User session has expired. I have to enable user without changing the password of the user.
View 1 Replies View RelatedSecurity :: User Locked / Track User Who Hit Wrong Password
Dec 21, 2010We have the database user called c88888 and is locked yesterday. I came to this with the following query.
select * from dba_users where username like 'C88888';
Due to invalid password the user was locked. Can we track who hit the database with the wrong password?
Forms :: Client-server Environment - Unable To Connect To Destination
Nov 29, 2010i am using client-server environment without using a domain.On One computer i have installed Oracle 8.0.5 and developer 2000. and on client side i have installed form 6i. i have made a service (star) in Tnsnames.ora in client side.
star.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROtoCOL = TCP)
(Host = server)
(Port = 1521)
)
)
(connect_DATA = (SID = ORCL)
)
)
--------------------------------------------
it gives me error:
ORA-12203:TNS :unable to connect to destination
SQL & PL/SQL :: Password To Connect To Database
Oct 24, 2010I extracted the script of creating user in my database in SQL navigator and Toad tools but it is displaying encrypted password. But I am unable to connect with that password.
To get the original password then I will be able to connect my database.
Unable To Connect OE Once Change Sys Password
Jan 7, 2013some days ago we chaged sys,system and sysman password using SQL console. ORACLE 10.2.0.1.0 Now Backups and SQL console loggins are ok but we cant connect OEM console having: insufficient privileges, logging as sys / as sysdba
we reload (start / stop) oem console service and now the OM page is unable to be desplayed having (when starts finished no error messages was found):
The webpage cannot be found
or
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
but all is OK !!The DB SO is linux unbrekeable.
Connect Using Mysql Command Line - Null Password Given
Feb 22, 2010When I try to connect using the mysql command line, I keep getting an error, I type this exactly:
SQL > Connect
Enter user-name: system
Enter password: (left blank b/c i can't type anything there)
and when I press enter I get the error, null password given, login denied.
SQL & PL/SQL :: How To Get User Password
Mar 20, 2012Find out the password of his / her any user in oracle , in readable form? if yes then how?
View 15 Replies View RelatedUnix Command Run Successfully Through PL/SQL But Showing No Impact In UNIX?
May 19, 2007I am using Oracle 9i and Unix on my system and trying to execute a UNIX shell command through external procedure in C.I created a shared lib (libextproc.so) for the following function.
int sysrun(char *command)
{
return system(command);
}
This function runs fine when caled through a driver function in C, meaning that the shared lib is fine.In PL/SQL, I have used the following method to invoke a UNIX command:-
create or replace library shell_lib as '/home/ECETRAonsite/oracle/OraHome1/lib/libextproc.so';
/
create or replace function sysrun (syscomm in varchar2)
return binary_integer
as language C
name "sysrun"
library shell_lib
parameters(syscomm string);
/
Now when I call this PL/SQL function to invoke the command, it is run succesfully but does not create the file.
SQL>
1 declare
2 rc number;
3 begin
4 rc := sysrun('/bin/touch /home/ECETRAonsite/oracle/OraHome1/test/sach');
5 dbms_output.put_line('Return Code='||rc);
6* end;
SQL> /
Return Code=0
PL/SQL procedure successfully completed.I have verified that the path for 'touch' is correct.Following are my configuration files.
listener.ora
-------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
[code]...
Security :: User Password Expired?
Nov 11, 2011i am using a oracle server. And all my users password has been expired, is there any way to recover those users without failing my data.
View 19 Replies View RelatedForms :: Hide User Name And Password?
May 4, 2010when i want to call report from form how i can hide user name and password from the link in 10g ??
View 1 Replies View RelatedSecurity :: Create User With Non Expiring Password
Jul 7, 2011I want to create oracle user with non expiring password or i want to create one oracle user and set the password as non expiring.
View 9 Replies View RelatedSecurity :: How To Generate User And Password Manually
Aug 27, 2012i forget my system password and i can't login to my database,and its not letting me in as sys/manager as sysdba...how to generate new user and password....
View 13 Replies View RelatedSQL & PL/SQL :: How To Change User Password In Stored Procedure
Sep 9, 2010OBJECTIVE: To allow a user to change their own password after logging into an application.
BACKGROUND: I have a stored procedure where I pass the userid, old password, and new password. The stored procedure contains the following ALTER statement:
EXECUTE IMMEDIATE 'ALTER USER :uid
IDENTIFIED BY :npwd REPLACE :opwd'
USING IN v_user_id, v_new_pwd, v_old_pwd;
where v_user_id, v_new_pwd, and v_old_pwd are the arguments passed to the stored procedure.
FACTS:
(1) The procedure compiles fine;
(2) During execution, SQLCODE returns "0" (i.e. zero);
(3) My userid does have permission to change my password and execute the stored procedure;
(4) At the time I call the stored procedure, I am successfully logged into the application with my userid and old password.
PROBLEM: When I try to login with the new password I get the following error: "ORA-01017 invalid username/password; logon denied".
Express Edition (XE) :: What Is Default User Name And Password
Nov 29, 2012I am a new to Oracle, Installed Oracle 11g express edition. Also I had installed Oralce SQL Developer tool but i don't know the user name and password to connect.
what is my default instance? what is my default user name and password? How to connect ?