Username While Connecting To Sqlplus /as Sysdba

Mar 13, 2013

I am in a bit confusion about the user when we are logging in to sqlplus /as sysdba. what the user is when we are into sqlplus with sqlplus /as sysdba.

View 3 Replies


ADVERTISEMENT

Got Ora-12528 While Connecting To Sys As Sysdba?

May 18, 2010

I got ORA-12528 while i was connecting sys as sysdba from remote machine to theinstance which is started in nomount mode. Although tnsping for that instance is working.

View 2 Replies View Related

Server Administration :: Insufficient Privileges While Connecting (sys As Sysdba)

Apr 2, 2013

SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

The oracle 11g installed in eucalyptus cloud..

In the same server I can connect as a different user 'd6' but not as sysdba.

View 7 Replies View Related

How To Restrict Sqlplus As Sysdba

Apr 29, 2013

how to restrict sqlplus as sysdba

C:> Set Oracle_sid=Mydb
C:>sqlplus / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

I don't want to log in any one as sqlplus / as sysdba.If they can able to login as sqlplus / as sysdba then they can see others schema in the database.Say if i set

SQLNET.AUTHENTICATION_SERVICES=none

no one can log in as sysdba were as later some one changes to

SQLNET.AUTHENTICATION_SERVICES=NTS
After they changes to NTS they can log in and access other user details right ? how to restrict

Oracle version: Oracle 11 g
OS Version :Win 7

View 21 Replies View Related

Can't Login Into Sqlplus Even As A Sysdba

Sep 7, 2013

"C:UsersKarthikeyan>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sat Sep 7 17:42:37 2013 Copyright (c) 1982, 2013, Oracle.  All rights reserved. ERROR:ORA-12560: TNS:protocol adapter error  Enter user-name:" 

this is the first time i tried to open sql*plus and i didn't create any database connection before....so i don't have any username and password.......

View 20 Replies View Related

Client Tools :: Sysdba Access From Sqlplus?

Feb 8, 2009

I used the following command :
-------------------------------------------------
D:oracleproduct10.1.0Db_2jdkinjava -Djava.security.properties=D:oracleproduct10.1.0Db_2sqlplusadminiplusprovider -jar D:oracleproduct10.1.0Db_2oc4jj2eehomejazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell
--------------------------------------------------------

Output as follows:
--------------------------------------------
oracle.security.jazn.JAZNRuntimeException: Configuration file "configjazn.xml" does not exist. Check your JAAS configuration settings.at oracle.security.jazn.JAZNConfig.getJAZNProperties(Unknown Source)
... ... ...
Realm [iSQL*Plus DBA] does not exist in system.
-----------------------------------------------

what may be the reason for this error?

View 8 Replies View Related

Client Tools :: Can Login As SYS As SYSDBA Via TOAD But Not Via SQLPlus

Jun 21, 2013

I try to login as SYS@sid AS SYSDBA When I login via TOAD, I am able to. However, as in (1), all my attempts to login from command-line SQL *Plus fails. The error I get is ORA-1031 Insufficient Privileges Even if I am on the physical server and try to run the SQL *Plus, I get the same error -- Insufficient Privileges

Here are the environment details:

Server: Windows Server 2008 R2
Server: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

Client: Windows 7 Professional
Client: SQL*Plus: Release 11.2.0.1.0 Production

View 2 Replies View Related

Oracle Sqlplus Unique UserID / Username?

Oct 5, 2007

I each user in my table to have a unique username and user_id. So the table cant contain 2 users with the same user id and it cant contain 2 users with the same username.

oracle doesn't support more than one primary key in a table

so what could I use a secondary key?creating alternate keys in sql plus?

View 1 Replies View Related

Client Tools :: How To Find Username In Sqlplus

Aug 16, 2011

How to find user name in sqlplus?

View 5 Replies View Related

Sqlplus Error While Connecting To Database?

Mar 13, 2013

