Search This Blog

Total Pageviews

Saturday 24 January 2015

Oracle export as sysdba

Oracle export as sysdba


How to use "/ as sysdba" to exp and imp
How to use / as sysdba to exp
exp userid=\'/ as sysdba\'


*************************************************************************************************
-bash-4.1$ !sql
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 24 17:54:11 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> def
DEFINE _DATE           = "24-JAN-15" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "vihaan" (CHAR)
DEFINE _USER           = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
DEFINE _EDITOR         = "ed" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE      = "1201000100" (CHAR)


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

parafile 

-bash-4.1$ cat exp.par
file=mydump.dmp
userid="/ as sysdba"               <<<<<<<<<<----- with sys user 
compress=n
log=mydump.log
direct=y
full=n
owner=TEST
consistent=y
feedback=10000



-bash-4.1$ exp parfile=exp.par

Export: Release 12.1.0.1.0 - Production on Sat Jan 24 17:51:53 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
EXP-00105: parameter CONSISTENT is not supported for this user
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Direct Path ...
. . exporting table                           TEST
                                                         2803 rows exported
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.


done .....


-bash-4.1$ ls -ltr *.dmp
-rw-r--r-- 1 oracle oinstall 876544 Jan 24 17:52 mydump.dmp

Monday 19 January 2015

INS-40922 Invalid Scan Name - Unresolvable to IP address

INS-40922 Invalid Scan Name - Unresolvable to IP address in Grid installation 

Include scan IPs in host file and try again

nslookup mrac-scan
Server:        127.0.0.1
Address:    127.0.0.1#53

Name:    rac-scan
Address: 192.168.0.153
Name:    rac-scan
Address: 192.168.0.154
Name:    rac-scan
Address: 192.168.0.155


on all nodes

cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
################################################################
####### ---------------   eth0 - PUBLIC ------------ ###########
################################################################
192.168.0.49      mrac1.localdomain            mrac1
192.168.0.50      mrac2.localdomain            mrac2
################################################################
####### ---------------- eth1 priv------------------ ###########
################################################################
192.168.1.49       mrac1-priv.localdomain   mrac1-priv
192.168.1.50       mrac2-priv.localdomain   mrac2-priv
################################################################
####### -----------------VIP------------------------ ###########
################################################################
192.168.0.151      mrac1-vip.localdomain        mrac1-vip
192.168.0.152      mrac2-vip.localdomain        mrac2-vip
#################################################################
#                   SCAN IP           #########################################
################################################################
192.168.0.153 mrac-scan.localdomain mrac-scan
192.168.0.154 mrac-scan.localdomain mrac-scan
192.168.0.155 mrac-scan.localdomain mrac-scan
#################################################################








Oracle DBA

anuj blog Archive