after connecting to database using username and password , i get below error message connection is established and able to work asusal,

Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
select 'Welcome to database: ' || name from v$database
*
ERROR at line 1:
ORA-00942: table or view does not exist

View 8 Replies View Related

Connecting Sqlplus To Oracle Server11g?

Nov 17, 2012

I have oracle db server 9.2.0.2 , I have a client connected with this server, the client has sqlplus 8.0.6.0

I adjust the tnsnames in the client with the following parameters :

myconn =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = my_sid)
)
)

this connection was successful

when I tried the same connection with oracle db server 11g (11.2.0.1)

this connection failed

how can i connect wih the new server 11g (11.2.0.1)

View 7 Replies View Related

ORA-01017 / Invalid Username / Password Logon Denied But SQLPLUS Works

Oct 15, 2012

"ORA-01017: invalid username/password; logon denied" when attempting to log on to db, in three different applications. Error is observed in Toad, Crystal Reports, and MS ODBC Administrator connect test. However, same db credentials work in SQLPLUS.

Customer is attempting to log into reporting database hosted by my company, and using Cisco VPN client.I am unable to reproduce this at this time, on my machine, using same credentials and VPN profile.

Here is what we know/tried:
 
1. PING HOSTNAME is successful on CUSTOMER’S machine

2. TNSPING HOSTNAME is successful on CUSTOMER’S machine

3. SQLPLUS is successful with USER2/(pw)@HOSTNAME.int on CUSTOMER’S machine

4. We corrected timeout error on CUSTOMER’S side, by adding TCP.CONNECT_TIMEOUT=1000 in SQLNET.ORA (Also observed extremely slow performance on CUSTOMER SIDE)

5. We corrected dns suffix problem on CUSTOMER’S side, observed in NSLOOKUP by adding: IP ADDRESS AND HOSTNAME to Windows HOSTS file and commenting out default suffix COMPANY.com from SQLNET.ORA file

6. VPN configuration and VPN credentials are good. 

We tested CUSTOMER’S VPN profle, CUSTOMER’S VPN credentials, and user USER2/(pw)@HOSTNAME on my machine (WIN7). I am able to maintain persistant connection to HOSTNAME for hours

7. TNSNames entries are good. Able to connect to db in Toad, and Crystal, on CUSTOMER’S machine using different Oracle user, USER3 (only has grant connect). Unable to logon to db, with Oracle user USER1, or USER2. (USER2 was created to try to resolve login problem w USER1, but issue still exists.)

8. CUSTOMER has Windows VISTA, does not have admin privileges, has Oracle 10 installed for client. Using same Cisco VPN client I have installed.

9. Database on our servers is 11g

View 11 Replies View Related

Difference Between #username And ?username In SPARE1 Column?

Oct 31, 2010

whats the different between a #username and ?username in a SPARE1 column?

View 5 Replies View Related

SQL & PL/SQL :: How To Get Output Without SYSDBA Privilege

Mar 2, 2010

A function returns the metadata of named objects (Directories, Users, Tablespace....) in the form of DDL. When i execute the function in the schema having the privileges of CONNECT, RESOURCE, DBA, SELECT ANY TABLE, UNDER ANY VIEW AND EXECUTE ANY PROCEDURE, function returns the empty clob without any error. But he same function created and executed in the User having SYSDBA privilege, we get output.how to get output without SYSDBA privilege ?

CREATE OR REPLACE FUNCTION SCHEMA.DBLINK
RETURN CLOB
AS
v_meta_handle NUMBER;
v_meta_handle_trans NUMBER;
V_DOC CLOB;
V_LOB CLOB;
[code]....

View 7 Replies View Related

PCI - Auditing Connect / As Sysdba - Connections?

Feb 15, 2012

I have a problem with a PCI DSS - requirement in Oracle 11.2. (PCI DSS = Payment Card Industry Data Security Standard)

Problem:

we connect via ' ssh -2 -X -l oracle hostname ' to the databaseserver and become os-user 'oracle'. we have also two offshore locations with dba's and each dba comes with his personalized user to the jumphost and then with the above ssh command to the database server.

the problem is that each dba becomes the oracle-os-account and can now connect with '/ as sysdba' to the database.in pci-dss this is not allowed !

now my question:how can I audit these '/ as sysdba'-connections and prove which user connected at which time with the '/ as sysdba' command ?

database is in audit mode. we log to syslog on linus redhat 5. I know one solution could be setting "SQLNET.AUTHENTICATION_SERVICES" parameter to "NONE" in sqlnet.ora file will make it not possible to connect to the database without a password as sysdba. (sqlplus / as sysdba). but we have to many applications and jobs and this is not really the solution in this case.

I think I can only solve this problem with personalized OS-user DBA-accounts in the dba-goup on os-site and os-user oracle should not be used for the future ?? I also need personalized dba-user-accounts in the database. using sys and system is not allowed. this users has to be locked and only for special administration work could it be unlocked.

View 3 Replies View Related

Security :: Unable To Logon As Sysdba?

Mar 3, 2005

I am working on oracle 9.0.1 version on XP.

Here I am unable to log as sysdba

I am doing like this

d:sqlplus /nolog
sql>conn /as sysdba

not working,giving an error then i tried

sql>conn sys as sysdba
again same error :_ insufficent Priv..

where as sql> conn system/manager working

View 21 Replies View Related

SQL & PL/SQL :: Grant Sysdba Privilege To User1

Oct 8, 2010

I grant sysdba privilege to user1. After that i connected with user1. But i could not shutdown the database.

View 3 Replies View Related

ORA-00257 - Archives Error And Impossible To Connect As Sysdba

Apr 8, 2013

I have a problem with my Oracle istance and so far I couldn't fix it, I have and Oracle 11g XE istance running on windows server 2003.A couple of days ago I received the error message "ORA-00257: archiver error".I found tips in this forum and wanted to apply but sqlplus doesn't recognize my SYS user/password. I type the correct password but no chance to log in.

If I try to connect using a client like Toad, I receive the message ORA-12170: TNS:Connect timeout occurred. I checked the firewall rules, but it's ok, moreover I was logging in in the past and any change has been performed on it. I learned it's possible to change SYS password.

If I connect as "/ as sysdba" on sqlplus I read "Connected to an idle istance".In order to connect as "/" I had to update sqlnet.ora and restart the service. The parameter SQLNET.AUTHENTICATION_SERVICES

was set as NONE ad I set as NTS. I should probably have to set it as ALL? I found out the orapwd utility to change SYS password throught password file for remote login as sysdba.

I tried to create that file, and when I ran the command it asked me the SYS password, I typed it and it created the file, so I guess the password I type is correct (I had the question to type it wrong). I didn't go to the next step as I wasn't sure to make the right thing and I don't want to make this issue bigger.

As long as I can't log in as sysdba I can't perform the actions mentioned in tips to fix the error 257, but I'm also wondering if the archive error can have a side effect and deny the action of update the SYS password.

View 2 Replies View Related

Forms :: Login As SYSDBA In Oracle From Normal Logon Procedure?

Apr 24, 2012

is it possible to login as SYSDBA in oracle forms from normal logon procedure?

logon(sys_acc, sys_pwd||'@'||:GLOBAL.db_conn);

The reason behind this is to make a form which will alter user's password. But all the users are in SYS account and it is necessary to login as SYSDBA in forms to execute alter statement.

View 4 Replies View Related

SQL & PL/SQL :: Get User_id When Given Username

Jul 16, 2010

I would like to retrieve user_id when I give username. Could I know which tables I need to be using for that.Example

SQL>@get_User_id Greg
b7dhgs
igh45g

where 'Greg' is a part of the name for 2 users.

View 11 Replies View Related

How To Know Password (Exact Password Not Hascode) Of All Users As A Sysdba

May 28, 2008

How to know the password(Exact password not hascode) of all users as a sysdba in Oracle 9i or 10g.How to convert hashcode password to Actual password.

View 1 Replies View Related

Oracle 9i Default Username And Password

Sep 14, 2003

I Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Developers Suite apps?

Also What URL should i type to access the "iSQL *PLUS" through my browser, so that i can execute my SQL statements.

View 3 Replies View Related

Forms :: Hide Username And Password?

Mar 21, 2011

I already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:

sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1

So when i run this show me the message:

File 'c: este.rdf=%' not found.

It's showing a '=' sign

View 1 Replies View Related

Forms :: Database Username Display

Jun 18, 2012

I want to display the current database username in a text field after logging in at run time,i.e after logging in the username should should display in a text field.e,g. if i login as scott then 'scott' should display in the text box.

View 3 Replies View Related

Server Utilities :: Username And Password In Exp / Imp?

Apr 26, 2011

While doing export/import we specify the username and password. Preferably which user do we need to specify? Sys or system or our own user?

View 9 Replies View Related

Executing Function To Return Username In Oracle

Feb 6, 2006

I have created a Package Body and Package Spec for a function to select a username and a password from a table and return the username.

The code i have created is this:-

CREATE OR REPLACE PACKAGE BODY USER_LOGIN
AS
FUNCTION user_select (USERNAME_IN VARCHAR2,
PASSWORD_IN VARCHAR2)
RETURN VARCHAR2 IS
USERNAME_OUT VARCHAR2(12);
BEGIN
[code]........

The package body and spec compiles successfully but i am having trouble when i execute this function. I am trying to do this :-

VARIABLE RETVAL VARCHAR2(12)

EXEC User_login.user_select('HELLO','HELLO',:RETVAL );

but i am getting the following error

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'USER_SELECT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

View 5 Replies View Related

Loop - Two Variables (username / Password) Not Clearing Out?

Apr 15, 2008

The idea of the program below is to create a sql "module" (just a .sql file) that will loop and ask for a user id until the user enters the correct one. Here is the code I have thusfar:

set serveroutput on;
accept username prompt 'Enter user name here: ';
accept password prompt 'Enter password here: ';

declare
usernameCONFIRM VARCHAR(30);
passwordCONFIRM VARCHAR(30);
begin
select USERID into usernameCONFIRM from GAMEUSER where USERID = '&username';

[code]...

The main problem I'm seeing is that the two variables I ask for (username and password) aren't clearing out.

View 12 Replies View Related

Forms :: Fetching Data - Retrieve Username

Sep 7, 2010

I have a detailed block with a user ID column. The user name is not available in the block. Therefore, I have created a non-database column to retrieve the user name into it.

Here is the code I've used.

PROCEDURE get_details IS

iLoop number := 1;

CURSOR c is

SELECT FULL_NAME
FROM GRP_EMPLOYEE
WHERE EMPLOYEE_NUMBER = :USER_ID;

[Code]...

However, it retrieves the first record only.

The results are displayed like this.

Loop: Result:

1 Full_Name
2 Empty
3 Empty
4 Empty

View 2 Replies View Related

Application Express :: XDB Requires Username And Password

Jun 1, 2013

11.2.0.1.0 g database.

I am trying for testing on test server where I am getting error while trying to connect

[URL].....

I am able to connect

[URL]........

and

[URL]......

The database version is 11g.

Actually my requirement is As I know we cannot use isqlplus in 11g we can use apex instead of isqlplus so any way or navigation how to use apex for isqlplus.

View 1 Replies View Related

Reports & Discoverer :: To Hide The Username And Password

Dec 20, 2010

I migrated the report from Developer 2000. This report has the drill down report with the following command.

procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;

After Migration into Oracle Application Server 10g release 2 , I changed the code as following:

function U_1FormatTrigger return boolean is
begin

SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem

When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.

I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved